Solved

SQL 2012 can't find BIDS for it..

Posted on 2013-10-24
11
1,000 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
Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

 
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
 
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

Gigs: Get Your Project Delivered by an Expert

Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Sql server insert 13 28
SQL Update trigger 5 16
Query Syntax 17 33
Alternative of IN Clause in SQL Server 3 18
How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
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.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
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…

776 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