Error Number 29537
(Русский)ישראל (עברית)المملكة العربية السعودية (العربية)ไทย (ไทย)대한민국 (한국어)中华人民共和国 (中文)台灣 (中文)日本 (日本語) HomeLibraryLearnDownloadsTroubleshootingCommunityForums Ask a question Quick access Forums home Browse forums users FAQ Search related threads Remove From My Forums Answered by: SQL Server 2005 SP4 Install Fails - error log references replication system tables SQL Server > SQL Server Setup & Upgrade Question 0 Sign in to vote The OS is Windows Server 2003 R2 SP2 (32 bit). Trying to install SQL Server 2005 SP4 (current version is 9.00.4035). All SQL products update without error, except for the Database engine. The error listed in the summary.txt file in C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix is: Product : Database Services (MSSQLSERVER) Product Version (Previous): 5000 Product Version (Final) : Status : Failure Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\SQL9_Hotfix_KB2463332_sqlrun_sql.msp.log Error Number : 29537 Error Description : MSP Error: 29537 SQL Server Setup has encountered the following problem: [Microsoft][SQL Native Client][SQL Server]Update or insert of view or function 'dbo.syspublications' failed because it contains a derived or constant field.. To continue, correct the problem, and then run SQL Server Setup again. We have several databases using replication (transactional replication), so I turned off replication and disabled publishing. I tried turning replication off through SSMS - right click on replication and select "Disable Publishing and Distribution..." and I alsoput togethera transact SQL script. In both cases, replicationseemedto be removed. In both attempts to apply the SP withreplication turned off, I get the following error in the log: Product : Database Services (MSSQLSERVER) Product Version (Previous): 5000 Product Version (Final) : Status : Failure Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\SQL9_Hotfix_KB2463332_sqlrun_sql.msp.log Error Number : 29537 Error Description : MSP Error: 29537 SQL Server Setup has encountered the following problem: [Microsoft][SQL Native Client][SQL Server]Invalid object name 'mydatabase..sysreplservers'.. To continue, correct the problem, and then run SQL Server Setup again. For the databases being replicated, they have had replication on and have been
Idid not stop any services prior to installing and rebooted after theinstallation.Time: 04/27/2007 16:47:24.552KB Number: KB921896Machine: SQLOS Version: Microsoft Windows Server 2003 family, https://social.msdn.microsoft.com/Forums/sqlserver/en-US/4d993f45-f9e9-4a4a-ba6e-f1b252d20792/sql-server-2005-sp4-install-fails-error-log-references-replication-system-tables?forum=sqlsetupandupgrade Standard Edition ServicePack 1 (Build 3790)Package Language: 1033 (ENU)Package Platform: x64Package SP Level: 2Package Version: 3042Command-line parameters specified:Cluster Installation: No **********************************************************************************Prerequisites Check & StatusSQLSupport: Passed **********************************************************************************Products Detected Language Level Patch LevelPlatform EditionSetup Support http://sqlremoveoldbackups.blogspot.com/2012/02/2005-sp2-install-failed-error-29537.html Files ENU 9.00.1399.06x64Database Services (MSSQLSERVER) ENU RTM 2005.090.1399.00x64 STANDARDNotification Services ENU RTM 9.00.1399.00x64 STANDARDIntegration Services ENU RTM 9.00.1399.00x64 STANDARDSQL Server Native Client ENU 9.00.1399.06x64Client Components ENU RTM 9.00.1399.06x64 STANDARDMSXML 6.0 Parser ENU 6.00.3888.0x64SQLXML4 ENU 9.00.1399.06x64Backward Compatibility ENU 8.05.1054x64Microsoft SQL Server VSS Writer ENU 9.00.1399.06x64 **********************************************************************************Products Disqualified & ReasonProduct Reason **********************************************************************************Processes Locking FilesProcess Name Feature Type User NamePIDMSSQLSERVER SQL Server Native Client Service1472SQLSERVERAGENT SQL Server Native Client Service1932msftesql Database Services Service1672SQLBrowser Database Services Service1548MsDtsServer Integration Services Service1252 **********************************************************************************Product Installation StatusProduct : Setup Support FilesProduct Version (Previous): 1399Product Version (Final) : 3042Status : SuccessLog File : C:\Program Files\Microsoft SQL Server\90\Setup
May 11 Comments Create file encountered operating system error 3 Applying SQL Server 2005 SP4 may fail with error like below:- In bootstrap log you will see below message - Product http://databasebestpractices.com/tag/sql-server-2005-sp4/ : Database Services (MSSQLSERVER) Product Version (Previous): 4060 Product Version (Final) : Status : Failure Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\SQL9_Hotfix_KB2463332_sqlrun_sql.msp.log Error Number : 29537 Error Description : error number MSP Error: 29537 SQL Server Setup has encountered the following problem: [Microsoft][SQL Native Client][SQL Server]CREATE DATABASE failed. Some file names listed could not be created. Check related errors.. To continue, correct the problem, and then run SQL Server Setup again. Summary One or more products failed to install, see above for details Exit Code Returned: 29537 Also you will see below error message in error number 29537 windows event viewer under application Log:- CREATE FILE encountered operating system error 3(The system cannot find the path specified.) while attempting to open or create the physical file ‘F:\MSSQL.1\MSSQL\DATA\temp_MS_AgentSigningCertificate_database_log.LDF'. Resolution You will see below error when the default database data and log file path (mentioned under SQL Server instance properties -> Database Settings) does not exist at OS level. Possibly after installation some one have moved the data and log files to new location and have deleted the old folder structure, but forgot to update the default data and log file path. To resolve the issue, just update the default database data and log file path under SQL Server instance properties -> Database Settings and prove a valid path. Then try running your installer again. Subscribe CategoriesCategories Select Category Backup Configuration DAC Database Database Backup Database Mail Database Migration DBCC Error Resolution Firewall Installation KnowledgeBase Linked Server Maintenance Plan Monitoring Netezza Oracle Patching Performance Policy Based Management RDP Recovery Script Security Update SQL Scripts SQL Server SQL Server 2005 SQL Server 2008 SQL Server 2008 R2 SQL Server 2012 SQL Server Agent SQL Server Denali SQL Server Logins SQL Server Security SSAS SSIS SSRS Teradata Uncategorized Uninstall Unix / Linux Upgrade Viewpoint