[tip] localhost vs. (local) in SQL Server connection strings
Posted by: JonGalloway.ToString(),
on 02 Dec 2005 |
View original | Bookmarked: 0 time(s)
Sample code with SQL Server connection strings often use localhost and (local) interchangeably. They're different. Server=(local);Database=DotNetNuke;Trusted_Connection=TrueUses named pipesServer=localhost;Database=DotNetNuke;Trusted_Connection=TrueUses a TCP port negotiated on port 1434 udp, which defaults to 1433 There are many differences between TCP and Named Pipe connection, but if you're on localhost you're mostly concerned with simple access. The default ASPNET account generally has...