Installed SQL Server 2005 64 EE. Correct in that it installs 32 bit version of SSMS? If I installed the 64 bit Service Pack 3, but the version of SSMS still shows as 9.00.1399 which is RTM. DO I need to run the SP3 32 bit install in order to patch SSMS? Then if SSMS is not patched can this cause issue with managing database engine?
Yes. You are correct in saying that it installs the 32 bit version of SSMS. It does that regardless.
My memory is failing me, but something happened in our environment when I skipped SP2 and went directly to SP3 so I've been applying SP2 first and then SP3 just so that I don't have it happen again. Wish I could remember what "IT" was.
As far as the 9.00.1399 version, it sounds like you've already installed the x64 SP3 and you are having issues. Have a look at this discussion.
Are you using the client tools on the server or on your desktop? If it's your desktop, have you patched your local machine as well?
You can also look at: http://www.sqlservercentral.com/Forums/Topic464159-146-1.aspx http://sqlblog.com/blogs/aaron_bertrand/archive/2009/08/21/how-to-really-detect-the-version-of-ssms-you-are-running.aspx which leads you to some helpful info on finding SSMS versions and managing different database engines here.
answered Mar 06, 2010 at 04:32 PM