SSMS 2012 Restarts Itself

  • When I close SSMS 2012 it will restart. I can click the X or click File Exit; however, SSMS will restart. This happens at the end of the day when closing all programs to shutdown my workstation (I leave it up all day). I am running Windows 7 SP1 32 bit and SSMS 2012 SP1 CU2 (11.0.3339.0). Any ideas?

  • See anything in the Windows Application Error log?

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

  • maybe you added a plugin for SSMS, and it's crashing on the close of SSMS, which causes the restart?

    Lowell


    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • I recently added SQLPrompt 5; but, SSMS has been doing this since day one.

    Good call on the Error Log:

    Application: Ssms.exe Framework Version: v4.0.30319 Description: The process was terminated due to an unhandled exception. Exception Info: System.Runtime.InteropServices.InvalidComObjectException Stack: at System.StubHelpers.InterfaceMarshaler.ConvertToNative(System.Object, IntPtr, IntPtr, Int32) at System.Management.IWbemServices.CancelAsyncCall_(System.Management.IWbemObjectSink) at System.Management.SinkForEventQuery.Cancel() at System.Management.ManagementEventWatcher.Stop() at System.Management.ManagementEventWatcher.Finalize()

    Ssms.exe

    2011.110.3000.0

    5081c1cd

    KERNELBASE.dll

    6.1.7601.17965

    506dbd3f

    e0434352

    0000c6e3

    e8c

    01ce4be3dc2b93db

    C:\Program Files\Microsoft SQL Server\110\Tools\Binn\ManagementStudio\Ssms.exe

    C:\Windows\system32\KERNELBASE.dll

    969d19d2-b800-11e2-b13b-d067e53e4975

    3364453888

    5

    CLR20r3

    Not available

    0

    ssms.exe

    2011.110.3000.0

    5081c1cd

    System.Management

    4.0.0.0

    4ba1e140

    d0

    1c

    RXOEJIH3RSKJEZ4XXWPXUDKCPPWJODNG

    C:\Users\xxxxxxxxx\AppData\Local\Temp\WER5B5E.tmp.WERInternalMetadata.xml

    C:\Users\xxxxxxxxx\AppData\Local\Microsoft\Windows\WER\ReportArchive\AppCrash_ssms.exe_716bf9181f812e6d422d64f891cea44fadb290c8_25a17a62

    0

    969d19d2-b800-11e2-b13b-d067e53e4975

    0

  • I experience this same behavior, both on a system with SQL Prompt and one without.

  • I would probably make sure I have installed all .NET Framework patches and especially upgrade my tools install to SQL 2012 SP1 CU(latest).

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

  • Did you ever get this resolved? I'm getting the exact same error messages when I close down SSMS. It doesn't 'auto-restart' thought, it simply says that windows has encountered a problem (the usual hard crash message), I 'x' out of it and it doesn't fire up again.

  • Yep still restarts with the same error message.

  • I'm getting the same thing, both on a PC with SQL 2012, VS 2012 and VS 2010 and now on a new laptop with SQL 2012, VS 2012, and VS 2010. All updates were installed, no add-ons. Here are the application log errors:

    EventID: 1026

    Application: Ssms.exe

    Framework Version: v4.0.30319

    Description: The process was terminated due to an unhandled exception.

    Exception Info: System.Runtime.InteropServices.InvalidComObjectException

    Stack:

    at System.StubHelpers.InterfaceMarshaler.ConvertToNative(System.Object, IntPtr, IntPtr, Int32)

    at System.Management.IWbemServices.CancelAsyncCall_(System.Management.IWbemObjectSink)

    at System.Management.SinkForEventQuery.Cancel()

    at System.Management.ManagementEventWatcher.Stop()

    at System.Management.ManagementEventWatcher.Finalize()

    Faulting application name: Ssms.exe, version: 2011.110.3000.0, time stamp: 0x5081c1cd

    Faulting module name: KERNELBASE.dll, version: 6.1.7601.18229, time stamp: 0x51fb1116

    Exception code: 0xe0434352

    Fault offset: 0x0000c41f

    Faulting process id: 0x468

    Faulting application start time: 0x01cf48fe075979ed

    Faulting application path: C:\Program Files (x86)\Microsoft SQL Server\110\Tools\Binn\ManagementStudio\Ssms.exe

    Faulting module path: C:\Windows\syswow64\KERNELBASE.dll

    Report Id: 4b3a4fad-b523-11e3-a3cf-d4c9effc2c14

  • I'm getting the same thing with my SSMS 2012 and 2014. It seem to start when I added and upgraded Red-gates SSMS Ecosystem Project tools version (1.0.3.4).

    I'm running Windows 8.1 on 64bit.

  • For further analysis, you might try starting SSMS with the /log switch:

    "C:\Program Files (x86)\Microsoft SQL Server\110\Tools\Binn\ManagementStudio\Ssms.exe" /log

    This will create an activity log in your user folders:

    C:\Users\?????\AppData\Roaming\Microsoft\AppEnv\10.0\ActivityLog.xml

    It should also create an ActivityLog.xsl, which is required to view the log. If the .xsl file is missing, use the one attached here (zipped because xsl files are not allowed as attachments).

    After the crash, double click the ActivityLog.xml file and scroll to the end to see what error is listed.

    MM



    select geometry::STGeomFromWKB(0x0106000000020000000103000000010000000B0000001000000000000840000000000000003DD8CCCCCCCCCC0840000000000000003DD8CCCCCCCCCC08408014AE47E17AFC3F040000000000104000CDCCCCCCCCEC3F9C999999999913408014AE47E17AFC3F9C99999999991340000000000000003D0000000000001440000000000000003D000000000000144000000000000000400400000000001040000000000000F03F100000000000084000000000000000401000000000000840000000000000003D0103000000010000000B000000000000000000143D000000000000003D009E99999999B93F000000000000003D009E99999999B93F8014AE47E17AFC3F400000000000F03F00CDCCCCCCCCEC3FA06666666666FE3F8014AE47E17AFC3FA06666666666FE3F000000000000003D1800000000000040000000000000003D18000000000000400000000000000040400000000000F03F000000000000F03F000000000000143D0000000000000040000000000000143D000000000000003D, 0);

  • Forum Etiquette: How to post Reporting Services problems
  • [/url]
  • Forum Etiquette: How to post data/code on a forum to get the best help - by Jeff Moden
  • [/url]
  • How to Post Performance Problems - by Gail Shaw
  • [/url]

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

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