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

主要区别在于连接协议不同,前者(localhost)使用TCP协议,后者(“(local)”)使用NamedPipe协议。

 

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

Server=(local);Database=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

原文链接:http://weblogs.asp.net/jongalloway/432062

posted @ 2016-03-22 11:41  排骨虾  阅读(259)  评论(0编辑  收藏  举报