Wednesday 29 February 2012

unable to start the SQL server and getting error message "Win32 or C++ exception, or by an access violation encountered during exception handling"

 SQL Error :
Event Type:        Error
Event Source:    MSSQL$VSDBW07
Event Category:                (2)
Event ID:              17311
Date:                     9/18/2011
Time:                    2:10:56 AM
User:                     N/A
Computer:          HQRDCA0068
Description:
SQL Server is terminating because of fatal exception c0000005. This error may be caused by an unhandled Win32 or C++ exception, or by an access violation encountered during exception handling. Check the SQL error log for any related stack dumps or messages. This exception forces SQL Server to shutdown. To recover from this error, restart the server (unless SQLAgent is configured to auto restart).

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
Cause of the issue : Problem was due to .NET Framework v2.0 corruption.

Resoultion:
1)   In folder C:\WINNT\Microsoft.NET\Framework  rename folder  v2.0.50727  to tmp_v2.0.50727
        In folder C:\WINNT\Microsoft.NET\Framework64  rename folder v2.0.50727  to tmp_v2.0.50727

2) Since removal of .NET framework from control panel was not possible (You should verify)
We followed this kb article:  http://support.microsoft.com/kb/908077

3) Launch SQL server install for SQL engine and perform the first steps until .NET framework got installed then cancel the installation
4) Check and ensure the folder v2.0.50727  got created in C:\WINNT\Microsoft.NET\Framework64
5) Launch SQL server install for SQL tools and perform the first steps until .NET framework got installed then cancel the installation
6) Check and ensure the folder v2.0.50727  got created in C:\WINNT\Microsoft.NET\Framework 
7) Server restart
8) Test
9) Remove folder tmp_v2.0.50727 from C:\WINNT\Microsoft.NET\Framework  and C:\WINNT\Microsoft.NET\Framework64

No comments:

Post a Comment