Installation where SQL Server uses another drive for data files

Sep 11, 2007 at 10:04 PM
Edited Sep 11, 2007 at 10:04 PM
Just thought I'd post this, in case someone else runs into it.

The documentation mentions a "single box deployment of WSS 3.0 in domain mode". What it should have said was "a single drive installation".

The SQL Script starterkitdb.sql has a hard coded path to the SQL Server Data and log files on the "C" drive. If you're implementing this in a more "normal" server environment, you should edit this to point to the location of your actual data files folder (e.g. D:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data).

Mike Sharp