SSMS 2012 Restarts Itself

Question

Post reply

SSMS 2012 Restarts Itself

DeWayne_McCallie

Hall of Fame

Points: 3617
More actions
May 8, 2013 at 9:16 am

#277501

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?
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]

TheSQLGuru SSC Guru Points: 134017 More actions · Answer 1

See anything in the Windows Application Error log?

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

Lowell SSC Guru Points: 323507 More actions · Answer 2

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!

DeWayne_McCallie Hall of Fame Points: 3617 More actions · Answer 3

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

btuck SSC Veteran Points: 263 More actions · Answer 4

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

TheSQLGuru SSC Guru Points: 134017 More actions · Answer 5

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

don.brooks SSC Enthusiast Points: 176 More actions · Answer 6

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.

DeWayne_McCallie Hall of Fame Points: 3617 More actions · Answer 7

DeWayne_McCallie

Hall of Fame

Points: 3617

March 4, 2014 at 9:46 am

#1693962

Yep still restarts with the same error message.

bartedgerton SSCrazy Points: 2062 More actions · Answer 8

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

jasonclements32304 Ten Centuries Points: 1122 More actions · Answer 9

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.

mister.magoo SSC-Forever Points: 47068 More actions · Answer 10

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);