How Set Up SMS to a Remote SQL Server

• Microsoft Systems Management Server versions 1.0, 1.1 and 1.2

SUMMARY

The following procedures will guide you through setting up a primary site server on a remote SQL Server.

MORE INFORMATION

Installing SQL Server

1. Install SQL Server on the Windows NT domain server. Follow SQL Server documentation.

   NOTE: All device names and passwords are case-sensitive.

2. Start SQL Administrator to create new devices for the remote Systems Management Server server.

3. Connect to the SQL Server server using the correct login name and password.

4. Choose the Devices icon.

5. From the Manage menu, choose Devices.

6. Choose Create.

7. Enter a logical name. SQL Administrator will generate a physical name with a *.DAT extension.

8. Select database for the type and use the size you think is correct for your site. The more computers to be inventoried, the larger the database should be. Use 5 KB to 10 KB per computer.

9. Choose OK.

10. Repeat steps 4 through 8 for LOG device creation changing the *.DAT

        file extensions to *.LOG. Do not change the device number for either
        the DB or the LOG device creation.
    

11. Do not create a new database. The Systems Management Server Setup

        program creates the Systems Management Server databases dynamically and
        attach the devices.
    

Installing Systems Management Server

1. Create a user account for the Systems Management Server Service Account. This account must be a member of either the Administrators local group or the Trusted Domains Administrators group. Ensure that this user can log on as a service.

   If the SQL database is located on a non-trusted domain, ensure that the user account you have created in your domain has the same username and password as the remote SQL Server.

   NOTE: If this procedure is not done properly, the following error message may appear:

         Hierarchy Manager is not responding to instructions.
   

2. Install Systems Management Server.

3. When asked about SQL Server, enter the computer name of the remote SQL Server server.

4. Fill out the rest of the screen until you get to the database name, device, and log device. Enter the device names that you chose on the remote SQL Server server. Systems Management Server Setup creates the database dynamically in order to attach to the manually-created devices.

5. Choose OK and proceed with the rest of the Systems Management Server installation.