SSMS crashing at startup

  • Hello,

    I have a windows 2008 server with an instance of sql server 2008 installed on it. After installing an instance of SQL server 2008 R2. I'm no more able to open SQL server management studio, it crash at the startup, with the following message:

    - "SQL server management studio has stopped working".

    When I click the "details button" I get the following information:

    Description:

    Stopped working

    Problem signature:

    Problem Event Name:CLR20r3

    Problem Signature 01:ssms.exe

    Problem Signature 02:2009.100.1600.1

    Problem Signature 03:4bb679e7

    Problem Signature 04:mscorlib

    Problem Signature 05:2.0.0.0

    Problem Signature 06:4d8c1599

    Problem Signature 07:f50

    Problem Signature 08:7

    Problem Signature 09:Exception

    OS Version:6.1.7600.2.0.0.272.7

    Locale ID:4108

    Here is the detailed log:

    Version=1

    EventType=CLR20r3

    EventTime=129590751466956914

    ReportType=2

    Consent=1

    ReportIdentifier=510705be-d20d-11e0-a4a8-00155d43f601

    WOW64=1

    Response.type=4

    Sig[0].Name=Problem Signature 01

    Sig[0].Value=ssms.exe

    Sig[1].Name=Problem Signature 02

    Sig[1].Value=2009.100.1600.1

    Sig[2].Name=Problem Signature 03

    Sig[2].Value=4bb679e7

    Sig[3].Name=Problem Signature 04

    Sig[3].Value=mscorlib

    Sig[4].Name=Problem Signature 05

    Sig[4].Value=2.0.0.0

    Sig[5].Name=Problem Signature 06

    Sig[5].Value=4d8c1599

    Sig[6].Name=Problem Signature 07

    Sig[6].Value=f50

    Sig[7].Name=Problem Signature 08

    Sig[7].Value=7

    Sig[8].Name=Problem Signature 09

    Sig[8].Value=Exception

    DynamicSig[1].Name=OS Version

    DynamicSig[1].Value=6.1.7600.2.0.0.272.7

    DynamicSig[2].Name=Locale ID

    DynamicSig[2].Value=4108

    UI[2]=C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\Ssms.exe

    UI[3]=SSMS - SQL Server Management Studio has stopped working

    UI[4]=Windows can check online for a solution to the problem.

    UI[5]=Check online for a solution and close the program

    UI[6]=Check online for a solution later and close the program

    UI[7]=Close the program

    LoadedModule[0]=C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\Ssms.exe

    LoadedModule[1]=C:\Windows\SysWOW64tdll.dll

    LoadedModule[2]=C:\Windows\syswow64\kernel32.dll

    LoadedModule[3]=C:\Windows\syswow64\KERNELBASE.dll

    LoadedModule[4]=C:\Windows\syswow64\ADVAPI32.dll

    LoadedModule[5]=C:\Windows\syswow64\msvcrt.dll

    LoadedModule[6]=C:\Windows\SysWOW64\sechost.dll

    LoadedModule[7]=C:\Windows\syswow64\RPCRT4.dll

    LoadedModule[8]=C:\Windows\syswow64\SspiCli.dll

    LoadedModule[9]=C:\Windows\syswow64\CRYPTBASE.dll

    LoadedModule[10]=C:\Windows\syswow64\USER32.dll

    LoadedModule[11]=C:\Windows\syswow64\GDI32.dll

    LoadedModule[12]=C:\Windows\syswow64\LPK.dll

    LoadedModule[13]=C:\Windows\syswow64\USP10.dll

    LoadedModule[14]=C:\Windows\WinSxS\x86_microsoft.vc80.crt_1fc8b3b9a1e18e3b_8.0.50727.4927_none_d08a205e442db5b5\MSVCR80.dll

    LoadedModule[15]=C:\Windows\WinSxS\x86_microsoft.vc80.atl_1fc8b3b9a1e18e3b_8.0.50727.4053_none_d1c738ec43578ea1\ATL80.DLL

    LoadedModule[16]=C:\Windows\syswow64\ole32.dll

    LoadedModule[17]=C:\Windows\syswow64\OLEAUT32.dll

    LoadedModule[18]=C:\Windows\syswow64\SHELL32.dll

    LoadedModule[19]=C:\Windows\syswow64\SHLWAPI.dll

    LoadedModule[20]=C:\Windows\system32\IMM32.DLL

    LoadedModule[21]=C:\Windows\syswow64\MSCTF.dll

    LoadedModule[22]=C:\Windows\WinSxS\x86_microsoft.windows.common-controls_6595b64144ccf1df_6.0.7600.16661_none_420fe3fa2b8113bd\comctl32.dll

    LoadedModule[23]=C:\Windows\syswow64\CLBCatQ.DLL

    LoadedModule[24]=C:\Windows\system32\propsys.dll

    LoadedModule[25]=C:\Windows\system32tmarta.dll

    LoadedModule[26]=C:\Windows\syswow64\WLDAP32.dll

    LoadedModule[27]=C:\Program Files (x86)\Microsoft SQL Server\100\Shared\instapi10.dll

    LoadedModule[28]=C:\Windows\syswow64\SETUPAPI.dll

    LoadedModule[29]=C:\Windows\syswow64\CFGMGR32.dll

    LoadedModule[30]=C:\Windows\syswow64\DEVOBJ.dll

    LoadedModule[31]=C:\Windows\system32\profapi.dll

    LoadedModule[32]=C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\msenv.dll

    LoadedModule[33]=C:\Windows\system32\VERSION.dll

    LoadedModule[34]=C:\Windows\system32\SXS.DLL

    LoadedModule[35]=C:\Windows\system32\uxtheme.dll

    LoadedModule[36]=C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\1033\msenvui.dll

    LoadedModule[37]=C:\Windows\system32\CRYPTSP.dll

    LoadedModule[38]=C:\Windows\system32\rsaenh.dll

    LoadedModule[39]=C:\Windows\system32\RpcRtRemote.dll

    LoadedModule[40]=C:\Windows\syswow64\urlmon.dll

    LoadedModule[41]=C:\Windows\syswow64\WININET.dll

    LoadedModule[42]=C:\Windows\syswow64\iertutil.dll

    LoadedModule[43]=C:\Windows\syswow64\CRYPT32.dll

    LoadedModule[44]=C:\Windows\syswow64\MSASN1.dll

    LoadedModule[45]=C:\Windows\SysWOW64\mscoree.dll

    LoadedModule[46]=C:\Windows\Microsoft.NET\Framework\v4.0.30319\mscoreei.dll

    LoadedModule[47]=C:\Windows\Microsoft.NET\Framework\v2.0.50727\mscorwks.dll

    LoadedModule[48]=C:\Windows\assembly\NativeImages_v2.0.50727_32\mscorlib\23bc3936180ff789f44259a211dfc7fc\mscorlib.ni.dll

    LoadedModule[49]=C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\AppIDPackage.dll

    LoadedModule[50]=C:\Windows\assembly\NativeImages_v2.0.50727_32\System\610374fef100556da252243e673ac64b\System.ni.dll

    LoadedModule[51]=C:\Windows\assembly\NativeImages_v2.0.50727_32\Microsoft.SqlServer#\8fcb99a22ed897c584edf6d0cc4c2e5d\Microsoft.SqlServer.SqlTools.VSIntegration.ni.dll

    LoadedModule[52]=C:\Windows\assembly\NativeImages_v2.0.50727_32\Microsoft.VisualStu#\3cf0869fb52f95ba66c44af9dc8204ce\Microsoft.VisualStudio.Shell.Interop.ni.dll

    LoadedModule[53]=C:\Windows\assembly\NativeImages_v2.0.50727_32\Microsoft.VisualStu#\8faa4b5bcdf2747817aa8265eeb5819c\Microsoft.VisualStudio.OLE.Interop.ni.dll

    LoadedModule[54]=C:\Windows\Microsoft.NET\Framework\v2.0.50727\mscorjit.dll

    LoadedModule[55]=C:\Windows\assembly\NativeImages_v2.0.50727_32\System.Drawing\eba4ec48e3f7f16864c6d96f510fafd9\System.Drawing.ni.dll

    LoadedModule[56]=C:\Windows\assembly\NativeImages_v2.0.50727_32\System.Windows.Forms\ad9c2f4737e1e07fa774af31a7d74235\System.Windows.Forms.ni.dll

    LoadedModule[57]=C:\Windows\assembly\NativeImages_v2.0.50727_32\SqlWorkbench.Interf#\864b9ee423e3e165c490161234074661\SqlWorkbench.Interfaces.ni.dll

    LoadedModule[58]=C:\Windows\assembly\NativeImages_v2.0.50727_32\Microsoft.SqlServer#\62b49440df2124a81ecc0562ba077228\Microsoft.SqlServer.SqlTDiagM.ni.dll

    LoadedModule[59]=C:\Windows\assembly\NativeImages_v2.0.50727_32\Microsoft.SqlServer#\40433cbeb10b6d14df78a6d697c0e55e\Microsoft.SqlServer.Instapi.ni.dll

    LoadedModule[60]=C:\Windows\assembly\NativeImages_v2.0.50727_32\EnvDTE\8230653175f553933b4db2f1bb8f0312\EnvDTE.ni.dll

    LoadedModule[61]=C:\Windows\assembly\NativeImages_v2.0.50727_32\Microsoft.VisualStu#\0aa9c0c21c7ccde9ac4ba666bcf5e477\Microsoft.VisualStudio.Shell.ni.dll

    LoadedModule[62]=C:\Windows\assembly\NativeImages_v2.0.50727_32\Microsoft.VisualStu#\9b79361da13edd39d0c2a893f0b7a0ae\Microsoft.VisualStudio.Shell.Interop.8.0.ni.dll

    LoadedModule[63]=C:\Windows\assembly\NativeImages_v2.0.50727_32\Microsoft.SqlServer#\17e048fcec6ef01d19f8a5ad8c1e5bee\Microsoft.SqlServer.Management.SDK.SqlStudio.ni.dll

    LoadedModule[64]=C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\Packages\Debugger\vsdebug.dll

    LoadedModule[65]=C:\Windows\system32\MSIMG32.dll

    LoadedModule[66]=C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\Packages\Debugger\1033\VSDebugUI.dll

    LoadedModule[67]=C:\Windows\assembly\NativeImages_v2.0.50727_32\Microsoft.DataWareh#\fcba072adf0ae8ab0dbe9fa136e185ac\Microsoft.DataWarehouse.SQM.ni.dll

    LoadedModule[68]=C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\1033\AppIDPackage.rll

    LoadedModule[69]=c:\Program Files (x86)\Common Files\Microsoft Shared\VS7Debug\coloader80.dll

    LoadedModule[70]=C:\Program Files (x86)\ApexSQL\ApexSQLRefactor2008\ApexSql.Refactor.SsmsLoader.dll

    LoadedModule[71]=C:\Windows\assembly\GAC\Extensibility\7.0.3300.0__b03f5f7f11d50a3a\Extensibility.dll

    LoadedModule[72]=C:\Windows\assembly\NativeImages_v2.0.50727_32\Microsoft.SqlServer#\4f1a27df050bbefad78b47f692860d66\Microsoft.SqlServer.Management.Sdk.Sfc.ni.dll

    LoadedModule[73]=C:\Windows\assembly\NativeImages_v2.0.50727_32\Microsoft.SqlServer#\c1baff7ac94c5d243a7029dd6b6de516\Microsoft.SqlServer.Management.Reports.ni.dll

    LoadedModule[74]=C:\Windows\assembly\NativeImages_v2.0.50727_32\EnvDTE80\116509b8cdf36c562998803c5ee16a21\EnvDTE80.ni.dll

    LoadedModule[75]=C:\Program Files (x86)\ApexSQL\ApexSQLRefactor2008\ApexSql.Refactor.Ssms2008.dll

    LoadedModule[76]=C:\Program Files (x86)\ApexSQL\ApexSQLRefactor2008\ApexSql.Common.CommonLib.dll

    LoadedModule[77]=C:\Windows\assembly\NativeImages_v2.0.50727_32\System.Configuration\0bddc91cbf37d143f08f6684b2919566\System.Configuration.ni.dll

    LoadedModule[78]=C:\Windows\assembly\NativeImages_v2.0.50727_32\System.Xml\155679a9c8991cc33f90d6b27bac1977\System.Xml.ni.dll

    LoadedModule[79]=C:\Windows\assembly\NativeImages_v2.0.50727_32\Microsoft.SqlServer#\c6a1362ff9bde823ee54a9dcede56c6b\Microsoft.SqlServer.Management.SqlStudio.Explorer.ni.dll

    LoadedModule[80]=C:\Windows\assembly\NativeImages_v2.0.50727_32\Microsoft.SqlServer#\4d67f983b34ca9c59d2c7c06341166e8\Microsoft.SqlServer.Management.Controls.ni.dll

    LoadedModule[81]=C:\Windows\assembly\NativeImages_v2.0.50727_32\ObjectExplorer\b47708857448f5785f2f145dca3ae6f9\ObjectExplorer.ni.dll

    LoadedModule[82]=C:\Windows\assembly\NativeImages_v2.0.50727_32\System.Design\a87b99435541fab7c7a58782904030f3\System.Design.ni.dll

    LoadedModule[83]=C:\Windows\assembly\NativeImages_v2.0.50727_32\Microsoft.SqlServer#\bee73824bae4d7aedcb5abc9163cd71e\Microsoft.SqlServer.Management.UserSettings.ni.dll

    LoadedModule[84]=C:\Windows\assembly\NativeImages_v2.0.50727_32\SqlMgmt\0dc4c31dc6b4151fac9071c70596f6f7\SqlMgmt.ni.dll

    LoadedModule[85]=C:\Windows\system32\shfolder.dll

    LoadedModule[86]=C:\Windows\assembly\NativeImages_v2.0.50727_32\ConnectionDlg\38cea46249218a9ed0e7be1d8ed6da90\ConnectionDlg.ni.dll

    LoadedModule[87]=C:\Windows\WinSxS\x86_microsoft.windows.gdiplus_6595b64144ccf1df_1.1.7600.16385_none_72fc7cbf861225ca\gdiplus.dll

    LoadedModule[88]=C:\Windows\system32\WindowsCodecs.dll

    LoadedModule[89]=C:\Windows\assembly\GAC_MSIL\Microsoft.VisualStudio\2.0.0.0__b03f5f7f11d50a3a\Microsoft.VisualStudio.dll

    LoadedModule[90]=C:\Windows\assembly\NativeImages_v2.0.50727_32\System.Drawing.Desi#\0fb34b9054c6a2491e48b8be259a5b43\System.Drawing.Design.ni.dll

    LoadedModule[91]=C:\Windows\assembly\NativeImages_v2.0.50727_32\Microsoft.VisualStu#\ad22382630a4c67729c4fbb56358d8f7\Microsoft.VisualStudio.Designer.Interfaces.ni.dll

    LoadedModule[92]=C:\Windows\assembly\NativeImages_v2.0.50727_32\Microsoft.SqlServer#\6773e394d6582bec2129252e17d34e76\Microsoft.SqlServer.RegSvrEnum.ni.dll

    LoadedModule[93]=C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\VS SCC\1033\VssProviderui.dll

    LoadedModule[94]=C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\Microsoft.SqlServer.Management.SqlStudio.Migration.dll

    LoadedModule[95]=C:\Windows\assembly\NativeImages_v2.0.50727_32\Microsoft.SqlServer#\8bd8872d84923c75fec798f98d70cee0\Microsoft.SqlServer.Management.SqlStudio.Migration.ni.dll

    LoadedModule[96]=C:\Windows\assembly\NativeImages_v2.0.50727_32\Microsoft.SqlServer#\3f14de30910c16142636e4a6f4fd827c\Microsoft.SqlServer.Smo.ni.dll

    LoadedModule[97]=C:\Windows\assembly\NativeImages_v2.0.50727_32\Microsoft.NetEnterp#\3fb5e172f37fcc845966b2c181eba25d\Microsoft.NetEnterpriseServers.ExceptionMessageBox.ni.dll

    LoadedModule[98]=C:\Windows\assembly\NativeImages_v2.0.50727_32\System.Data\86f429e0a23238cf277d464bd0433d86\System.Data.ni.dll

    LoadedModule[99]=C:\Windows\assembly\GAC_32\System.Data\2.0.0.0__b77a5c561934e089\System.Data.dll

    LoadedModule[100]=C:\Windows\syswow64\WS2_32.dll

    LoadedModule[101]=C:\Windows\syswow64\NSI.dll

    LoadedModule[102]=C:\Windows\assembly\NativeImages_v2.0.50727_32\Microsoft.SqlServer#\b23d899f3488016213705826a909e2f1\Microsoft.SqlServer.Management.SqlStudio.ni.dll

    LoadedModule[103]=C:\Windows\assembly\NativeImages_v2.0.50727_32\Accessibility\5c6e1a094b1e65c69b528151cc19b1ee\Accessibility.ni.dll

    LoadedModule[104]=C:\Windows\system32\oleacc.dll

    LoadedModule[105]=C:\Windows\assembly\NativeImages_v2.0.50727_32\Microsoft.SqlServer#\924b5c76a22f99698324e0164fb80af9\Microsoft.SqlServer.ConnectionInfo.ni.dll

    LoadedModule[106]=C:\Windows\assembly\NativeImages_v2.0.50727_32\Microsoft.SqlServer#\a043fb3b67c8cdea7b4d9b03bf8381cb\Microsoft.SqlServer.Management.RegisteredServers.ni.dll

    LoadedModule[107]=C:\Windows\assembly\NativeImages_v2.0.50727_32\Microsoft.SqlServer#\0435b8b3c7483bd03683b576a57ccd93\Microsoft.SqlServer.SqlClrProvider.ni.dll

    LoadedModule[108]=C:\Windows\system32\apphelp.dll

    FriendlyEventName=Stopped working

    ConsentKey=CLR20r3

    AppName=SSMS - SQL Server Management Studio

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

    ReportDescription=Stopped working

    I have tried to uninstall SSMS and reinstall it, but the same error occur.

    Thank you for your help

  • Hello,

    I get the same error. Don't know what went wrong (it worked just fine), but when I now open SSMS I get the same error. Do you have a solution for this problem?

    Thanks in advance,

    Raymond

  • rcaers (10/31/2011)


    Hello,

    I get the same error. Don't know what went wrong (it worked just fine), but when I now open SSMS I get the same error. Do you have a solution for this problem?

    Thanks in advance,

    Raymond

    have you tried a repair of the .NET framework in Add\Remove programs

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • Hello Perry,

    .NET Framework isn't installed on the server.

    But it was a dll problem.

    Re-registering the dll's solved the problem.

    Kind regards and thanks for your reply,

    Raymond

  • the .NET framework is required for SSMS to be available!!

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • which DLLs?

  • I had a very similar problem with my SSMS. The problem was actually that ApexSQL Refactor I had installed. Once I removed it, everything was back to normal. It seems that they have fixed it, as I've installed it again recently, and SSMS hasn't crashed since

  • Yes what DLL?

  • I am working with SQL Server 2014 and this problem occurred only when I opened up a new query.

    Only have to remove the feature .NetFramework 3.5 and then add it again . 😎

  • I had this problem - SSMS 2012 crashing right at startup with message 'Sql Server Mgmt Studio has stopped working' and with two buttons 'debug' and 'close'.  
    I unistalled and reinstalled.  did a .net check.  installed SQL Server 2014 and still got same error.
    Finally I uninistalled ALL red gate software and then ran SSMS (2014) and it worked again.

Viewing 10 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply