SQL 2005 standerd edition | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

SQL 2005 standerd edition

Hi All, I am trying to install SQL 2005 standerd edition on one of my server with domain account as start up account . I tried nearly 10 times but always ended up with the error message: The SQL Server service failed to start. For more imformation see SQL Server books online topics, "How to: SQL Server 2005 setup log files" and "starting SQL Server Manually" At last I tried to install by using local account as start up account, it worked. I don’t want to use local system account as start up. Why installation failing if we use domain account? Please some one help me in this regard. Thanks in advance… Regards,
Anil Kumar
Is the domain account you are using also a member of the local administrator’s account on the server you are installing on? It has to be. —————————–
Brad M. McGehee, SQL Server MVP
Yes. Before starting the installation I have added this domain account to local admin group. Thanks Anil Kumar
What did you see in your setup log files…any errors… Mohammed U.
Here are the errors in the log.<br /><br />******* Got commit request from MSI *******<br />Complete: InstallDTSAction at: 2007/0/9 10:35:31, returned true<br />Running: InstallNSAction.10 at: 2007/0/9 10:35:31<br />Installing: sqlxml4 on target: xxx<br />Error: MsiOpenDatabase failed with 110<br />Failed to install package<br />The installation source for this product is not available. Verify that the source exists and that you can access it.<br />Error: MsiOpenDatabase failed with 110 for MSI {A188FCCF-E929-494D-B1F1-4313E02ACD52}<br />Setting package return code to: 1612<br />Complete: InstallNSAction.10 at: 2007/0/9 10:35:33, returned false<br />Error: Action "InstallNSAction.10" failed during execution. Error information reported during run:<br />Target collection includes the local machine.<br />Invoking installPackage() on local machine.<br />Running: InstallSqlAction at: 2007/0/9 10:35:33<br />Installing: sql on target: xxx<br />Failed to install package<br />Fatal error during installation.<br />Setting package return code to: 29503<br />Complete: InstallSqlAction at: 2007/0/9 10:37:6, returned false<br />Error: Action "InstallSqlAction" failed during execution. Error information reported during run:<br />Target collection includes the local machine.<br />Invoking installPackage() on local machine.<br />Error: Action "InstallToolsAction.10" failed during execution. Error information reported during run:<br />Action: "InstallToolsAction.10" will be marked as failed due to the following condition:<br />Condition "Package "10" either passed when it was last installed, or it has not been executed yet" returned false. Condition context: <br />Prereq package will be failed due to the previous installation attempt returning: 1612<br />Installation of package: "sqlxml4" failed due to a precondition.<br />Action "InstallNSAction" will return false due to the following preconditions: <br />Condition "Action: InstallNSAction.10 has finished and failed." returned true.<br />Installation of package: "ns" failed due to a precondition.<br />Step "InstallNSAction" was not able to run.<br />Action "InstallToolsAction" will return false due to the following preconditions: <br />Condition "Action: InstallToolsAction.10 has finished and failed." returned true.<br />Installation of package: "tools" failed due to a precondition.<br />Step "InstallToolsAction" was not able to run.<br />Skipped: InstallASAction<br />Skipped: Action "InstallASAction" was not run. Information reported during analysis:<br />No install request found for package: "as", install will be skipped as a result.<br />Error: Action "InstallRSAction" failed during execution. Error information reported during run:<br />Action: "InstallRSAction" will be marked as failed due to the following condition:<br />Condition "The SQL Server instance that hosts rs is installed." returned false. Condition context: <br />rs will be failed due to the hosting instance of SQL Server failing to install.<br />Installation of package: "rs" failed due to a precondition.<br />Skipped: RepairForBackwardsCompatRedistAction<br />Skipped: Action "RepairForBackwardsCompatRedistAction" was not run. Information reported during analysis:<br />Action: "RepairForBackwardsCompatRedistAction" will be skipped due to the following condition:<br />Condition "sql was successfully upgraded." returned false. Condition context: <br />sql failed to upgrade and so the uninstall of the upgraded product will not occur.<br />Error: Action "UninstallForMSDE2000Action" failed during execution. Error information reported during run:<br />Action: "UninstallForMSDE2000Action" will be marked as failed due to the following condition:<br />Condition "sql was successfully upgraded." returned false. Condition context: <br />sql failed to upgrade and so the uninstall of the upgraded product will not occur.<br />Installation of package: "patchMSDE2000" failed due to a precondition.<br />Error: Action "UninstallForSQLAction" failed during execution. Error information reported during run:<br />Action: "UninstallForSQLAction" will be marked as failed due to the following condition:<br />Condition "sql was successfully upgraded." returned false. Condition context: <br />sql failed to upgrade and so the uninstall of the upgraded product will not occur.<br />Installation of package: "patchLibertySql" failed due to a precondition.<br />Error: Action "UninstallForRS2000Action" failed during execution. Error information reported during run:<br />Action: "UninstallForRS2000Action" will be marked as failed due to the following condition:<br />Condition "rs was successfully upgraded." returned false. Condition context: <br />rs failed to upgrade and so the uninstall of the upgraded product will not occur.<br />Installation of package: "patchRS2000" failed due to a precondition.<br />Running: ReportChainingResults at: 2007/0/9 10:37:7<br />Error: Action "ReportChainingResults" threw an exception during execution.<br />One or more packages failed to install. Refer to logs for error details. : 1067<br /> Error Code: 0x8007042b (1067)<br />Windows Error Text: The process terminated unexpectedly. Source File Name: sqlchainingsqlchainingactions.cpp<br />Compiler Timestamp: Thu Sep 1 22:23:05 2005<br /> Function Name: sqls::ReportChainingResults:<img src=’/community/emoticons/emotion-4.gif’ alt=’:p‘ />erform<br />Source Line Number: 3097<br /><br />—- Context ———————————————–<br />sqls::HostSetupPackageInstallerSynch:<img src=’/community/emoticons/emotion-4.gif’ alt=’:p‘ />reInstall<br />Marking package: "patchRS2000" as failed due to cancel code received from cancel source: 29539<br />sqls<br />Error: Failed to add file :"C:program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_xxx_.NET Framework 2.0.log" to cab file : "C:program FilesMicrosoft SQL Server90Setup BootstrapLOGSqlSetup0001.cab" Error Code : 2<br />Error: Failed to add file :"C:program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_xxx_.NET Framework 2.0 LangPack.log" to cab file : "C:program FilesMicrosoft SQL Server90Setup BootstrapLOGSqlSetup0001.cab" Error Code : 2<br />Error: Failed to add file :"C:program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_xxx_.NET Framework Upgrade Advisor.log" to cab file : "C:program FilesMicrosoft SQ L Server90Setup BootstrapLOGSqlSetup0001.cab" Error Code : 2<br />Error: Failed to add file :"C:program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_xxx_.NET Framework Upgrade Advisor LangPack.log" to cab file : "C:program FilesMicrosoft SQL Server90Setup BootstrapLOGSqlSetup0001.cab" Error Code : 2<br />Error: Failed to add file :"C:program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_xxx_.NET Framework Windows Installer.log" to cab file : "C:program FilesMicrosoft SQL Server90Setup BootstrapLOGSqlSetup0001.cab" Error Code : 2<br />Error: Failed to add file :"C:program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_xxx_.NET Framework Windows Installer LangPack.log" to cab file : "C:program FilesMicrosoft SQL Server90Setup BootstrapLOGSqlSetup0001.cab" Error Code : 2<br />Running: UploadDrWatsonLogAction at: 2007/0/9 11:1:3<br />Message pump returning: 1067
It could be your installation files issue… Did you copy the installation files locally for installation?
Error: MsiOpenDatabase failed with 110 for MSI
Above error could be it can’t access or open the file… Mohammed U.
If you have any anti-virus or anti-spyware tools, let them stop until the SQL is installed. Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing.
]]>