SQL server express 2005 - command line install

dcp002
dcp002 used Ask the Experts™
on
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?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Commented:
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

Commented:
Hope this helps:

http://www.devx.com/dbzone/Article/31648

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

Author

Commented:
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