[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: 1680 | Hits: 200

Similar Posts

  • Visual Studio Add-In vs. Integration Package Part 1 more
  • Script to Inventory Print Servers more
  • Bundle SQL script with build process using MSBuild more
  • Scale Cheaply - Sharding more
  • IIS Admin Pack: Database Manager more
  • Repairing SQL 2005 Business Intelligence Studio after uninstalling VS2005 more
  • Visual Studio Tools for Office Power Tools v1.0! more
  • DevConnections Las Vegas Almost Sold Out!! more
  • Choosing LINQ to Entities vs Entity SQL vs. EntityClient more
  • How to debug a stored procedure in your Sql Server 2005 more

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