SQL Server 2005 SP2 Security Upgrade Fails To Install

Question

 

This upgrade fails to install. Here's my summary.txt file.

 

Time: 07/13/2008 13:48:26.968
KB Number: KB948109
Machine: ZEKE
OS Version: Microsoft Windows XP Professional Service Pack 3 (Build 2600)
Package Language: 1033 (ENU)
Package Platform: x86
Package SP Level: 2
Package Version: 3068
Command-line parameters specified:
     /quiet
     /allinstances
Cluster Installation: No

**********************************************************************************
Prerequisites Check & Status
SQLSupport: Passed

**********************************************************************************
Products Detected                         Language  Level  Patch Level       Platform  Edition
SQL Server Database Services 2005 (ACT7)  ENU       SP2    2005.090.3042.00  x86       EXPRESS
SQL Server Database Services 2005 (MSSMLBIZ)  ENU       SP2    2005.090.3068.00  x86       EXPRESS
SQL Server Database Services 2005 (SQLEXPRESS)  ENU       SP2    2005.090.3068.00  x86       EXPRESS
SQL Server Tools and Workstation Components 2005  ENU       SP2           9.2.3068  x86       EXPRESS

**********************************************************************************
Products Disqualified & Reason
Product                                   Reason

**********************************************************************************
Processes Locking Files
Process Name          Feature               Type          User Name                  PID
MSSQL$ACT7            SQL Server Database Services  Service       NT AUTHORITY\SYSTEM        4284

**********************************************************************************
Product Installation Status
Product                   : SQL Server Database Services 2005 (ACT7)
Product Version (Previous): 3042
Product Version (Final)   :
Status                    : Failure
Log File                  :
SQL Express Features      :
Error Number              : 11016
Error Description         : SQL Server not responsive prior to running Repl post script procedure
----------------------------------------------------------------------------------
Product                   : SQL Server Database Services 2005 (MSSMLBIZ)
Product Version (Previous): 3068
Product Version (Final)   :
Status                    : Not Selected
Log File                  :
SQL Express Features      :
Error Number              : 0
Error Description         :
----------------------------------------------------------------------------------
Product                   : SQL Server Database Services 2005 (SQLEXPRESS)
Product Version (Previous): 3068
Product Version (Final)   :
Status                    : Not Selected
Log File                  :
SQL Express Features      :
Error Number              : 0
Error Description         :
----------------------------------------------------------------------------------
Product                   : SQL Server Tools and Workstation Components 2005
Product Version (Previous): 3068
Product Version (Final)   :
Status                    : Not Selected
Log File                  :
SQL Express Features      :
Error Number              : 0
Error Description         :
----------------------------------------------------------------------------------

**********************************************************************************
Summary
     SQL Server not responsive prior to running Repl post script procedure
     Exit Code Returned: 11016

 

Answer 1

 

 

 

Same Problem exactly!

---------------------------------------------------------

To Peter Saddow

Privet, Peter

We are on the way to SQL SERVER 2008 and still “digging in the dirt” of failed installs. If those installs are not thoroughly QA-ded, don’t upload them.

Answer 2

I'm also having the same issue but with a different instance than ACT! and on XP SP2.

Answer 3

Me too!  (same error with Express, not Act, but product version = 3042).

**********************************************************************************
Product Installation Status
Product                   : SQL Server Database Services 2005 (SQLEXPRESS)
Product Version (Previous): 3042
Product Version (Final)   :
Status                    : Failure
Log File                  :
SQL Express Features      :
Error Number              : 11016
Error Description         : SQL Server not responsive prior to running Repl post script procedure
----------------------------------------------------------------------------------


Anybody listening!?!

Answer 4

 

I am also experiencing the problem.  After scouring the web, I believe I have an idea of what the problem may be (at least for my situation).  When I look at the hotfix.log file in the folder "C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\log\Hotfix" I see a line that reads, "Validating database connections using Windows Authentication" followed by a bunch of "Pre-script database connection failed" messages.  I then tried to connect to that database using SQL Server Management Studio Express and it will not let me connect using Windows Authentication.  So my guess is that the 948109 update from Microsoft needs to connect to the database using Windows Authentication and since my database does not support that, it is failing.

 

What I would like to do is go into the database and turn on Windows Authentication and see if the update works to test my theory.  However, this is a vendor supplied database so I am not able to get access to it.  When I called the vendor they said they were aware of the 948109 hotfix issue and were working with Microsoft to resolve it.

Answer 5

 

I am also experiencing the same problem.

Answer 6

I found solution for me - enable "Shared memory" protocol (if you have disabled it some time ago, like I was).

Answer 7

Try this,

 

It should help

 

http://blogs.msdn.com/sqlserverfaq/archive/2008/07/24/error-29527-while-installing-security-patch-948109-on-sql-server-2005.aspx

 

 

Answer 8

Hi Steve,

 

You are correct. The actual cause of this error is that when we install ACT7 software on the system, SQL Server is used as the back-end. ACT7 deletes or does not create the Windows logins (may be for security reasons) including the BUILTIN\Administrator account for that instance of the SQL server instance.

 

Hence, when we try to install security update of sql server (KB948109 in this case) , we get the error :

 

Error : 11016 SQL Server not responsive prior to running Repl post script procedure

 

To verify this, install SQL Server Management Studio (SSMS) on you machine which can be downloaded from here .

Once you install SSMS, try connecting to your SQL instance (Instance Name is ACT7 in this case) using 'Windows Authentication' . If you are unable to connect and get below error most likely  windows login or BUILTIN\Administrator account for SQL server instance is absent :

 

 Login failed error 18456.

So the resolution in this case is that we have to create an account for SQL server instance using which we (or KB948109 installer) can connect to SQL Server instance . The resolution steps is as follows :

 

1. Start SQL in single user mode by pasting below command on the command prompt :

 

C:\Program Files\microsoft sql server\MSSQL.1\MSSQL\Binn\Sqlservr.exe -s ACT7 -m -c

2. Open another CMD prompt and connect to the instance by :

C:\sqlcmd -S <machine_name>\ACT7 -E
1>Create login [Windows Account] from windows

2>go
1>sp_addsrvrolemember ‘Windows Account’,'sysadmin'
2>go
exit

P.S. : [Windows Account] can be determined by executing 'whoami' on command prompt without quotes. It should be in the form of Domain_name\User_name . <machine_name>  can be determined by executing 'hostname' on command prompt without quotes.

-- Stop the SQL Server services from Services Panel (Start>All Programs>Administrative Tools>Services)

-- Start the SQL Services back.

-- Run the Setup of KB948109 and it should succeed.