Solved

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

Posted on 2014-09-30
3
1,196 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 48

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 48

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

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
SQL Quer 4 23
reccommendations for a free msft sql query manager? 4 29
SQLCMD Syntax 2 16
Setting variables in a stored procedure 5 23
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
I have a large data set and a SSIS package. How can I load this file in multi threading?
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

821 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