Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


SP4 installation for SQL 2005 fails


SP4 installation for SQL 2005 fails

Author
Message
programmer76
programmer76
Grasshopper
Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)

Group: General Forum Members
Points: 15 Visits: 321
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
george sibbald
george sibbald
SSCertifiable
SSCertifiable (6.3K reputation)SSCertifiable (6.3K reputation)SSCertifiable (6.3K reputation)SSCertifiable (6.3K reputation)SSCertifiable (6.3K reputation)SSCertifiable (6.3K reputation)SSCertifiable (6.3K reputation)SSCertifiable (6.3K reputation)

Group: General Forum Members
Points: 6324 Visits: 13686
when you run the installer are you right clicking on it and selecting 'run as administrator'?

---------------------------------------------------------------------
programmer76
programmer76
Grasshopper
Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)

Group: General Forum Members
Points: 15 Visits: 321
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.
george sibbald
george sibbald
SSCertifiable
SSCertifiable (6.3K reputation)SSCertifiable (6.3K reputation)SSCertifiable (6.3K reputation)SSCertifiable (6.3K reputation)SSCertifiable (6.3K reputation)SSCertifiable (6.3K reputation)SSCertifiable (6.3K reputation)SSCertifiable (6.3K reputation)

Group: General Forum Members
Points: 6324 Visits: 13686
believe me, you need to run it this way to get full admin privileges.

---------------------------------------------------------------------
programmer76
programmer76
Grasshopper
Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)

Group: General Forum Members
Points: 15 Visits: 321
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
EdVassie
EdVassie
Hall of Fame
Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)

Group: General Forum Members
Points: 3142 Visits: 3815
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: SQL Server FineBuild 1-click install and best practice configuration of SQL Server 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005. 1 Dec 2016: now over 39,000 downloads.
Disclaimer: All information provided is a personal opinion that may not match reality.
Quote: "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
programmer76
programmer76
Grasshopper
Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)

Group: General Forum Members
Points: 15 Visits: 321
This is Windows server 2003.

I also right click on installation file and chose "RUN AS ADMINISTRATOR" and it still fails.
programmer76
programmer76
Grasshopper
Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)

Group: General Forum Members
Points: 15 Visits: 321
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?
george sibbald
george sibbald
SSCertifiable
SSCertifiable (6.3K reputation)SSCertifiable (6.3K reputation)SSCertifiable (6.3K reputation)SSCertifiable (6.3K reputation)SSCertifiable (6.3K reputation)SSCertifiable (6.3K reputation)SSCertifiable (6.3K reputation)SSCertifiable (6.3K reputation)

Group: General Forum Members
Points: 6324 Visits: 13686
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.

---------------------------------------------------------------------
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search