SQL Management Studio doesn't open after the upgrade.

Question

Hello ,

I have upgraded from Windows 2003 R2 enterprise edition to Windows 2008 R2 Enterprise Edition.

The upgrade was successful.

Now,Iam not able to launch SQL Server Management Studio after the Upgrade.I tried to repair the installation.I have also tried to reinstall the Management Studio again.But ,it doesn't work.

The following error  is available in the Event Viewer

Faulting application name: Ssms.exe, version: 2007.100.1600.22, time stamp: 0x48753da6
Faulting module name: urlmon.dll, version: 8.0.7601.17514, time stamp: 0x4ce7af07
Exception code: 0x80000003
Fault offset: 0x0008c281
Faulting process id: 0x10ec
Faulting application start time: 0x01cd767383ab7e40

Faulting application path: C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\Ssms.exe

Faulting module path: C:\Windows\syswow64\urlmon.dll
Report Id: c19cede8-e266-11e1-b1b9-000c291e4332

Please help me on this issue...

Thanks for looking 

Answer 1

Hello,

Try to repair SQL Server 2008 R2 using the following article:

http://msdn.microsoft.com/en-us/library/cc646006(v=SQL.105).aspx

Hope this helps.

Regards,

Alberto Morillo
SQLCoffee.com

Answer 2

The following error  is available in the Event Viewer

Faulting application name: Ssms.exe, version: 2007.100.1600.22, time stamp: 0x48753da6
Faulting module name: urlmon.dll, version: 8.0.7601.17514, time stamp: 0x4ce7af07
Exception code: 0x80000003
Fault offset: 0x0008c281
Faulting process id: 0x10ec
Faulting application start time: 0x01cd767383ab7e40

Faulting application path: C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\Ssms.exe

Faulting module path: C:\Windows\syswow64\urlmon.dll
Report Id: c19cede8-e266-11e1-b1b9-000c291e4332

Hi MSdNuser,

Any progress?

From the error messages, there is something wrong with Ssms.exe. I think you could use the SQL Server Setup file reinstall SQL Server Management Studio.

If you have any problem, please feel free to let me know.

Thanks,
Maggie

---

Please remember to mark the replies as answers if they help and unmark them if they provide no help. This can be beneficial to other community members reading the thread.

Answer 3

Hi MSdNuser16,

This happened to me as well when I upgraded from SQL 2005 SSMS to SQL 2012 SSMS. To resolve this issue uninstall and then re-install client tools.

---

Regards,

Basit A. Farooq (MSC Computing, MCITP SQL Server 2005 & 2008, MCDBA SQL Server 2000)

http://basitaalishan.com

Answer 4

Hello,

You also need to uninstall all the sql server tools if you are upgrading to sql 2012 from sql server 2005/2008. I hope this will help.