Error Number 29538
Recent PostsRecent Posts Popular TopicsPopular Topics Home Search Members Calendar Who's On Home » SQL Server 2005 » Administering » Error 29538 while installing Hotfix 11 posts,Page 1 of 212»» Error 29538 while installing Hotfix Rate Topic Display Mode Topic Options Author Message Amit ChaudharyAmit Chaudhary Posted Monday, September 8, 2008 6:55 PM SSC Rookie Group: General Forum Members Last Login: Thursday, February 21, 2013 7:52 PM Points: 28, Visits: 159 While installing hotfix 951217 on SQL 2005, I get the folowing error :Error Number : 29538Error Description : MSP Error: 29538 SQL Server Setup did not have the administrator permissions required to rename a file: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\mssqlsystemresource1.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 have checked the Security under Proerties for this file and Administrators is added to it.Any advise... is helpfulThanks, Post #565847 MarkusBMarkusB Posted Tuesday, September 9, 2008 4:32 AM SSCarpal Tunnel Group: General Forum Members Last Login: Wednesday, January 27, 2016 5:54 AM Points: 4,429, Visits: 4,204 The prblem is not that Administrator didn't have permissions on the file, but that the Hotfix installation was started under an account which is not an administrator on the server. Markus Bohse Post #566020 Amit ChaudharyAmit Chaudhary Posted Tuesday, September 9, 2008 10:08 AM SSC Rookie Group: General Forum Members Last Login: Thursday, February 21, 2013 7:52 PM Points: 28, Visits: 159 I have installed this hotfix on other Production Servers successfully, and I am member of a group which in turn is part of Administrators on this Server. So, I don't think, this is the problem.THan
setup failing with 29538error Posted on December 30, 2009 by Amit Banerjee There are numerous occasions when we find that the SQL Server 2005 setup has failed due to the following error: Product : Database Services (MSSQLSERVER) Product Version (Previous): 3042 Product Version (Final) : Status : Failure Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\SQL9_Hotfix_KB955706_sqlrun_sql.msp.log Error Number : 29538 Error Description : MSP Error: 29538 SQL Server Setup did not have the administrator permissions required to rename a file: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\mssqlsystemresource1.ldf. To continue, verify that the file exists, and either grant administrator permissions http://www.sqlservercentral.com/Forums/Topic565847-146-1.aspx to the account currently running Setup or log in with an administrator account. Then run SQL Server Setup again. This can happen when we are trying to install SQL Server Service Packs, Hotfixes, Cumulative Updates or GDRs. Now what you need to do is find if any of the following are true: 1. The SQL Server service account doesn't have sufficient privileges on the https://troubleshootingsql.com/2009/12/30/sql-server-2005-setup-failing-with-29538-error/ DATA folder of SQL Server 2. It is a recommendation that the MSSQLSYSTEMRESOURCE files (MDF and LDF) be in the same location as the master database. This issue is documented under KB947989. 3. Another point that you would want to check is if you have any services to re-start the SQL service if it is stopped. SQL Server Setup performs setup in two phases: the first phase being replacement of binaries and the second phase being running the configuration scripts for updating the metadata. During the first phase, the SQL Server service is stopped. In case, you have a service which restarts the SQL service at that point, then you would run into this issue. The easiest way to verify this would be to check the status of the SQL service from the Services snap-in right after the failure and it should show up as started. Or if you are command prompt savvy , then you could use "sc query mssqlserver" (provided it's a default instance) to check the state. If it's a named instance, then the service name would change from mssqlserver to mssql$
Tools Display Modes SQL Server Upgrade MSP Error: 29538 on KB934458 Upgrade http://www.mssqlforums.com/sql-server-upgrade-msp-error-29538-kb934458-upgrade-t278814.html Greg J. Guest Posts: n/a 05-13-2008 http://www.busydevelopers.com/article/42975810/SQL+Server+Upgrade+MSP+Error%3A+29538+on+KB934458+Upgrade We have a server instance on SQL Server 2005 SP2 build 3042. We have a 32 bit x86 server. We attempted to upgrade to SP2 build 3054 KB934458. And we got the following error as stated in the error number Summary.txt file. ************************************************** ******************************** Product Installation Status Product : SQL Server Database Services 2005 (MSSQLSERVER) Product Version (Previous): 3042 Product Version (Final) : Status : Failure Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\SQL9_Hotfix_KB934458_sqlrun_s ql.msp.log Error Number : 29538 Error Description : MSP Error: 29538 SQL Server error number 29538 Setup did not have the administrator permissions required to rename a file: e:\SQL\Data\mssqlsystemresource1.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 ---------------------------------------------------------------------------------- The client tools and workstation components were successfully installed. The server is still reporting build 3042. Here is the portions of the HotFix.log file. 05/12/2008 09:19:09.041 Copy Engine: Creating MSP install log file at: C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\SQL9_Hotfix_KB934458_sqlrun_s ql.msp.log 05/12/2008 09:19:09.072 Registry: Opened registry key "Software\Policies\Microsoft\Windows\Installer " 05/12/2008 09:19:09.103 Registry: Cannot read registry key value "Debug" 05/12/2008 09:21:29.382 MSP Error: 29538 SQL Server Setup did not have the administrator permissions required to rename a file: e:\SQL\Data\mssqlsystemresource1.ldf. To continue, verify that the file exists, and either grant administrator permissions to the account currently running Setup o
SQL Server 2005 SP2 build 3042. We have a 32 bit x86 server. We attempted to upgrade to SP2 build 3054 KB934458. And we got the following error as stated in the Summary.txt file. Code Snippet ********************************************************************************** Product Installation Status Product : SQL Server Database Services 2005 (MSSQLSERVER) Product Version (Previous): 3042 Product Version (Final) : Status : Failure Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\SQL9_Hotfix_KB934458_sqlrun_sql.msp.log Error Number : 29538 Error Description : MSP Error: 29538 SQL Server Setup did not have the administrator permissions required to rename a file: e:\SQL\Data\mssqlsystemresource1.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. ---------------------------------------------------------------------------------- The client tools and workstation components were successfully installed. The server is still reporting build 3042. Here is the portions of the HotFix.log file. Code Snippet 05/12/2008 09:19:09.041 Copy Engine: Creating MSP install log file at: C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\SQL9_Hotfix_KB934458_sqlrun_sql.msp.log 05/12/2008 09:19:09.072 Registry: Opened registry key "Software\Policies\Microsoft\Windows\Installer" 05/12/2008 09:19:09.103 Registry: Cannot read registry key value "Debug" 05/12/2008 09:21:29.382 MSP Error: 29538 SQL Server Setup did not have the administrator permissions required to rename a file: e:\SQL\Data\mssqlsystemresource1.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. 05/12/2008 09:22:33.678 MSP returned 1603: A fatal error occurred during installation. 05/12/2008 09:22:33.724 Registry: Opened registry key "Software\Policies\Microsoft\Windows\Installer" Any help would be appreciated. Can you please check if the sql service account has permissions to the mssqlsystemresource1.ldf file and also for the login with which you run the install ? Also check if the below thread helps, http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1256260&SiteID=1- Deepak Real quick answer as I have to