LP on .NET

May 27, 2009

Installing BIDS after SQL Server 2005 SP2

Filed under: .NET,SQL Server — Larry Parker @ 10:27 am

Last Fall I set up a new machine with my usual development tools, but I forgot to install SQL Server 2005’s Business Intelligence Development Studio (BIDS) on top of Visual Studio 2005.  I had since moved on to other projects using Visual Studio 2008 that were keeping me plenty busy.

Yesterday, I needed to revisit an older project that used SQL Server 2005 Reporting Services and Analysis Services.  I opened up my solution in VS 2005 but got an error that it didn’t recognize the project.  This made sense because I never installed BIDS.

So I broke out my SQL Server 2005 CD’s and tried to install it.  Unfortunately, I had recently upgraded my client tools to SQL Server 2005 SP2, and the original install was blocking adding anything since a newer service pack had already been applied.

I figured I would need to uninstall SQL 2005 from my machine to undo the service pack, reinstall it with BIDS this time, and then apply SP2 after that.  But I found this post that made things much easier.

At the end of the thread (dated April 22, 2009) there’s a post by ubster that solves it quite nicely:

Situation: Installed SQL Server 2005 ages ago using an installer predating any of the service packs. I have since installed service pack 2. I went back to using the initial installer to add BIDS but of [course] the silly installer tells me that it’s already installed and won’t budge. I also happen to be running Vista for some masochistic reason.

Solution: Open Control Panel -> add/remove programs. Find Microsoft SQL Server 2005 and hit Change. Select Workstation Components found under SQL Server 2005 common components and hit next. Select Change Installed Components when you arrive at the option and choose to add Client Components -> Business Intelligence Development Studio. Continue through the rest of the installation and you will find a shiny new icon under Start -> Programs -> Microsoft SQL Server 2005 -> SQL Server Business Intelligence Development Studio. This solution does not require anything to first be uninstalled.

Problem solved!  Now I can open my reporting project under VS 2005, and I still have SQL Server 2005 SP2 without having had to uninstall and reinstall.

Hope this helps.

Advertisements

10 Comments »

  1. Thanks! Just what I was looking for.

    Comment by Jacqui — July 9, 2009 @ 4:43 pm | Reply

  2. Thanks for the info but it still will not install for me. Perhaps it is because I never owned the full version of Visual Studio 2005.

    Comment by Patrick Wood — October 23, 2009 @ 8:49 pm | Reply

  3. Perfect! Just what I needed!

    Comment by Steve — January 22, 2010 @ 6:22 am | Reply

  4. Thanks for det info.
    But it doesnt solve the problem for me. Now I get a “is not a valid installation package for the product Microsoft SQL Server 2005 Tools” Error when I use the original installation dvd.

    Comment by Marita — January 27, 2010 @ 4:32 am | Reply

  5. Thanks! You saved me a few hours.

    Comment by Pritesh — January 29, 2010 @ 4:12 pm | Reply

  6. I’m using 2005 Express and I was having issues trying to install BIDS. I wanted to be able to access DTS from SQL Server Management Studio Express. Here is what I had to do to install it (note that I’m using Windows XP):

    1. Download the Microsoft SQL Server 2005 Express Edition Toolkit from here:
    http://www.microsoft.com/downloads/en/details.aspx?FamilyID=3C856B93-369F-4C6F-9357-C35384179543
    2. Go to Control Panel -> Add or Remove Programs.
    3. Select Microsoft SQL Server 2005 and click the Remove button (this will not remove anything, it will bring up a dialog window)
    4. Uncheck the Remove SQL Server 2005 instance components checkbox (it’s checked by default).
    5. Check the Workstation Components checkbox.
    6. Click the Next > button and begin the uninstallation procedure.
    7. After that completes go ahead and run the Microsoft SQL 2005 Express Edition Toolkit installer.
    8. I selected all components to be installed, but at the very least you’re going to want to install BIDS and SQL Server Management Studio Express.
    9. Once the installation completes go ahead and restart your computer.
    10. After you have restarted open your SQL Server Management Studio Express.
    11. Click Tools -> External Tools.
    12. Click the Add button and set the title to DTS, or whatever you want, and the Command: path is going to be \90\DTS\Binn\DTSWizard.exe
    13. Click the OK button
    14. Now you should be able to access DTS from Management Studio Express by clicking Tools -> DTS.

    Comment by Jason — March 8, 2011 @ 4:18 pm | Reply

    • Step 12, Command: path = Drive_letter:\sql_server_install_path\90\DTS\Binn\DTSWizard.exe

      Comment by Jason — March 8, 2011 @ 4:20 pm | Reply

  7. If you are trying to install SQL-2008 and you also have visual studio 2008 installed with service pack one (SP1) and get the error

    “A previous release of Microsoft Visual Studio 2008 is installed on this computer. Upgrade Microsoft Visual Studio 2008 to the SP1 before installing SQL Server 2008”

    Then welcome to the Microsoft beta testing program even if you purchased the faulty software.

    With XP the most common solution seem to be renaming the registry key
    HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\DevDiv\VS\Servicing\9.0
    And replacing ‘9.0’ with ‘9.0Old’ however this does not solve the problem if you are using windows 7 and the only solution I managed to find that worked was to uninstall VS2008 and all the components and to then install SQL-2008 and finally reinstall VS2008.

    Comment by David Davis — July 22, 2011 @ 9:38 am | Reply

  8. Careful if you’re trying David Davis’s technique – For me, I had Sql Server express installed, then installed reporting services, which blocked the install of BIDS. I tried that technique, and when I chose “Remove”, the installer went ahead and removed sql server express. I had nothing to lose, so just reinstalling is okay. But as far as I can tell, if you have SSRS 2005 SP 4 installed (I think that’s what you get if you download it now), you’re out of luck, you’ll have to uninstall it to install BIDS.

    Comment by levin magruder — August 17, 2012 @ 3:18 pm | Reply


RSS feed for comments on this post. TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Blog at WordPress.com.

%d bloggers like this: