[Go] [tip] localhost vs. (local) in SQL Server connection strings

The main difference is that the connection protocol differs from the former (localhost) using the TCP protocol, which ("(local)") uses the Namedpipe protocol.

Sample code with SQL Server connection strings often use localhost and (local) interchangeably. They ' re different.

server= (local);D Atabase=dotnetnuke; Trusted_connection=true
Uses Named Pipes

Server=localhost;database=dotnetnuke; Trusted_connection=true
Uses a TCP port negotiated on port 1434 UDP, which defaults to 1433

Original link: http://weblogs.asp.net/jongalloway/432062

[Go] [tip] localhost vs. (local) in SQL Server connection strings