SQL server express 2005 - command line install

dcp002 used Ask the Experts™
SQL Server express 2005.
I want to install from batch file as part of an application set-up, either from a CD or USB stick.

I have created a settings .INI file, and the following works, but ONLY IF I specify the drive letter and full path of the .INI file:

start /WAIT setup.exe /ADDLOCAL=ALL /qn /settings Y:\install\sqlexpresstemplate.ini

(I was working from the directory Y:\install)

If I use
start /WAIT setup.exe /ADDLOCAL=ALL /qn /settings sqlexpresstemplate.ini

then it looks for the file C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\sqlexpresstemplate.ini      which of course does not exist.

Any ideas how to use a .INI file from the CD when I do not know what drive letter the CD drive will be?
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Copy it to %temp% with usual copy command and give %temp% based path to installer command line.
Raja Jegan RSQL Server DBA & Architect, EE Solution Guide
Awarded 2009
Distinguished Expert 2018

Hope this helps:


Make sure you copy the installation contents to local machine before performing this operation.


Simple and effective solution thanks.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial