I recently installed Visual Studio 2008 on my main development computer and have been very happy with it overall. However, before starting the installation, I decided to remove all of the Visual Studio 2005 components from my computer. Overall, this was a good idea (VS 2008 is backwards-compatible), but I found out that it broke my ability to launch the Business Intelligence Development Studio (the primary tool for creating, among other things, SQL Server Reporting Services projects). One solution would be to re-run the SQL Server 2005 setup, but I didn’t want to go through the time and trouble.
Fortunately, it looks like there’s a better way… This MSDN Thread outlines a great response from Dan Jones:
You should make sure that Visual Studio is still installed. If you didn’t previously have VS installed, the BI Dev Studio installation will install a VS shell called Visual Studio Premier Partner Edition. Look in Add or Remove Programs for an entry like this. If you don’t find any entry for Visual Studio go to the location for SQL Server setup and run .\Tools\Setup\vs_setup.exe. This will install the VS Shell. After this is installed repair the BI Studio installation by running the following from the command line from the .\Tools directory: start /wait setup.exe /qb REINSTALL=SQL_WarehouseDevWorkbench REINSTALLMODE=OMUS
After running both commands, I’m back up and running properly. Hopefully, this “gotcha” will be better documented at some point (perhaps in an official Knowledge Base article?). For now, though it should get you back up and running within about 10 minutes. Note that you’ll want to run Microsoft Update to install the Visual Studio SP1 updates on your computer.
Update: If you’re looking for information on SQL Server 2008 R2 and Report Builder 3.0, please see my newer post SQL Server 2008 R2 Report Builder 3.0 (RTM).
#1 by Dan Taylor on March 8, 2010 - 5:28 am
Quote
Really good thread!
I have SQL 2005 & BIDS working great with loads of SSRS reports being accessed.
I would like to modify the Report Viewer home page and all the navigation around the pages – like add logos and links etc…I suppose use ASP.net to house the reports
For this it seems i need to install Visual Studio 2005. Is it a simple matter of installing or will it have any impact on my existing SSRS reports & setup?
Is it a separate install to BIDS?
Any help most welcomed.
Thanks
#2 by Anil Desai on March 8, 2010 - 7:51 am
Quote
Dan: I’m glad you found this thread to be useful (it’s easily the most popular post on my blog). If you want to customize your Report Viewer page, one fairly simple way to do this is to create your own ASP.NET application and then use a Report Viewer control to make the reports available. You should be able to use any version of Visual Studio to create that project, as the Report Viewer control should be available by default. For more information, see http://msdn.microsoft.com/en-us/library/ms251671%28VS.80%29.aspx. I hope this helps!
- Anil
#3 by Dan Taylor on March 8, 2010 - 10:24 am
Quote
Thanks Anil – I picked up your help earlier and have since been looking at what you recommend.
I have installed Visual Studio Professional Edition & the BIDS components all still work OK which is useful.
+ Created a basic ASP.net web page a used the Report Viewer to show reports. It looks basic but opens up a new world!!!!
…It does do funny things when rendering tables & adds Scroll bars when not required….should prove fun trying to workaround
Thanks Again
#4 by Sachin on March 9, 2010 - 12:00 am
Quote
Hi Anil,
I have experienced similar problem. But I couldn’t find the path which you have mentioned \Tools\Setup\vs_setup.exe. I m in urgent need of it. Please let me know to solve the issue.
#5 by Anil Desai on March 9, 2010 - 8:11 am
Quote
Sachin: I’m not sure why you’re unable to find that setup program, as it should be present on your SQL Server installation media. If the above process doesn’t work and you need access to BIDS, I recommend just re-running SQL Server setup and making sure that the “Workstation Components” are included in the installation. This should install the shell and the necessary components for creating report projects.
- Anil
#6 by sudhir on March 10, 2010 - 1:51 am
Quote
Hi
how to start with business intelligence and i intalled visualstudio 2008 professional edition in my local system. but iam not able to see the businessintelligence template .so please help me reagrding this issue .
#7 by Anil Desai on March 10, 2010 - 7:51 am
Quote
Sudhir: I think the above post and comments should answer your question. If you have a specific issue, feel free to post it here, in the comments.
#8 by Santos on March 17, 2010 - 12:33 pm
Quote
I couldn’t find the path which you have mentioned \Tools\Setup\vs_setup.exe. my dvd doesn’t have it. it has \Tools\Setup\vs_setup.msi is that it?
#9 by Anil Desai on March 18, 2010 - 7:53 am
Quote
Santos: It’s possible that there are different distribution media options for SQL Server and yours doesn’t have that path. I believe you need to run the executable (.exe) file but I’m not really sure if there’s another location for that file. My experience is with the MSDN versions of Visual Studio and SQL Server. Note that you can always just re-run SQL Server setup and choose the “Workstation Components” to get BIDS installed. I hope this is helpful! – Anil
#10 by Dan Taylor on March 31, 2010 - 8:08 am
Quote
Hi Anil.
Thanks Anil for you help – im now using the ‘Report Viewer’ component on a webpage & scroll bars have been sorted
One change I have seen when using the ‘Report Viewer’ is that the server is around user access
Previously when a user accessed the report server pages (without the report viewer) – I could see an entry of their Windows User Ac in the Report Server DB (in the ExecutionLog table) – allowing me to view\monitor access.
When using ‘Report Viewer’ I can see an entry – but it is always the NT AUTHORITY\NETWORK SERVICE account.
(I cannot see who the user is)
Could you advise how I could see the users?
Thanks
#11 by Anil Desai on March 31, 2010 - 8:24 am
Quote
Dan: I’m glad to hear that you have this working (more or less).
The problem you’re seeing is based on the fact that your web server is logging into SSRS on behalf of the user. The authentication credentials used are those of the ASP.NET service (the default is “NETWORK SERVICE”), so this is all that SSRS can see. If you want to log details, you’ll need to either build your own method (for example, write to a log table whenever a user clicks a report link).
You should also be able to require the user to provide Windows Authentication credentials to the Report Server in order to access the reports. I believe you can pass credentials to the Report Viewer control using the object’s properties. Another option might be to disable SSRS access to the Network Service account. This might force SSRS to prompt the user for Windows Credentials. I hope this helps!
#12 by Dan Taylor on March 31, 2010 - 9:27 am
Quote
Thanks Anil,
I will investigate – I’m guessing the users would prefer not to request the window credentials each time
Where will i get the user information to build the Log table? The ExecutionLog table in ReportServer DB … used to work great ;-(
Surely there is a control in the Report Viewer where i ask the credentials to be used?
Here’s hoping
#13 by Anil Desai on March 31, 2010 - 11:51 am
Quote
Dan: Assuming all of your servers are running in the same domain, your ASP.NET web application would have access to the user’s credentials. I’m rusty on the exact syntax, but it would be easy enough to find. And your users shouldn’t be required to retype their passwords; if they’re in a domain, pass-through authentication should work (SSRS will automatically ask for the user’s credentials, and they’ll be sent by the browser). If this doesn’t help, it might be a good idea to post your questions to the appropriate Microsoft Technical Communities (http://www.microsoft.com/communities/default.mspx) group. My guess is that someone there would be able to give you some specific examples. – Anil
#14 by Dan Taylor on April 1, 2010 - 9:12 am
Quote
Thanks Anil,
I will take you advice & let you know how i get on.
Thanks, Dan.
#15 by Himani on April 5, 2010 - 4:25 am
Quote
Anil, I installed the VS 2005 premier partner edition. However, afterwards the BIDS shortcut started pointing to PE_verify.exe. I changed it to devenv.exe. The issue I am getting is some package load failure (designerpackage) while launching devenv.exe (vs 2005). I can see BIDS projects however get above error. There’s one more thing to point out: I can see vs_setup.exe in my sql server CD2 as well as VS 2005 CD. Could it be this that is causing load failures?
#16 by Anil Desai on April 5, 2010 - 6:44 am
Quote
Himani: I’m not familiar with the PE_verify.exe issue, but a quick web search found this information: http://www.mztools.com/Articles/2007/MZ2007032.aspx. I’m not sure if it’s relevant, but it does sound likely that the problem is due to a Visual Studio add-in.
Other than the error message, it does sound like everything is configured properly. The vs_setup.exe on your VS 2005 media is for the full version of Visual Studio (which, of course, includes the Visual Studio shell). It’s part of the installation that also includes language and CLR support (VB.NET, C#, etc.) The version on the SQL Server media installs the VS shell and only the project types supported by BIDS. I hope this is helpful! – Anil
#17 by Dave on April 7, 2010 - 12:57 pm
Quote
Anil – Is it possible to download the vs_setup.exe from anywhere online? I seem to not have it on my SQl installation disks either…and it appears that this is why my BIDS is not showing even though a reinstallation of SQL shows it as already installed.
#18 by Anil Desai on April 8, 2010 - 8:39 am
Quote
Dave: I’m not aware of any other place to get the setup program other than the installation media. If you have an MSDN or Microsoft TechNet Plus subscription, you should be able to download the appropriate media from there. Or, you could try to snag a trial version of SQL Server / Visual Studio. The problem there is that the evaluation license would likely expire at some point. The best solution, of course, is to upgrade to SQL Server 2008 (if you can). – Anil
#19 by Jaikishen Jayadev on May 4, 2010 - 3:17 am
Quote
Hi Anil,
I am using MS SQL Server Management Studio 2008 and MS Visual Studio Team System 2008 for my projects.
I am learning SSIS and wanted to use BIDS. But I was not able to find it. Could you please advise as to how I can open BIDS? I dont have VS 2005 or SQL Server 2005 on my system.
Thanks,
Jay
#20 by Anil Desai on May 4, 2010 - 8:50 am
Quote
Jaikishen: If you have Visual Studio 2005 running on your system but you don’t see BIDS or the Business Intelligence project type options, the way to fix this is to re-run SQL Server 2005 Setup and choose to install the Workstation Components and Reporting Services. That should provide you with the correct project types. Alternatively, you can download the stand-alone Report Builder application from Microsoft. This should allow you to create, save, and modify reports without using the Visual Studio shell. I hope this helps!
- Anil
#21 by Jaikishen Jayadev on May 4, 2010 - 3:22 pm
Quote
Thanks Anil. But the thing is I am neither using SQL Server 2005 nor VS 2005. I am using VS 08 and MS SQL Server 08. Is it necessary to have even VS 05 installed if I dont want to go by the alternative method of downloading the report builder?
#22 by Jaikishen Jayadev on May 4, 2010 - 3:24 pm
Quote
And if I have to install SQL Server 2005 will the express edition work?
#23 by Anil Desai on May 4, 2010 - 3:27 pm
Quote
Jaikishen: That was my mistake – I mean to reference SQL 2008 and VS 2008 in my comment. I’m not sure what report development support is included in the Express editions. I’d recommend using Report Builder if you can. I hope this helps. If not, you might want to post your question in the appropriate Microsoft Technical Communities group. Perhaps someone else has the same configuration and can help. Good luck!
- Anil
Pingback: SQL Server 2008 R2 Report Builder 3.0 (RTM) | AnilDesai.net
#24 by Kalyan Adhikari on June 3, 2010 - 4:23 am
Quote
I had SQL Server 2000 and SQL Server 2005 along with VS 2003 and VS 2005 , I work with BIDS. To upgrade I had to uninstall VS 2003 and both SQL Server versions and Installed SQL Server 2005 first as I needed the Reporting Services and Integration Services and then VS 2008 . Now I do not get Business Intelligence Studio Project options in both versions of VS 2005 and VS 2008 also it does not appear in the menu of SQL Server 2005 in “All Programs”.
Can you help please. Its urgent
#25 by Anil Desai on June 3, 2010 - 7:19 am
Quote
Kalyan: It sounds like the Workstation Components (which includes BIDS) were not installed (or reinstalled) as part of your SQL Server 2005 installation. I suggest you re-run the SQL Server 2005 setup process and verify that Workstation Components are selected. If they are, you might want to try removing them and then reinstalling them. I hope this helps! – Anil
#26 by Enow Mbi on June 7, 2010 - 4:32 am
Quote
I have installed vs 2008 pro and sql server 2008 ent. i found sql_bids.msi on the installation cd under X86\SETUP\ .I launched it but got no response. What do i need to do ?
#27 by Anil Desai on June 7, 2010 - 7:01 am
Quote
Enow: It sounds like you’re experiencing a problem with the MSI installer, though I’m not sure what the exact problem is. Assuming you have the command-line switches correct, you might want to just re-run the SQL Server 2008 setup program and then choose to install the Workstation Components. I hope this is helpful! – Anil
#28 by nimmy on August 14, 2010 - 4:19 am
Quote
i have installed sql server 2005 on windows 7 machine. when i try to open the bids it says it requires 2005 sp1 for vista. shall i install the sp1. will it work?
#29 by Anil Desai on August 14, 2010 - 7:49 am
Quote
Nimmy: Yes, I would recommend installing the latest Service Pack (SP2) for Windows Vista. The error message is due to security issues in Windows Vista that prevent SQL Server 2005′s management tools from working properly. Once you install the update, it should work properly. I hope this is helpful! – Anil
#30 by Govind on August 19, 2010 - 12:07 am
Quote
Hi,
I Installed Visual studio 2008 in my machine,i enjoyed it alot then i installed Sql Server 2005 Express Edition and Sql server 2005 Toolkit .Management studio is working properly but BID was not working when i going to click on BID its showing a error message like devenv.exe is missing.How to fix this issue please help me.
#31 by Anil Desai on August 19, 2010 - 9:31 am
Quote
Govind: I haven’t run into this issue before, but it sounds like the Visual Studio 2008 shell (which is what BIDS uses for SSRS projects) isn’t installed. I’d recommend you re-run SQL Server 2008 setup and choose the “Workstation Components” option. That should install and configure BIDS for SQL Server 2008. You might also consider downloading Report Builder 2.0 or 3.0 if you’re only using BIDS for reporting development. I hope this is helpful! – Anil