Depending on your environment or deployment considerations, it might be necessary to use a remote server running a supported version of Microsoft SQL Server to host the site database. It is possible to select a remote SQL Server instance to host the site database during Configuration Manager 2007 custom setup.

Note
This procedure is based on SQL Server 2005. For a list of supported SQL Server versions, see Configuration Manager Supported Configurations.

When selecting a remote SQL Server instance to host the site database during setup, the site database is created by setup using the default values for SQL Server.

Note
During Configuration Manager 2007 Setup, the Volume Shadow Copy Service (VSS) writer will be installed on the remote SQL Server computer to support the Backup Site Server maintenance task.

To install Configuration Manager using a remote SQL Server

  1. Add the machine account of the primary site server machine to the local Administrators group of the remote SQL Server computer. This is required to allow the site server to install and configure settings later.

  2. If the user account running Configuration Manager Setup does not have administrative rights on the remote SQL Server, you must assign the sysadmin SQL Server role to the user account in the SQL Server 2005 Management Studio console on the remote SQL Server computer.

  3. Start Configuration Manager Setup, and select to install Configuration Manager using custom settings.

  4. On the Configuration Manager Database Server page of the Configuration Manager Setup Wizard, enter the NetBIOS name of the remote SQL Server and instance name to host the site database, and the name for the site database to be created on that server by setup.

To verify that the site database was installed successfully

  1. Verify that Configuration Manager 2007 Setup completed successfully by reviewing the ConfigMgrSetup.log file located at the root of the system drive on the primary site server computer.

  2. In the SQL Server 2005 Management Studio console, verify that the site database was created successfully.

  3. In the SQL Server 2005 Management Studio console, verify that the following roles were created for the site database:

    • smsdbrole_MP

    • smsdbrole_SLP

    • smsdbrole_RP

    • smsdbrole_PSP

    • smsdbrole_DMP

    • smsdbrole_siteprovider

    • smsdbrole_siteserver

  4. Verify that the following SQL Server database roles for the site database have been assigned with the appropriate machine accounts:

    • smsdbrole_MP (if management point installation was selected)

    • smsdbrole_siteprovider (the site server or remote provider that was specified)

    • smsdbrole_siteserver (the primary site server computer)

See Also