Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1620
  • Last Modified:

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

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
Mitch Small
Asked:
Mitch Small
  • 2
1 Solution
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
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
 
Mitch SmallSQL Server DeveloperAuthor Commented:
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
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
The " powered by Visual Studio" is Microsoft's branding. I think it's because SSMS was developed on Visual Studio.
0

Featured Post

Free Backup Tool for VMware and Hyper-V

Restore full virtual machine or individual guest files from 19 common file systems directly from the backup file. Schedule VM backups with PowerShell scripts. Set desired time, lean back and let the script to notify you via email upon completion.  

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now