How to find Business Intelligence Development in Visual Studio 2005

I am trying to edit a .rdl report for CRM and the "Unleashed" book tells me I should use a Business Intelligence project type but when I open Visual Studios, the Business Development option is not there. I have VS installed on the SQL Server 2005 machine and have tried to reboot but the BID does not show up. I also tried reinstalling Integrated services on the Report server - nothing. I can see the report server running.

What do I need to check to find the BID in VS 2005?
jplanAsked:
Who is Participating?
 
MIKESoftware Solutions ConsultantCommented:
try the install file:   sqlrun_tools under the setup folder on CD 2.

be sure that all SQL programs are closed on your workstation when trying to load.....

Oh and be prepared...if I recall correctly,....I had a few problems getting it to load correctly....it didn't behave well....    : (
0
 
tigin44Commented:
not all editions of vs include BI Develeopment tools. Check your edition
0
 
jplanAuthor Commented:
I have VS 2005 pro.
0
Cloud Class® Course: C++ 11 Fundamentals

This course will introduce you to C++ 11 and teach you about syntax fundamentals.

 
tigin44Commented:
if you have installed it full you should have "Business Intelligence Projects" under "New Project"
0
 
jplanAuthor Commented:
I did not install "Full" - should I uninstall and reinstall or is there a way to add the feature?
0
 
tigin44Commented:
you can run the set up and add the features by choosing modify intallation...
0
 
jplanAuthor Commented:
I can not modify or add this feature - all the features were checked in that section of the installation.  I will have to uninstall and then reinstall VS and try checking "Full" installation.
0
 
tigin44Commented:
I have vs 2005 pro and it contains BID...
0
 
jplanAuthor Commented:
I uninstalled and reinstalled VS, installed the MSDN library and still no BID. I updated from the MS site, the only thing it did not do was install sp1 for VS.

What do I try next.



0
 
jplanAuthor Commented:
One other possible issue; I am testing this system with SQL Server 2005 Standard Edition but it is out of the "Action Pack" from MS. Could this be causing the BIDS not to show up?
0
 
tigin44Commented:
did you install the integration services and analysis services of sql server? you should install them too..
0
 
jplanAuthor Commented:
Will I be able to see them under "Services" if they are running or at least installed?
0
 
jplanAuthor Commented:
The Analysis and Integration services are running.
0
 
PedroCGDCommented:
You need to install Business INtelligence Studio that comes with SQL Server (Not SQL Express)
Check this link
http://www.microsoft.com/Sqlserver/2005/en/us/compare-features.aspx

Helped?
Regards,
Pedro
0
 
MIKESoftware Solutions ConsultantCommented:
Agree, I think it come ONLY with SQL Server Professional and greater editions....

M
0
 
MIKESoftware Solutions ConsultantCommented:
In other words....the BIDS "Visual Studio" piece is BUNDLED with SQL SERVER Full Product, not the other way around....
0
 
jplanAuthor Commented:
Ok - understood.
I have the SQL 05 Standard Edition and according to Pedro's link (thanks) it has Development Studio built in.

How do I add this feature to SQL server that is already installed?
0
 
MIKESoftware Solutions ConsultantCommented:
Install the CLIENT TOOLS which I believe are on the #2 Install CD under SETUP folder....

Just shooting from the hip here......
0
 
jplanAuthor Commented:
I found the setup.exe, it's in the same directory as sqlrun_tools. I'm assuming I can just run the setup.exe and the tools will be an option to install.

The files were under Disc 1 on my SQL DVD. If someone has the CD's they could be on Disc 2 as mentioned.

Are you saying if any program, like CRM, is using the SQL server - I need to wait till all users are not using it?
0
 
MIKESoftware Solutions ConsultantCommented:
They are under BOTH CD's...for some reason I remember CD #2 being the CD to use...but oh well...try either one.

You'll see what I mean about having issue.....I really doubt anyone has ever installed SQL SERVER withouth having "someking of issue.."    LOL    
0
 
jplanAuthor Commented:
I need to run the sqlrun_tools.msi as you mentioned above.

I started to run it then cancled, but I did see where I could choose the BID and install it.
0
 
MIKESoftware Solutions ConsultantCommented:
0
 
jplanAuthor Commented:
Great work! I've been working on a solution for this for several weeks and was starting to lose faith I would get an answer and you guys gave me an answer within hours - thanks for being the heros!
0
 
MIKESoftware Solutions ConsultantCommented:
Glad I could help out.

RIght, I'm the same way,...whenever I need assistance on ANY IT issue...Experts-Exchange is where I go first...!

M
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.