RE: Installing BIDS after SP2 is already applied

Tech-Archive recommends: Speed Up your PC by fixing your registry



Hi Jason,
I understand that you could not install BIDS due to higher version error message after you installed SQL Server 2005 SP2 with cumulative 7 update.
If I have misunderstood, please let me know.

This issue is often caused by the fact that your client tools had been upgraded to the latest version. BIDS cannot be separately installed if you had installed other client tools. To install it, you
must first uninstall the existing client tools and then re-install the client tools including BIDS. Please refer to the following steps:
1. Open Add or Remove Programs, select Microsoft SQL Server 2005, click Remove;
2. In the pop-up window, ensure that you only check "Workstation Components" from "Remove SQL Server 2005 common components" list, and then click Next and click Finish.
3. Open your SQL Server 2005 setup program from your setup CD, follow the setup wizard and only choose the Workstation Components to install.
4. After the installation finished, re-run your SQL Server 2005 SP2 to only apply the hotfixes on the Workstation Components.

Hope this helps. If you have any other questions or concerns, please feel free to let me know.

Best regards,
Charles Wang
Microsoft Online Community Support
===========================================================
Delighting our customers is our #1 priority. We welcome your
comments and suggestions about how we can improve the
support we provide to you. Please feel free to let my manager
know what you think of the level of service provided. You can
send feedback directly to my manager at: msdnmg@xxxxxxxxxxxxxx
===========================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notifications.

Note: The MSDN Managed Newsgroup support offering is for
non-urgent issues where an initial response from the community
or a Microsoft Support Engineer within 1 business day is acceptable.
Please note that each follow up response may take approximately
2 business days as the support professional working with you may
need further investigation to reach the most efficient resolution.
The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by
contacting Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
============================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
=========================================================

.



Relevant Pages

  • Re: Install of KB921896 fails with 0x643 and corrupts my SQL Server.
    ... Support for Windows Update: ... support for security updates is available through your usual support contacts. ... I saw that SQL Server had been failing for a few minutes nearly ... Updates had been unsuccessfully attempting to install KB921896 (SQL Server ...
    (microsoft.public.windowsupdate)
  • RE: Installation problems
    ... If you just want to install the two components, ... Microsoft SQL Server Management Studio Express ... Microsoft Online Community Support ...
    (microsoft.public.sqlserver.setup)
  • RE: cannot delete a record in sql server 2005 through asp program
    ... Using trace script he provided and trace file created by the script. ... SQL Server database by the asp application. ... Microsoft Online Community Support ... a Microsoft Support Engineer within 2 business day is acceptable. ...
    (microsoft.public.sqlserver.programming)
  • Re: enumerating Sql Servers is wrong on some systems
    ... How do we get the correct enumeration? ... I know that you install a SQL Server named ... Microsoft Online Community Support ... a Microsoft Support Engineer within 2 business day is acceptable. ...
    (microsoft.public.sqlserver.setup)
  • Re: SQL Server 2008 set up
    ... work on this Account so I would like to use that. ... "SQL Server System Administrators" list during SQL Server 2008 Setup. ... The install completed successfully. ... Microsoft Online Community Support ...
    (microsoft.public.sqlserver.setup)