Export (0) Print
Expand All

How to Install Configuration Manager Using a Remote SQL Server

Updated: December 1, 2008

Applies To: System Center Configuration Manager 2007, System Center Configuration Manager 2007 R2, System Center Configuration Manager 2007 R3, System Center Configuration Manager 2007 SP1, System Center Configuration Manager 2007 SP2

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.

noteNote
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.

noteNote
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

For additional information, see Configuration Manager 2007 Information and Support.
To contact the documentation team, email SMSdocs@microsoft.com.
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft