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