Modifying the Installation

If you have installed SQL Server on a different drive than the C drive, or you are using SQL Server 6.0 with Service Pack 3, you must modify the SMS.SQL script file. Use the SQL Query Tool to make your edits.

    To edit the SQL drive letter

1. Open the SMS.SQL script file.
2. Find the two DISK INIT statements.
3. Change PHYSNAME to match your drive letter and SQL directory structure. Do not change the .DAT file name.

   For example, change:

   PHYSNAME =  'C:\MSSQL\DATA\SMSDATA.DAT'

   to:

   PHYSNAME =  '<your SQL location>\DATA\SMSDATA.DAT'
   

4. If necessary, find the LOAD DATABASE statement (the last line in the script) and change the path of the SMSDMP.DAT file.

    To Use SQL Server 6.0 with Service Pack 3

If you are using SQL Server 6.0 with Service Pack 3 installed, you can load the demonstration database but you will need to make some changes to the SMS.SQL script and follow a different set of directions:

1. Copy the files SMSDMP.DAT and SMS.SQL from the Platform SDK or MSDN CD-ROM, or from http://www.microsoft.com/smsmgmt/demodata.htm, to the directory C:\SQL60.
2. Start ISQL/w (the SQL Query tool).
3. Log in to SQL Server. Use the sa account if you are prompted to do so (this will not usually be necessary).
4. Open the C:\SQL60\SMS.SQL script file.
5. Find the two DISK INIT statements.
6. Change the PHYSNAME path to match your SQL Server directory structure. By default this is 'C:\SQL60\DATA\…'
7. Find the LOAD DATABASE statement (the last line in the script).
8. Change the path to match your directory structure. By default this should be 'C:\SQL60\SMSDMP.DAT'.
9. To run the script, choose Execute from the Query menu.
10. The script takes about five minutes to complete and updates you on its progress. When the script results state "100 percent loaded" in the Query Results window, the process is complete. (You may need to scroll down the window to see this message.) You can then close ISQL/w.