Solved

SQL 2012 can't find BIDS for it..

Posted on 2013-10-24
11
988 Views
Last Modified: 2016-02-18
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
Comment
Question by:moosetracker
  • 7
  • 4
11 Comments
 
LVL 39

Expert Comment

by:lcohan
ID: 39598456
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
 
LVL 1

Author Comment

by:moosetracker
ID: 39598556
Why download it, when I have the SQL 2012 Developer edition purchased and installed?  Did they leave out features in the purchased copy?
0
 
LVL 39

Expert Comment

by:lcohan
ID: 39598627
Do you really have SQL Server 2012 Developer or just "I have windows 8,  and have installed VS2012 Developer"??
0
 
LVL 1

Author Comment

by:moosetracker
ID: 39598735
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
 
LVL 39

Assisted Solution

by:lcohan
lcohan earned 500 total points
ID: 39598786
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
What Security Threats Are You Missing?

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

 
LVL 1

Author Comment

by:moosetracker
ID: 39599999
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
 
LVL 1

Author Comment

by:moosetracker
ID: 39600213
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
 
LVL 1

Author Comment

by:moosetracker
ID: 39602340
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
 
LVL 1

Accepted Solution

by:
moosetracker earned 0 total points
ID: 39602485
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
 
LVL 39

Expert Comment

by:lcohan
ID: 39609147
"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
 
LVL 1

Author Closing Comment

by:moosetracker
ID: 39613553
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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Join & Write a Comment

My client has a dictionary table. They're defining a list of standard naming convention. Now, they are requiring my team to provide us a mechanism how to match new incoming data with existing data in their system.
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
Viewers will learn how the fundamental information of how to create a table.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

707 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now