Using a Remote SQL Server to Host the Site Database
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
Configuration Manager 2007 primary sites must constantly communicate with the Microsoft SQL Server hosting the site database. Typically, performance is better if the Configuration Manager 2007 site server and the site database are installed on the same server. However, if the intervening network connection is a high-availability, high-bandwidth network connection you might be able to install SQL Server on a remote server from the Configuration Manager 2007 site server. You might also consider installing a second network adapter in both the site server and the computer running SQL Server and then dedicating this second card for communications between the site server and the computer running SQL Server.
When using a remote SQL Server to host the site database, the site database server must be located in the same domain as the site server and SMS Provider computer.
When using a remote SQL Server to host the site database, TCP/IP network protocol communication is required for SQL Server network connections to support Kerberos authentication. The named pipes communication protocol is not required but can be used to troubleshoot Kerberos authentication issues. When using SQL Server 2005 to host the site database, the network protocol communication settings are configured in SQL Server Configuration Manager under SQL Server 2005 Network Configuration. For a list of supported SQL Server versions, see Configuration Manager Supported Configurations.
For additional information, see Configuration Manager 2007 Information and Support.
To contact the documentation team, email SMSdocs@microsoft.com.