“SQL Server 2008 Management Studio failed to load” after upgrading to Windows 7

ssmswindows 7

I upgraded from Vista to Windows 7 and since then the SQL Server 2008 SP1 Management Studio Package is broken. Whenever I start it, it just shows the message "Package 'Microsoft SQL Management Studio Package' failed to load". and closes again immediately after clicking OK.

SQL server itself is still running fine, I can still access it from my web app.

Any idea what might be going wrong or how I can fix this? Would a re-install help? I was careful to update SQL Server 2008 to SP1, so it was supposed to be compatible with Windows 7.

Thanks,

Adrian

Best Answer

can you re-install sp1?

Related Solutions

Sql-server – SQL Server Management Studio connection fails to COM errors

unregister actxprxy.dll then reregister it

run

regsvr32.exe –r c:\windows\system32\actxprxy.dll
regsvr32.exe c:\windows\system32\actxprxy.dll

run these in a command prompt as administrator

On Windows2008 server, the command for unregister is:

 regsvr32.exe /u c:\windows\system32\actxprxy.dll

SQL Server Management Studio – Error connecting to remote DB

I'm assuming you've remembered to include the instancename (server\SQLEXPRESS)?

Try to create an ODBC against the same server. If you get the same error; create another ODBC, but use regular "SQL Server" driver, and on the "Client Configuration" settings choose "Named Pipes".

Also, SQLChickens tip about making sure the SQL Browser is started on the server is valid.

Also, try using IP-address instead of the NetBios name.

Best Answer

Related Solutions

Sql-server – SQL Server Management Studio connection fails to COM errors

SQL Server Management Studio – Error connecting to remote DB

Related Topic