July 25, 2013 at 11:48 am
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)
**** ALSO 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
July 25, 2013 at 1:57 pm
when you run the installer are you right clicking on it and selecting 'run as administrator'?
---------------------------------------------------------------------
July 25, 2013 at 2:12 pm
Thanks for you reply.
I didn't try installation by right clicking and running as an admin and I can't do it now until the next maintenance window comes. I am just doing my research so that I am ready to complete this installation during maintenance window during off hours in the weekend.
My account is already System admin. So even if I ran it as my account it ran with sysadmin permissions. I don't believe it will make any difference in end result.
July 25, 2013 at 3:48 pm
believe me, you need to run it this way to get full admin privileges.
---------------------------------------------------------------------
July 29, 2013 at 9:49 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 service 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
July 30, 2013 at 2:39 am
If you are running on Windows 2008 or Vista or above, then the Administrator account has two sets of authorities. This is built in to Windows and you cannot change this behaviour.
One set of authorities gives you standard 'User' rights, and one gives you the 'Administrator' rights. If you run a program without explicitly asking for Administrator rights, then you will run it as a normal user. This is why your SP4 install is failing.
It is worth investigating with Google how Administrator accounts get their rights - things changed in 2006.
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
July 30, 2013 at 3:04 pm
This is Windows server 2003.
I also right click on installation file and chose "RUN AS ADMINISTRATOR" and it still fails.
August 2, 2013 at 9:44 am
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?
August 2, 2013 at 5:08 pm
the files with 1 in the name are created during the installation process, as part of the installation is just to copy the new version of the resource database files into place. Whether the originals are renamed out of the way and then removed or the new versions are copied in as the '1' files, the originals removed then the new version renamed I dont know.
As your installation is failing on permissions you are left with both versions of the files.
Run as administrator has always worked for me, try asking a sysadmin to disable User Access controls (UAC), and perhaps run procmon whilst you run the upgrade to give more info on the permissions problem.
---------------------------------------------------------------------
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply