April 8, 2010 at 4:14 am
I have applied Security update KB970894 on SQL server 2005 SP3 system it is succeeded on SQL Server Analysis services, Notification services, Integration services,Server Tools and workstation comp. and FAILED IN DATABASE SERVICES.
I have verified the log located in C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\SQL9_Hotfix_KB970894_sqlrun_sql.msp.log it gives error
Property(S): SQL200532Hotfix4035 = C:\WINDOWS\Installer\22c14aa8.msp
MSI (s) (80:6C) [05:26:01:293]: Product: Microsoft SQL Server 2005 - Update 'Hotfix 4262 for SQL Server Database Services 2005 ENU (KB970894)' could not be installed. Error code 1603.
after the installation version is as follows:
SQL Server Database Services Failed 9.00.4230
SQL Server Analysis Services Success 9.00.4262
SQL Server Notification Services Success 9.00.4262
SQL Server Integration Services Success 9.00.4262
SQL Server Tools and Workstation components 2005 Success 9.00.4262
and (after the installation) noted down the following
SELECT SERVERPROPERTY('ResourceVersion');
9.00.4262
select @@version
Microsoft SQL Server 2005 - 9.00.4230.00 (Intel X86) Jul 30 2009 13:45:19 Copyright (c) 1988-2005 Microsoft Corporation Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 2)
Please help us to make to success security update
Thanks in advance
March 12, 2012 at 2:12 pm
I had the same error. When I checked the log file the hotfix created (click Summary at the end of the installation) I found the following error:
----
MSP Error: 29538 SQL Server Setup did not have the administrator permissions required to rename a file: e:\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\distmdl1.ldf. To continue, verify that the file exists, and either grant administrator permissions to the account currently running Setup or log in with an administrator account. Then run SQL Server Setup again.
-----
I had the correct permissions, but that database file was sitting in the default SQL installation folder (I had just moved all system database files to a new disk as I was rebuilding the SQL from backups). Copied those files across to my new disk and ran the hotfix installation again. Worked like a charm. :w00t:
March 12, 2012 at 2:53 pm
presuming you got the error above and the account you are using has admin privileges, grant the account full control over the mssql directory which your data directory that contains the mssqlsystemresource sits under, then rerun security patch
---------------------------------------------------------------------
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply