none
SQL 2005 SP4 installation fails

    Question

  • I am trying to install SP4 for SQL 2005 and getting this error below even though I am a system admin with highest permissions.

    MSI (s) (C8:B8) [13:15:55:131]: Note: 1: 2262 2: Error 3: -2147287038
    MSI (s) (C8:B8) [13:15:55:131]: Product: Microsoft SQL Server 2005 (64-bit) -- Error 1321. The Installer has insufficient privileges to modify this file: D:\SQLData\MSSQL.1\MSSQL\DATA\mssqlsystemresource1.ldf.

    Error 1321. The Installer has insufficient privileges to modify this file: D:\SQLData\MSSQL.1\MSSQL\DATA\mssqlsystemresource1.ldf.
    MSI (s) (C8:B8) [13:15:55:131]: User policy value 'DisableRollback' is 0
    MSI (s) (C8:B8) [13:15:55:131]: Machine policy value 'DisableRollback' is 0
    Action ended 13:15:55: InstallFinalize. Return value 3.
    MSI (s) (C8:B8) [13:15:55:147]: Executing op: Header(Signature=1397708873,Version=405,Timestamp=1123314169,LangId=1033,Platform=589824,ScriptType=2,ScriptMajorVersion=21,ScriptMinorVersion=4,ScriptAttributes=1)

    ****IN THE INSTALLATION LOG FILES I SEE BELOW ENTRIES WHICH SOUND ALSO SUSPICIOUS.

    MSI (s) (C8!6C) [13:15:45:495]: PROPERTY CHANGE: Adding Rollback_sqlFileRename.3EA9D9BF_D9D2_4023_B2A7_9E2137B2FB1B property. Its value is '100Renaming Files200D:\SQLData\MSSQL.1\MSSQL\DATA\mssqlsystemresource1.ldfD:\SQLData\MSSQL.1\MSSQL\DATA\mssqlsystemresource.ldf0'.
    MSI (s) (C8!6C) [13:15:45:495]: Doing action: Rollback_sqlFileRename.3EA9D9BF_D9D2_4023_B2A7_9E2137B2FB1B
    <EndFunc Name='SetCAContext' Return='T' GetLastError='0'>
    MSI (s) (C8!6C) [13:15:45:495]: Transforming table CustomAction.

    MSI (s) (C8!6C) [13:15:45:495]: Note: 1: 2262 2: CustomAction 3: -2147287038
    MSI (s) (C8!6C) [13:15:45:510]: Transforming table CustomAction.

    MSI (s) (C8!6C) [13:15:45:510]: Transforming table CustomAction.

    MSI (s) (C8!6C) [13:15:45:510]: Note: 1: 2262 2: CustomAction 3: -2147287038
    MSI (s) (C8!6C) [13:15:45:510]: Transforming table CustomAction.

    MSI (s) (C8!6C) [13:15:45:510]: Note: 1: 2262 2: CustomAction 3: -2147287038
    MSI (s) (C8!6C) [13:15:45:510]: Transforming table CustomAction.

    MSI (s) (C8!6C) [13:15:45:510]: Note: 1: 2262 2: CustomAction 3: -2147287038
    MSI (s) (C8!6C) [13:15:45:510]: Note: 1: 2235 2:  3: ExtendedType 4: SELECT `Action`,`Type`,`Source`,`Target`, NULL, `ExtendedType` FROM `CustomAction` WHERE `Action` = 'Rollback_sqlFileRename.3EA9D9BF_D9D2_4023_B2A7_9E2137B2FB1B'
    MSI (s) (C8!6C) [13:15:45:510]: Transforming table CustomAction.

    ** I SEE TWO RESOURCE DATABASES CREATED ON THE SAME FOLDER WHERE MY MASTER DATABASE EXIST. IN OUR FORM PEOPLE ARE SUGGESTING TO MAKE SURE THAT RESOURCE DATABASE SHOULD BE IN SAME FOLDER LIKE MASTER. I HAVE IT IN SAME FOLDER SO THAT IS NOT AN ISSUE.

    Can someone please help me out?

    Thanks

    Thursday, July 25, 2013 5:43 PM

All replies

  • I am trying to install SP4 for SQL 2005 and getting this error below even though I am a system admin with highest permissions.

    MSI (s) (C8:B8) [13:15:55:131]: Note: 1: 2262 2: Error 3: -2147287038
    MSI (s) (C8:B8) [13:15:55:131]: Product: Microsoft SQL Server 2005 (64-bit) -- Error 1321. The Installer has insufficient privileges to modify this file: D:\SQLData\MSSQL.1\MSSQL\DATA\mssqlsystemresource1.ldf.

    Error 1321. The Installer has insufficient privileges to modify this file: D:\SQLData\MSSQL.1\MSSQL\DATA\mssqlsystemresource1.ldf.
    MSI (s) (C8:B8) [13:15:55:131]: User policy value 'DisableRollback' is 0
    MSI (s) (C8:B8) [13:15:55:131]: Machine policy value 'DisableRollback' is 0
    Action ended 13:15:55: InstallFinalize. Return value 3.
    MSI (s) (C8:B8) [13:15:55:147]: Executing op: Header(Signature=1397708873,Version=405,Timestamp=1123314169,LangId=1033,Platform=589824,ScriptType=2,ScriptMajorVersion=21,ScriptMinorVersion=4,ScriptAttributes=1)

    ****IN THE INSTALLATION LOG FIL

    Thanks

    Login into your windows server as administrator and then try running SP4 installable,it seems to me as insufficient right issue,Just check you have rights on folder or specifically add ur account in security tab of folder and give full rights and try  D:\SQLData\MSSQL.1\MSSQL\DATA 



    Please mark this reply as the answer or vote as helpful, as appropriate, to make it useful for other readers


    • Edited by Shanky_621 Thursday, July 25, 2013 6:03 PM edit
    Thursday, July 25, 2013 5:59 PM
  • (1)I am already logged in as a windows server administrator.

    (2) My resource database is created in the same folder where master exists.

    So I can confirm that this issue is not due to any of the two things. Any other ideas?

    Thursday, July 25, 2013 6:02 PM
  • Hello,

    Please try to run the Command Prompt with the “Run as Administrator” option, navigate to the folder where SP4 executable is located and then run setup from there.  
     
    Hope this helps.

    Regards,

    Alberto Morillo
    SQLCoffee.com

    Thursday, July 25, 2013 6:58 PM
    Moderator
  • can you please share current sp level using serverproperty('productversion')

    Thursday, July 25, 2013 7:02 PM
  • also you can try below steps

    reboot windows server

    then install sp4

    Thursday, July 25, 2013 7:04 PM
  • serverproperty('productversion') retruns:

    9.00.4053.00

    Thursday, July 25, 2013 9:56 PM
  • I already tried rebooting windows server and install SP4 but still got failure when I tried it last time.

    Thursday, July 25, 2013 10:00 PM
  • Hi Programmer76,

    First, we should check the file referenced in the error (“D:\SQLData\MSSQL.1\MSSQL\DATA\mssqlsystemresource1.ldf.”) exists in your system. If it exists, please right click the file select the security in the property, and grant full permission to the current Windows account.

    Second, regarding to the concern that “I SEE TWO RESOURCE DATABASES CREATED ON THE SAME FOLDER WHERE MY MASTER DATABASE EXIST”. As far as I know, it is not allowed that two files with the same name locate under the same path. Please double check their full name (includes file extension).

    Finally, the issue may occur due to security software’s conflict. We can try following steps to resolve it.
    1.Temporarily disable your antivirus or security software.
    2.Install your update.
    3.Re-enable your security software.
    If the mentioned solutions do not resolve the issue, we attempt to change installation path.

    There are some similar issues, you can review these links.
    http://blog.sqlauthority.com/2010/01/31/sql-server-location-of-resource-database-in-sql-server-editions/
    http://www.sqlservercentral.com/Forums/Topic565847-146-1.aspx#bm566301

    Regards,
    Heidi Duan



    Monday, July 29, 2013 7:53 AM
  • I also faced similar issue few days back, this is due to insufficient permissions

    As per my observation while patching a resource database copy is maintained named as mssqlsystemresource1.mdf and mssqlsystemresource1.ldf

    So, to resolve this provide the permissions either to everyone or account used for patching on  resource database .mdf and .ldf files (all four) and rerun the patch

    mssqlsystemresource.mdf

    mssqlsystemresource.ldf

    mssqlsystemresource1.mdf

    mssqlsystemresource1.ldf


    Please click the Mark as answer button and vote as helpful if this reply solves your problem

    Monday, July 29, 2013 9:33 AM
  • I tried giving "EVERYONE" and my system admin account full permission for all these 4 files manually and still installation fails with the same error.

    I also tried giving "EVERYONE" and my system account  full permission on the  parent folder

    D:\SQLData\MSSQL.1\MSSQL\DATA  where this file exists and still the installation fails.

    I also right click on installation file and chose "RUN AS ADMINISTRATOR" and ran it with locan windows domain admin account and it still fails!

    Restarting the windows server before starting the patch didn't help either. Also stopped all the antivirus services and sql server services before the installation and that didn't help as well.


    • Edited by programmer76 Monday, July 29, 2013 3:48 PM more info
    Monday, July 29, 2013 3:45 PM
  • Hello,

    Please verify that SYSTEM and Administrators have Full Control access to the path and files. It does not matter the permissions to other accounts. Verify the permission on parent folders too. The following article has detailed information on how to assign those permissions:

    http://helpx.adobe.com/creative-suite/kb/error-1321-installer-insufficient-privileges.html

    Hope this helps.

    Regards,

    Alberto Morillo
    SQLCoffee.com

    Monday, July 29, 2013 6:37 PM
    Moderator
  • I checked permissions and they all are in place in exact way that article is suggesting. So permission is not an issue.

    I also verified that SYSTEM AND ADMINISTRATORS HAVE FULL ACCESS TO PARENT FOLDER AND ALSO INDIVIDUAL FILE ITSELF.

    I also manually added my system admin account to parent folder and gave that full control permission as well. But still no luck and installation keeps on failing.

    • Edited by programmer76 Tuesday, July 30, 2013 8:57 PM more content
    Tuesday, July 30, 2013 8:56 PM
  • Why do I see these two files at the first place?

    Mssqlsystemresource1.ldf

    Mysqlsystemresource1.mdf

    There are other instance on this server where SP4 installation was successful and I only see below two files there.

    Mssqlsystemresource.ldf
    Mysqlsystemresource.mdf

    While for this installation which is failing i see below 4 files.

    Mssqlsystemresource.ldf
    Mysqlsystemresource.mdf
    Mssqlsystemresource1.ldf
    Mysqlsystemresource1.mdf

    Can these two files be created due to failed installation of SP4?

    Also while reading the log you can see that installer is trying to rename this file to original file name.

    • MSI (s) (C8!6C) [13:15:45:495]: PROPERTY CHANGE: Adding Rollback_sqlFileRename.3EA9D9BF_D9D2_4023_B2A7_9E2137B2FB1B property. Its value is '100Renaming Files200D:\SQLData\MSSQL.1\MSSQL\DATA\mssqlsystemresource1.ldfD:\SQLData\MSSQL.1\MSSQL\DATA\mssqlsystemresource.ldf0'.
      MSI (s) (C8!6C) [13:15:45:495]: Doing action: Rollback_sqlFileRename.3EA9D9BF_D9D2_4023_B2A7_9E2137B2FB1B
      <EndFunc Name='SetCAContext' Return='T' GetLastError='0'>
      MSI (s) (C8!6C) [13:15:45:495]: Transforming table CustomAction.

    MSI (s) (C8!6C) [13:15:45:495]: Note: 1: 2262 2: CustomAction 3: -2147287038
    MSI (s) (C8!6C) [13:15:45:510]: Transforming table CustomAction.

    MSI (s) (C8!6C) [13:15:45:510]: Transforming table CustomAction.

    Can I just move these two files Mssqlsystemresource1.ldf and Mysqlsystemresource1.mdf which is giving us problem to some other folder and eventually delete it if installation is successful?

    Just one issue i see in this approach is that if all these 4 files belong to the resource database then moving this files to some other folder will make resource database corrupt?

    Friday, August 02, 2013 3:44 PM
  • Hello,

    Please try the following article:

    http://danieladeniji.wordpress.com/2011/03/17/microsoft-sql-server-v2005-sp4-upgrade-fails-unable-to-update-mssqlsystemresource-mdf-and-mssqlsystemresource-ldf/

    The user rights explained on the following article may be missing:

    http://support.microsoft.com/kb/2000257

    Hope this helps.

    Regards,

    Alberto Morillo
    SQLCoffee.com

    Friday, August 02, 2013 4:15 PM
    Moderator