I was doing a SQL Server 2005 install and it fails at the end of the install when it attempts to start the SQL services. The messages in Event viewer look like the below:
Faulting application sqlservr.exe, version 2005.90.1399.0, faulting module sqlservr.exe, version 2005.90.1399.0, fault address 0x0000000000b323f0.
The application, E:\Program Files\MSSQL.1\MSSQL\Binn\sqlservr.exe, generated an application error The error occurred on 05/19/2010 @ 16:26:00.026 The exception generated was c0000005 at address 0000000001B323F0 (sqlservr!DmpGetClientExport)
Below are the steps to work around this problem:
1. At the time you get the failure to start SQL Sevrver during setup you are presented with a retry option.
2. At this time, replace the SQLSERVR.exe and SQLOS.dll in the BINN folder at your install location from another SQL instance which already has Service Pack 2 installed and then click on 'Retry'.
Immediately patch it with SP3 or the latest SP available
Subscribe to:
Posts (Atom)
Display the list of indexes and columns for a given table
You might find yourself in a situation where you have to analyze the indexes for a given table and want to know which columns are part of wh...
-
We recently had failures for our Backup Maintenance Plan (performing T-Log backups) and it would fail with the below error message: Message ...
-
For executing a query against each database, we can use either dynamic SQL (search my other posts for info on that) or use undocumented stor...
-
I tried installing SQL2012 and encountered a failure with the below messages in the Summary file in folder C:\Program Files\Microsoft SQL ...