Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 SQL Server management studio issue with SP2

Author  Topic 

tmitch
Yak Posting Veteran

60 Posts

Posted - 2007-05-16 : 23:35:38
I just upgraded my SQL 2005 dev machine to SP2. Now when I attempt to connect to a server, I have no options to choose from (except for <default> in the network protocol list on the Options page. I was previously able to select TCP/IP or Named Pipes here, but they no longer show up. I can't find what is causing this. Suggestions?

tmitch
Yak Posting Veteran

60 Posts

Posted - 2007-05-16 : 23:56:45
I just found the answer to my own question. Run the following command:

mofcomp "C:\Program Files\Microsoft SQL Server\90\Shared\sqlmgmproviderxpsp2up.mof"

See http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=142375&SiteID=1 for full details.
Go to Top of Page
   

- Advertisement -