Microsoft KB Archive/843068

= The SMS 2003 Setup program always creates the database and log files as Sms.db and Sms.log when you use the unattended installation method in SMS 2003 =

Article ID: 843068

Article Last Modified on 9/13/2006

-

APPLIES TO


 * Microsoft Systems Management Server 2003

-





SYMPTOMS
When you use the unattended installation method to script the installation of a Microsoft Systems Management Server (SMS) 2003 primary site, and you specify the SMS database file name and the SMS transaction log file name in the .ini file, these file name settings may be ignored. Instead, the SMS 2003 Setup program creates the SMS database file name as Sms.db and creates the SMS transaction log file name as Sms.log.



CAUSE
This problem occurs if you use Microsoft SQL Server version 7.0 or Microsoft SQL Server 2000. The DatabaseDevice= entry and the LogDevice= entry are not utilized when you use SQL Server 7.0 or SQL Server 2000. By default, the database file name is Sms.db and the SMS transaction log file name is Sms.log.

Note Because the SMS 2003 Setup program uses the same file names for every unattended installation, we recommend that you do not try to install multiple site databases on a single SQL Server-based server.



RESOLUTION
To resolve this problem, install SMS 2003 Service Pack 2 or a later service pack. For more information about how to obtain SMS 2003 Service Pack 2, visit the following Microsoft Web site:

http://www.microsoft.com/smserver/evaluation/2003/sp2.mspx



STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the &quot;Applies to&quot; section. This problem was first corrected in Systems Management Server 2003 Service Pack 1.

