SSMS problem after SP2 upgrade

• Tim Mitchell

  SSCoach

  Points: 15695

  More actions

  May 16, 2007 at 12:31 pm

  #176658

  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?

  thx

  Tim

  Tim Mitchell
  TimMitchell.net | @tmitch.net | Tyleris.com
  ETL Best Practices

• Tim Mitchell

  SSCoach

  Points: 15695

  More actions

  May 16, 2007 at 9:58 pm

  #706991

  This was a strange one.... After much searching, 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.

  Tim Mitchell
  TimMitchell.net | @tmitch.net | Tyleris.com
  ETL Best Practices