Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SP4 installation for SQL 2005 fails Expand / Collapse
Author
Message
Posted Thursday, July 25, 2013 11:48 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, December 5, 2014 9:19 AM
Points: 15, Visits: 307
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
Post #1477655
Posted Thursday, July 25, 2013 1:57 PM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 11:22 AM
Points: 5,888, Visits: 13,061
when you run the installer are you right clicking on it and selecting 'run as administrator'?

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

Post #1477715
Posted Thursday, July 25, 2013 2:12 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, December 5, 2014 9:19 AM
Points: 15, Visits: 307
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.
Post #1477733
Posted Thursday, July 25, 2013 3:48 PM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 11:22 AM
Points: 5,888, Visits: 13,061
believe me, you need to run it this way to get full admin privileges.

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

Post #1477778
Posted Monday, July 29, 2013 9:49 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, December 5, 2014 9:19 AM
Points: 15, Visits: 307
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
Post #1478655
Posted Tuesday, July 30, 2013 2:39 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 2:38 AM
Points: 2,900, Visits: 3,299
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 2014, 2012, 2008 R2, 2008 and 2005. 18 October 2014: now over 31,000 downloads.
Disclaimer: All information provided is a personal opinion that may not match reality.
Concept: "Pizza Apartheid" - the discrimination that separates those who earn enough in one day to buy a pizza if they want one, from those who can not.
Post #1478876
Posted Tuesday, July 30, 2013 3:04 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, December 5, 2014 9:19 AM
Points: 15, Visits: 307
This is Windows server 2003.

I also right click on installation file and chose "RUN AS ADMINISTRATOR" and it still fails.
Post #1479178
Posted Friday, August 2, 2013 9:44 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, December 5, 2014 9:19 AM
Points: 15, Visits: 307
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?

Post #1480477
Posted Friday, August 2, 2013 5:08 PM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 11:22 AM
Points: 5,888, Visits: 13,061
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.


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

Post #1480649
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse