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.
我应用了SQL Server 2005 SP2并标记了要更新的所有组件,包括客户端工具,但是帮助 - >关于框中的版本仍然具有版本1399,而服务器确实具有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.
然后我重新将SP2应用于客户端工具,并且所有内容都成功运行(同样,第一次也是如此)但仍然没有管理工作室的版本更新。
Now, I just applied SP3 with everything successfully, but still management studio version did not get updated.
现在,我刚刚成功地应用了SP3,但仍然没有更新管理工作室版本。
How can I update it? Or at least how can I uninstall just Management studio so I can install it from a newer DVD?
我该如何更新?或者至少如何卸载Management studio,以便我可以从较新的DVD安装它?
Thanks.
3 个解决方案
#1
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.
如果转到“控制面板”>“添加删除程序”,然后选择相应的SQL Server安装,则将启动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.
如果您在使用SQL Server 2005 Service Pack 3时遇到困难,我建议您访问SQL Server Central论坛,因为SQL Server SP3有大量资源。这实际上是由于该论坛的用户需求导致甚至出现了SP3版本。
http://www.sqlservercentral.com/Forums/Forum146-1.aspx
Let me know how you get on.
让我知道你是怎么办的。
Cheers, John
#2
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.
我在sql server sp3安装日志中得到错误导致此错误:错误号:29538错误说明:MSP错误:29538 SQL Server安装程序没有重命名文件所需的管理员权限:C:\ Program Files \ Microsoft SQL Server \ MSSQL.1 \ MSSQL \ DATA \ mssqlsystemresource1.ldf。要继续,请验证该文件是否存在,并为当前运行安装程序的帐户授予管理员权限,或使用管理员帐户登录。然后再次运行SQL Server安装程序。
#3
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.
讨厌回答我自己的问题,但我不得不手动卸载客户端工具,使用SQL Server 2005安装程序重新安装它们,然后应用更新。
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.
我提到使用SQL Server 2005安装程序卸载,因为尝试从“添加/删除程序”对话框中执行此操作不会让您或将给您带来麻烦。
#1
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.
如果转到“控制面板”>“添加删除程序”,然后选择相应的SQL Server安装,则将启动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.
如果您在使用SQL Server 2005 Service Pack 3时遇到困难,我建议您访问SQL Server Central论坛,因为SQL Server SP3有大量资源。这实际上是由于该论坛的用户需求导致甚至出现了SP3版本。
http://www.sqlservercentral.com/Forums/Forum146-1.aspx
Let me know how you get on.
让我知道你是怎么办的。
Cheers, John
#2
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.
我在sql server sp3安装日志中得到错误导致此错误:错误号:29538错误说明:MSP错误:29538 SQL Server安装程序没有重命名文件所需的管理员权限:C:\ Program Files \ Microsoft SQL Server \ MSSQL.1 \ MSSQL \ DATA \ mssqlsystemresource1.ldf。要继续,请验证该文件是否存在,并为当前运行安装程序的帐户授予管理员权限,或使用管理员帐户登录。然后再次运行SQL Server安装程序。
#3
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.
讨厌回答我自己的问题,但我不得不手动卸载客户端工具,使用SQL Server 2005安装程序重新安装它们,然后应用更新。
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.
我提到使用SQL Server 2005安装程序卸载,因为尝试从“添加/删除程序”对话框中执行此操作不会让您或将给您带来麻烦。