Question about configuring sql server 2005

When configuring a SQL 2005 Server in preparation for connectivity to a SharePoint Server 2007 farm, Microsoft recommends that Local and Remote Connections use both TCP/I开发者_如何学PythonP and named pipes. Where is this setting found?

Start > All Programs > Microsoft SQL Server 2005 > Configuration Tools > SQL Server Configuration Manager

Or simply

C:\WINDOWS\system32\mmc.exe /32 "C:\WINDOWS\system32\SQLServerManager.msc"

Once there, in SQL Server 2005 Network Configuration you'll see the relevant options and with the right mouse button a contextual menu will let you choose the pertinent option.

There is probably some sp_configure parameter to enable this, but I haven't found that out.

In the Surface Area Configuration Tool ("C:\Program Files\Microsoft SQL Server\90\Shared\SqlSAC.exe") it can be done as well, via "for Services and Connections" > Database Engine > Remote Connections