May 16, 2007 at 12:31 pm
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, Microsoft Data Platform MVP
Data Warehouse and ETL Consultant
TimMitchell.net | @Tim_Mitchell | Tyleris.com
ETL Best Practices
May 16, 2007 at 9:58 pm
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, Microsoft Data Platform MVP
Data Warehouse and ETL Consultant
TimMitchell.net | @Tim_Mitchell | Tyleris.com
ETL Best Practices
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply