SQL Server - SQL server corruption - Asked By Vikrant on 12-Sep-11 05:45 AM

Error 14001 :- The application has failed to start because the application configuration is incorrect.
Re-installing this application may fix the problem
I checked the event logs and found the corresponding entries in there :

Generate Activation Context failed for C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\sqlservr.exe. Reference error message: The referenced assembly is not installed on your system.

Resolve Partial Assembly failed for Microsoft.VC80.ATL. Reference error message: The referenced assembly is not installed on your system.
I  tried the following :-

1) I tried to install Microsoft VC+2005 Redistributable package twice , but even it did not install, it gave the message (almost on the verge of completion) : Install server not responding
2) I tried to un-install SQL server from the Add/ Remove program section ,but even this failed.
3) Since I was logged in as domain admin, i logged off and then logged back in as local admin, still the un-install would not take place.
I was upgrading software when i faced this issue. what can be the possible cause of this. Is there any mechanism in SQL server with the help of which we can repair the SQL server.
It is a windows server, 2003, SP2, 32 bit edition. SQL is 2005 standard edition. SP2 is presently installed.

Hi,

The problem is most likely some of the other dlls required by a VS 2005 application. In particular, msvcrt80.dll for certain. Also, there is a change to how dlls are loaded with VS 2005. Every dll needs a manifest file. I don't know what it is off the top of my head; however, there will be a manifest file associated with the msvcrt80. If you can get a copy of depends.exe, try using it on your executable (on the machine where it fails). This will tell you which libraries are missing on the target machine.

These libraries and their associated manifest files will need to be somewhere in the user's PATH. It might work if they're simply in the same directory as your executable, but I'm not certain.

You can also use the redist install exe's if merge modules don't work with your installer technology:

• http://www.microsoft.com/downloads/details.aspx?familyid=32BC1BEE-A3F9-4C13-9C99-220B62A191EE&displaylang=en
• http://www.microsoft.com/downloads/details.aspx?familyid=200b2fd9-ae1a-4a14-984d-389c36f85647&displaylang=en

As a last resort try copying the entire 'Microsoft.VC80.CRT' directory to your programs exe directory (not the contents, the actual directory).

Hi Reena,
Thanks for the resolution. The issue is resolved.
However, I am now unable to upgrade the SQL server 2005 SP3. When i try to upgrade the SP3, during the install i get the message :-
"The feature you are trying to use is on a network resource that is
unavailable"
It asks for SQLRun_sql.msi and by default the path specified in windows installer is C:\Temp\SQL2005STD\CD1\ which is not present any more.
I uploaded the files on the server, and gave the path C:\Program Files\Microsoft SQL Server\90\Tools\Binn\, but the install failed soon after with the error :- KB 955706 failed.

I checked the log files and following are some of the important observations :

C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\HotFix.log
C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\Summary.txt
C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\SQL9_Hotfix_KB955706_sqlrun_sql.msp.log
C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\SQL9_Hotfix_KB955706_sqlrun_sql.msp.xml

C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\HotFix.log----log files reveal the following :-

09/22/2011 01:06:03.915 Installing file: sqlrun_sql.msp
09/22/2011 01:06:03.931 Copy Engine: Creating MSP install log file at: C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap

\LOG\Hotfix\SQL9_Hotfix_KB955706_sqlrun_sql.msp.log
09/22/2011 01:06:03.931 Registry: Opened registry key "Software\Policies\Microsoft\Windows\Installer"
09/22/2011 01:06:03.947 Registry: Cannot read registry key value "Debug", error 0
09/22/2011 02:39:10.659 MSP returned 1635: This patch package could not be opened. Verify that the patch package exists and is

accessible, or contact the application vendor to verify that this is a valid Windows Installer patch package.
09/22/2011 02:39:10.674 Registry: Opened registry key "Software\Policies\Microsoft\Windows\Installer"
09/22/2011 02:39:10.690 Registry: Cannot read registry key value "Debug", error 0
09/22/2011 02:39:10.690 Copy Engine: Error, unable to install MSP file: g:\9a95c158d77876e3610261\HotFixSQL\Files\sqlrun_sql.msp
09/22/2011 02:39:10.706 The following exception occurred: Unable to install Windows Installer MSP file  Date: 09/22/2011

02:39:10.706  File: \depot\sqlvault\stable\setupmainl1\setup\sqlse\sqlsedll\copyengine.cpp  Line: 807
09/22/2011 02:39:15.081 Watson: Param1 = Unknown
09/22/2011 02:39:15.096 Watson: Param2 = 0x663
09/22/2011 02:39:15.112 Watson: Param3 = Unknown
09/22/2011 02:39:15.112 Watson: Param4 = 0x663
09/22/2011 02:39:15.127 Watson: Param5 = copyengine.cpp@807
09/22/2011 02:39:15.143 Watson: Param6 = Unknown
09/22/2011 02:39:15.159 Watson: Param7 = SQL9
09/22/2011 02:39:15.190 Watson: Param8 = Hotfix@
09/22/2011 02:39:15.206 Watson: Param9 = x86
09/22/2011 02:39:15.206 Watson: Param10 = 4035
09/22/2011 02:39:15.206 Installed product: SQL9
09/22/2011 02:39:15.221 Installing product: Redist9
09/22/2011 02:39:15.237 Installing instance: SQL Server Native Client
09/22/2011 02:39:15.237 Installing target: A4HS-HMO
09/22/2011 02:39:15.252 Installing file: sqlncli.msi
09/22/2011 02:39:15.377 Copy Engine: Creating MSI install log file at: C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap

\LOG\Hotfix\Redist9_Hotfix_KB955706_sqlncli.msi.log
09/22/2011 02:39:15.377 Registry: Opened registry key "Software\Policies\Microsoft\Windows\Installer"
09/22/2011 02:39:15.377 Registry: Cannot read registry key value "Debug", error 2

C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\Summary.txt---log files reveal the following :-

----------------------------------------------------------------------------------
Product           : Database Services (MSSQLSERVER)
Product Version (Previous): 3042
Product Version (Final)   :
Status            : Failure
Log File          : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix

\SQL9_Hotfix_KB955706_sqlrun_sql.msp.log
Error Number        : 1635
Error Description     : *** Shared String ID 1635 Not Found ***
----------------------------------------------------------------------------------

C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\SQL9_Hotfix_KB955706_sqlrun_sql.msp.log----log files reveal

the following :--

1) Warning: Local cached package 'C:\WINDOWS\Installer\1a0b0c.msi' is missing.

2) MSI (s) (B4:FC) [02:38:39:424]: Package we're running from ==> C:\WINDOWS\Installer\357f75e7.msi

3) Opening existing patch 'c:\WINDOWS\Installer\1a0c00.msp'.
MSI (s) (B4:FC) [02:38:39:518]: Note: 1: 2203 2: c:\WINDOWS\Installer\1a0c00.msp 3: -2147287038
MSI (s) (B4:FC) [02:38:39:518]: Couldn't find local patch 'c:\WINDOWS\Installer\1a0c00.msp'. Looking for it at its source.

I checked for the missing msp file, it was 1a0c00.msp. i checked its corresponding GUID in the registry and with the help of the GUID,i found that KB articel which was needed: :- http://support.microsoft.com/kb/933097
I tried to install it, but it failed with the error message :- A recently applied KB articel failed to install.
Please help.