Hi,
I have tried to do a new SQL 2005 install via an unattended install script. I have tried both a modified version of the template.ini and just from the command line.
The installation starts and successfully installs some of the components I have selected through the ADDLOCAL option. Unfortunately it then reports an execution error and exits.
The errors I find in the install log files are as follows...
SQLSetup..._Core.log:
Error: Action "LaunchLocalBootstrapAction" threw an exception during execution. Error information reported during run:
"C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\setup.exe" finished and returned: 1603
Aborting queue processing as nested installer has completed
Message pump returning: 1603
SQLSetup..._Core(Local).log
Running: InstallToolsAction.10 at: 2006/1/14 14:58:11
Error: Action "InstallToolsAction.10" threw an exception during execution. Error information reported during run:
Target collection includes the local machine.
Fatal Exception caught while installing package: "10"
Error Code: 0x80070002 (2)
Windows Error Text: The system cannot find the file specified.
Source File Name: sqlchaining\sqlprereqpackagemutator.cpp
Compiler Timestamp: Tue Aug 9 01:14:20 2005
Function Name: sqls::SqlPreReqPackageMutator::modifyRequest
Source Line Number: 196
---- Context -----------------------------------------------
sqls::InstallPackageAction::perform
WinException caught while installing package. : 1603
Error Code: 0x80070643 (1603)
Windows Error Text: Fatal error during installation.
Source File Name: packageengine\installpackageaction.cpp
Compiler Timestamp: Fri Jul 1 01:28:25 2005
Function Name: sqls::InstallPackageAction::perform
Source Line Number: 167
---- Context -----------------------------------------------
sqls::InstallPackageAction::perform
Error: Failed to add file :"C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0003_Server_.NET Framework 2.0.log" to cab file : "C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\SqlSetup0003.cab" Error Code : 2
Error: Failed to add file :"C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0003_Server_.NET Framework 2.0 LangPack.log" to cab file : "C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\SqlSetup0003.cab" Error Code : 2
Error: Failed to add file :"C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0003_Server_.NET Framework Upgrade Advisor.log" to cab file : "C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\SqlSetup0003.cab" Error Code : 2
Error: Failed to add file :"C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0003_Server_.NET Framework Upgrade Advisor LangPack.log" to cab file : "C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\SqlSetup0003.cab" Error Code : 2
Error: Failed to add file :"C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0003_Server_.NET Framework Windows Installer.log" to cab file : "C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\SqlSetup0003.cab" Error Code : 2
Error: Failed to add file :"C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0003_Server_.NET Framework Windows Installer LangPack.log" to cab file : "C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\SqlSetup0003.cab" Error Code : 2
Running: UploadDrWatsonLogAction at: 2006/1/14 14:58:39
Message pump returning: 1603
The files reported as failing to be added to the .cab file do not exist, although .Net 2.0 was successfully installed. All other log files do not seem to contain errors.
When calling the install from the command line I am running the following
setup /qb ADDLOCAL=SQL_Engine,SQL_Data_Files,SQL_Replication,SQL_FullText,SQL_DTS,Client_Components,Connectivity,SQL_Tools90,SDK,SQLXML,SQL_WarehouseDevWorkbench,Tools_Legacy,SQL_Documentation,SQL_BooksOnline INSTALLSQLDIR="D:\NTApps\Microsoft SQL Server\" INSTALLSQLSHAREDDIR="D:\NTApps\Microsoft SQL Server\" INSTALLSQLDATADIR="F:\Data\" INSTANCENAME=MSSQLSERVER SQLBROWSERACCOUNT="Domain\SQL" SQLBROWSERPASSWORD="******" SQLACCOUNT="Domain\SQL" SQLPASSWORD=="******" AGTACCOUNT="Domain\SQL" AGTPASSWORD="******" SQLBROWSERAUTOSTART=1 SQLAUTOSTART=1 AGTAUTOSTART=1 SECURITYMODE=SQL SAPWD="*******" SQLCOLLATION=SQL_Latin1_General_Cp1_CI_AI
Note: I've changed the usernames and passwords
Any ideas anyone
Unattended installation woes
Milis
The same problem occurs during my interactive installation immediately after the CD2 request. The server components on cluster look fine (even switches are OK).
The end of Summary looks like:
Machine : 2K3-LH-DBNS1
Product : Microsoft SQL Server Setup Support Files (English)
Product Version : 9.00.1399.06
Install : Failed
Error Number : 3221225477
for the other components install succedes.
I even tried to avoid installation of client components but with no success (it always asks for CD2).
Any idea or suggestion
Claudio1060
Arik
Kent,
This issue occurs because setup is looking for more media.
If you are installing from CDs, the CDs have to be local. Using a network share for CDs won't work because setup.exe doesn't recognize that it is installing from a CD and won't ask for the Media switch when installing Tools.
It's okay to share a DVD since all of the information is on the one disc and setup can find it.
So you've got some options -
1/ Install with the CDs in the local drive (swapping as necessary)
2/ Copy both CDs to a share, using the name of the cds as the folder to copy in to
3/ Burn a DVD - put CD1 in the a “Servers“ folder, and CD2 in a “Tools“ folder.
4/ Install everything except tools from the Shared CD1, then install just Tools from Shared CD2.
Good luck.
-Jeffrey
Damiaan
I workarounded the problem !
I installed server side services only (no client tools, no sample db Northwind).
Setup didn't ask for CD2 and everything went right.
Maybe this is because I used MSDN CDs that have to be used separately.
who knows.....
Anyway thank you all
Steve Hills
I used the web download setup from a big file. This is a redistributable setup for SQL Server Express 2005. No problems, no CD, I assume it downloads what it needs if the machine lacks something.
I installed it by double-clicking on it and followed the prompts. Then I installed the x64 version of the Administrators management tool CPT.
Unattended backups are a tad trickier though.