[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...

Category: SQL | Other Posts: View all posts by this blogger | Report as irrelevant | View bloggers stats | Views: 1 | Hits: 0

News Categories

.NET | Agile | Ajax | Architecture | ASP.NET | BizTalk | C# | Certification | Data | DataGrid | DataSet | Debugger | DotNetNuke | Events | GridView | IIS | Indigo | JavaScript | Mobile | Mono | Patterns and Practices | Performance | Podcast | Refactor | Regex | Security | Sharepoint | Silverlight | Smart Client Applications | Software | SQL | VB.NET | Visual Studio | W3 | WCF | WinFx | WPF | WSE | XAML | XLinq | XML | XSD