The network protocols that can be used to communicate with
SQL Server 2008 from another computer are not all enabled for SQL Server during
installation.
To connect from a particular client computer, you might need to
enable the desired protocol. The Shared Memory protocol is enabled by default
on all installations, but because it can be used to connect to the Database
Engine only from a client application on the same computer, its usefulness is
limited.
TCP/IP connectivity to SQL Server 2008 is disabled for new
installations of the Developer, Evaluation, and SQL Express editions. OLE DB
applications connecting with MDAC 2.8 cannot connect to the default instance on
a local server using “.”, “(local)”, or (<blank>) as the server name. To
resolve this, supply the server name or enable TCP/IP on the server.
Connections to local named instances are not affected, nor are connections
using the SQL Native Client. Installations in which a previous installation of
SQL Server is present might not be affected.
