May 8, 2013 at 9:16 am
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?
May 8, 2013 at 10:14 am
See anything in the Windows Application Error log?
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
May 8, 2013 at 10:17 am
maybe you added a plugin for SSMS, and it's crashing on the close of SSMS, which causes the restart?
Lowell
May 8, 2013 at 11:09 am
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
May 8, 2013 at 11:16 am
I experience this same behavior, both on a system with SQL Prompt and one without.
May 8, 2013 at 1:56 pm
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
February 28, 2014 at 7:46 am
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.
March 4, 2014 at 9:46 am
Yep still restarts with the same error message.
March 26, 2014 at 3:19 pm
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
June 12, 2014 at 11:36 am
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.
June 12, 2014 at 5:43 pm
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);
Viewing 11 posts - 1 through 10 (of 10 total)
You must be logged in to reply to this topic. Login to reply