Solved

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

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

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 47

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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.
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.

773 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