George,

Where is this .iss file located? I can't seem to locate it either on the CD, in the MSDE directory, or *anywhere* on any of my drives.

BTW, I'm installing the MSDE that comes on the VFP 7 installation CD. I think that's MSDE 2000. Since I've done nothing with it since the install, I can easily blow it away and install it again as many times as necessary to get this done right.

Thanks,
Evan

>>How do I move the default database(s) and tell MSDE where to look for them?
>
>Evan,
>
>The following information is true for the the SQL Server 7.0 version of MSDE. I think it's the same for the SQL Serer 2000 version.
>
>You may have to uninstall MSDE and start over to make sure the default databases (such as MASTER) are relocated.
>
>If you are truly installing MSDE (as opposed to the Developer version of SQL Server) then the key to configuring the installation is the unattend.iss file. Unattend.iss is a text file. Look for the keyword:
>
>[SetupTypeSQL-0]
>
>Under that keyword you will find the following settings:
>
>szDir=C:\MSSQL7
>szDataDir=C:\MSSQL7
>
>You can change these settings to control where SQL Server and the data are installed.
>
>There is more you can control with the unattend.iss file than I've listed here so it's worth your time to read more about this file.
>
>HTH