CODEWITHSUNDEEP
sql-server
GR7
GR7

Reputation: 5186

SQL Server 2005 SP2 or SP3 not updating Management Studio?

I applied SQL Server 2005 SP2 and marked all the components to be updated, including Client tools, but the version in the Help -> About box still has version 1399, while the server does indeed had 3042.

I then re-applied SP2 to only Client tools, and everything ran successfully (again, first time did too) but still, no version update for management studio.

Now, I just applied SP3 with everything successfully, but still management studio version did not get updated.

How can I update it? Or at least how can I uninstall just Management studio so I can install it from a newer DVD?

Thanks.

Upvotes: 2

Views: 5248

Answers (3)

GR7
GR7

Reputation: 5186

Hate to answer my own question, but I had to manually un-install Client Tools, re-install them using SQL Server 2005 setup, and THEN apply the updates.

It wasn't working by just trying to apply updates over the existing original installation.

And i mention un-installing using the SQL Server 2005 Setup because trying to do it from the Add/Remove Programs dialog won't let you or will give you trouble.

Upvotes: 0

Vipin Goel
Vipin Goel

Reputation: 1

I got the Error in sql server sp3 installation log which caused this: Error Number : 29538 Error Description : MSP Error: 29538 SQL Server Setup did not have the administrator permissions required to rename a file: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\mssqlsystemresource1.ldf. To continue, verify that the file exists, and either grant administrator permissions to the account currently running Setup or log in with an administrator account. Then run SQL Server Setup again.

Upvotes: 0

John Sansom
John Sansom

Reputation: 41899

If you go to Control Panel > Add Remove programs and then choose the appropriate SQL Server installation, this will start the typical install wizard for SQL Server.

You can then select the specific components that you wish to uninstall.

If you are having difficulties with SQL Server 2005 Service Pack 3 may I suggest that you visit the SQL Server Central forums as there are a wealth of resources for SQL Server SP3. It was actually due to user demand from this forum that resulted in there even being an SP3 release.

http://www.sqlservercentral.com/Forums/Forum146-1.aspx

Let me know how you get on.

Cheers, John

Upvotes: 1

Related Questions