Solved

SQL Server 2012 Management Studio (SSMS) stops working and crashes several times everyday.

Posted on 2014-09-30
3
1,076 Views
Last Modified: 2014-10-02
SQL Server 2012 Management Studio (SSMS) stops working and crashes several times everyday.
So far I've tried reinstalling SQL Server but no resolution.

Any ideas would be appreciated

I checked the event viewer and found this:
Faulting application name: Ssms.exe, version: 2011.110.5058.0, time stamp: 0x537406e3
Faulting module name: unknown, version: 0.0.0.0, time stamp: 0x00000000
Exception code: 0xc000041d
Fault offset: 0x748a4f11
Faulting process id: 0x2bc0
Faulting application start time: 0x01cfdcc90c214bf7
Faulting application path: C:\Program Files (x86)\Microsoft SQL Server\110\Tools\Binn\ManagementStudio\Ssms.exe
Faulting module path: unknown
Report Id: 843a8db4-48cd-11e4-a826-90b11c697969

 System

  - Provider

   [ Name]  Application Error
 
  - EventID 1000

   [ Qualifiers]  0
 
   Level 2
 
   Task 100
 
   Keywords 0x80000000000000
 
  - TimeCreated

   [ SystemTime]  2014-09-30T18:13:46.000000000Z
 
   EventRecordID 59144
 
   Channel Application
 
   Computer msmall.pps.local
 
   Security
 

- EventData

   Ssms.exe
   2011.110.5058.0
   537406e3
   unknown
   0.0.0.0
   00000000
   c000041d
   748a4f11
   2bc0
   01cfdcc90c214bf7
   C:\Program Files (x86)\Microsoft SQL Server\110\Tools\Binn\ManagementStudio\Ssms.exe
   unknown
   843a8db4-48cd-11e4-a826-90b11c697969
0
Comment
Question by:Mitch Small
  • 2
3 Comments
 
LVL 46

Expert Comment

by:Vitor Montalvão
ID: 40353992
So far I've tried reinstalling SQL Server but no resolution.
You don't need to reinstall SQL Server just because a fail in SSMS. Management Studio isn't the engine but a GUI for SQL Server.
Have you installed the SP2 for SQL Server 2012? You should also install the CU2.
0
 

Author Comment

by:Mitch Small
ID: 40355929
Thanks Victor
I installed SP2 and CU2.  I also did a windows update and upgraded the The Microsoft .NET Framework to 4.5.2

It seems okay now.  I'm curious when I open SSMS the splash screen says powered by Visual Studio.  Where can I get more info on this?   I have VS 2012 installed (I also removed VS2008)

Thanks Very Much
0
 
LVL 46

Accepted Solution

by:
Vitor Montalvão earned 500 total points
ID: 40356421
The " powered by Visual Studio" is Microsoft's branding. I think it's because SSMS was developed on Visual Studio.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.

910 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now