[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1082
  • Last Modified:

SQL 2012 can't find BIDS for it..

I have windows 8,  and have installed VS2012 Developer..  I have installed everything with 2 instances one for multidimensional and one for tabular analysis.. In SQL I can find and open the SSAS..

I have VS 2012 installed.. From what I see I should have created another VS for 2010 because this is what SQL 2012 uses..  But.. I didn't get it.. And I did a search for the program in case it didn't get on the desktop, but only see SQL 2012 installed..  I looked in 2012, but I don't see any thing for SSIS or SSAS in it.. (I have in the past used Bids in SQL 2005 and SQL 2010 on other computers, so I think I would find it if it was there)..

I thought I saw something that said there was something I could download and install that had renamed BIDS to SSDT and would now install in the VS2012.. But installing it, it seemed to only be installing a SQL express, and my VS2012 showed no extra features for SSIS or SSAS after the install (Nor did I see a seprate VS2010 with SSIS & SSAS)..

Where do I go from here?
0
moosetracker
Asked:
moosetracker
  • 7
  • 4
2 Solutions
 
lcohanDatabase AnalystCommented:
I suggest you download and install SQL 2012 Developer edition and that should give you all Enterprise like modules/features.

"
* The Web, Developer and Express editions are available in the SQL Server 2012 release. For more information, please refer to the 2012 SQL Server Datasheet and FAQ.
"
http://www.microsoft.com/en-us/sqlserver/editions.aspx
0
 
moosetrackerAuthor Commented:
Why download it, when I have the SQL 2012 Developer edition purchased and installed?  Did they leave out features in the purchased copy?
0
 
lcohanDatabase AnalystCommented:
Do you really have SQL Server 2012 Developer or just "I have windows 8,  and have installed VS2012 Developer"??
0
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
moosetrackerAuthor Commented:
On the box of the Product it Reads :

"Microsoft SQL Server 2012 Data Management and Business Intelligence Software Developer"

I also have installed it on windows 8 and also have on this system VS2012 Professional
0
 
lcohanDatabase AnalystCommented:
OK so you have VS 2012 and SQL 2012 Developer installed right? in VS 2012 you can use indeed SQL Server Data Tools as I don't think BIDS made it there yet - see below from VS team:

http://social.msdn.microsoft.com/Forums/vstudio/en-US/f800376f-c782-4500-8423-22fb1374cae4/visual-studio-2012-ultimate-business-intelligence?forum=vssetup

Sorry I thought you have an issue with SQL Server Developer Edition itself and just reading over your question again I noticed you ask about BIDS as well - hope this is the right answer to your BIDS question.


There's also the SSDT which is the "BIDS" replacement for developing SSIS, SSRS and SSAS stuff. As of March 2013, it is now available for the 2012 release of Visual Studio. The download is labeled SSDTBI_VS2012_X86.msi Download link (below) is "Microsoft SQL Server Data Tools Business Intelligence for Visual Studio 2012"

http://www.microsoft.com/en-gb/download/details.aspx?id=36843
0
 
moosetrackerAuthor Commented:
OK now I think we are both on the same page..

Yes, that's what I thought.. On other computer systems I have Had the Bids of a different version then the Visual Studio version I was on, and I just ended up with 2 versions of VS on my desktop.. But not here..

I also read about the change of the BIDS to SSDT and that that was for VS2012.. I tried to download it.. But, I downloaded something called  SSDTSetup.exe  and it seemed to only be installing a SQL Express.. But after trying to install that, that is when I tried looking for something under the VS2012..

I tried the SSDTBI_VS2012_X86.msi..

I got this error..

The CPU architecture of installing feature(s) is different than the instance specified. To continue, add features to this instance with the same architecture.

I will look around for the error.. I have a feeling it might be the fact that it is x86 and I am on x64, But I didn't see a choice of an x64..
0
 
moosetrackerAuthor Commented:
I got it to work..  I figured out the error hinted at a previous bad installation, and as I said, I had tried to run it before through SSDTSetup.exe..  So luckily I had created a restore point before that installation and I did a restore.. Then  SSDTBI_VS2012_X86.msi was successfully installed..

BUT....

NOTHING I CAN SEE..  (see attached photo)

I know with the older SQL when it was called BIDS the SSAS & SSIS projects was under a folder Buisness Intelligence Projects..  I figure since it is now SSDT not BIdS I will see something SSDT-ish..   But... I see nothing..

Attached is the VS 2012 New project list of project types.

VS2012 New Project screen
0
 
moosetrackerAuthor Commented:
Ok This is confusing.. I found this video article..
http://devproconnections.com/database-development/get-know-sql-server-2012s-sql-server-data-tools

Depending on which Microsoft employee (or, in some cases, which product installer) you want to believe, SSDT can be described in either of the following two ways:
• SSDT is a Visual Studio shell to enable development of solutions that include SQL Server databases, SQL Server Integration Services, SQL Server Analysis Services, and/or SQL Server Reporting Services.
• SSDT is a collection of features that aid in the development of SQL Server databases.

I don't know which one of those is the correct description; regardless, in this article I will discuss SSDT from the second of these two perspectives: as a collection of features that aid in the development of SQL Server databases

So looking at the video I DO have #2.. But, I find being able to create a tables in Visual Studio, not all that helpful since I can create tables in SQL Server.. Question still remains, where are the SSAS & SSIS tools???..!!!!

VS 2012 DDST
0
 
moosetrackerAuthor Commented:
OK.. I got the VS2010 version to work..  Maybe it was there before.. Don't know.. I found a standalone for the VS2010 SSDT..  I ran it, it installed fine and I could see it in the Add remove programs.. But not on the desktop.. And when I did a search for visual studio programs still only showed VS 2012..

But.. Then I figured out how to look at the installed programs similar to what the start button would show you pre-Windows8..  And I found VS2010 there, and was able to move it onto my desktop.. When opened it has the SSIS & SSAS in it..

Yeah!!! Whether it is VS2010 or VS2012.. I care not.. It was just a serious problem not to have it at all.. Looking forward to getting a fix for this Windows8 and getting the start button back..
0
 
lcohanDatabase AnalystCommented:
"Looking forward to getting a fix for this Windows8 and getting the start button back" - you need to wait no more - it should be available via "Store" now...Windows 8.1 free update I mean.
0
 
moosetrackerAuthor Commented:
I am accepting the solution for SSDT 2012 from some other person and giving him all the points as a thank-you for the help, and it will most likely help other people.. Just something caused it not to work for me..

I gave myself best solution (but with no points).. Because I did get the SSDT 2010 to work by what I did.. But, I am unsure if my solution is the best for everyone.. It would be better if people got the newer version to work rather then the older one.
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 7
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now