Is there a difference between (local), '.' and localhost?

sql-server connection-string
Chris Sutton picture Chris Sutton · Oct 1, 2008 · Viewed 9.2k times · Source

I've used all three of these when making local programmatic connections to databases. Is there any real difference between them?

Answer

Sergio Acosta picture Sergio Acosta · Oct 1, 2008

The final result is the same. The difference is:

  • 'localhost' resolves at the TCP/IP level and is equivalent to the IP address 127.0.0.1
  • Depending on the application "(local)" could be just an alias for 'localhost'. In SQLServer, '(local)' and '.' mean that the connection will be made using the named pipes (shared memory) protocol within the same machine (doesn't need to go through the TCP/IP stack).

That's the theory. In practice, I don't think there is substantial difference in performance or features if you use either one of them.

Related questions

How can I set an SQL Server connection string?

I'm developing a simple C# application, and I'd like to know this: When I connect my application to SQL Server on my PC, I know the connection string (server name, password, etc.), but when I connect it to another PC, …

Read More
What is the difference between Integrated Security = True and Integrated Security = SSPI?

I have two apps that use Integrated Security. One assigns Integrated Security = true in the connection string, and the other sets Integrated Security = SSPI. What is the difference between SSPI and true in the context of Integrated Security?

Read More
How to find SQL Server running port?

Yes I read this How to find the port for MS SQL Server 2008? no luck. telnet 1433 returns connection failed, so I must specify other port. I tried to use netstat -abn but I don't see sqlservr.exe or something similar …

Read More