I'm using this command to install SQL 2005 via the command prompt:

start /wait setup.exe /qb INSTALLSQLDIR=C:\Apps\SQL
INSTALLSQLSHAREDDIR=C:\Apps\SQL INSTALLSQLDATADIR=E:\Apps\SQL
INSTALLASDATADIR=C:\Apps\SQL SQLACCOUNT="NT AUTHORITY\SYSTEM" AGTACCOUNT="NT
AUTHORITY\SYSTEM" SQLBROWSERACCOUNT="NT AUTHORITY\SYSTEM"
ADDLOCAL=SQL_Engine,SQL_Data_Files,SQL_Replication ,SQL_FullText,Client_Components,Connectivity,SQL_T ools90,SQLXML,Tools_Legacy,SQL_WarehouseDevWorkben ch,SDK,SQL_Documentation,SQL_BooksOnline
INSTANCENAME=MSSQLSERVER SQLAUTOSTART=1

It works fine. But...some stuff gets installed to C:\Program Files\SQL...etc
even though I've tried to force all the bits to C:\Apps\SQL. Can I change
that so everything goes to C:\Apps\SQL? I've Googled it to death and can't
figure it out.

Also, I'm now going to update this command to also install Reporting
Services and Notication Services - think I'll have any new issues with stuff
not going to C:\Apps\SQL too?

(Note that while my key question is about controlling where SQL installs, if
you see any issues with my command that otherwise occur to you, I'm all
ears - I'm not at all a SQL expert!).

Thanks in advance...

Matt G

You can not change the fact that some stuff gets installed in the program
files directory. It's a sad state but that is the way it is for now. So you
have to ensure the C: drive has plenty of space to install SQL Server.

--
Andrew J. Kelly SQL MVP
Solid Quality Mentors


"Matt G" <mattg@mattg.net> wrote in message
news:%23wZrTTsCIHA.2004@TK2MSFTNGP06.phx.gbl...
> I'm using this command to install SQL 2005 via the command prompt:
>
> start /wait setup.exe /qb INSTALLSQLDIR=C:\Apps\SQL
> INSTALLSQLSHAREDDIR=C:\Apps\SQL INSTALLSQLDATADIR=E:\Apps\SQL
> INSTALLASDATADIR=C:\Apps\SQL SQLACCOUNT="NT AUTHORITY\SYSTEM"
> AGTACCOUNT="NT AUTHORITY\SYSTEM" SQLBROWSERACCOUNT="NT AUTHORITY\SYSTEM"
> ADDLOCAL=SQL_Engine,SQL_Data_Files,SQL_Replication ,SQL_FullText,Client_Components,Connectivity,SQL_T ools90,SQLXML,Tools_Legacy,SQL_WarehouseDevWorkben ch,SDK,SQL_Documentation,SQL_BooksOnline
> INSTANCENAME=MSSQLSERVER SQLAUTOSTART=1
>
> It works fine. But...some stuff gets installed to C:\Program
> Files\SQL...etc even though I've tried to force all the bits to
> C:\Apps\SQL. Can I change that so everything goes to C:\Apps\SQL? I've
> Googled it to death and can't figure it out.
>
> Also, I'm now going to update this command to also install Reporting
> Services and Notication Services - think I'll have any new issues with
> stuff not going to C:\Apps\SQL too?
>
> (Note that while my key question is about controlling where SQL installs,
> if you see any issues with my command that otherwise occur to you, I'm all
> ears - I'm not at all a SQL expert!).
>
> Thanks in advance...
>
> Matt G