Solved

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

Posted on 2014-09-30
3
1,250 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 50

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 50

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

PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Giving  direct access rights to main database  issues 9 59
database access query MSSQL 3 42
SQL Lag Function DateDiff 2 23
Datatable / Dates ? 4 20
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

742 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