title: SQL Server Express 2008 using (local) in connection string
body: <p>Is it possible to connect to a SQL Server Express 2008 database in ASP.NET with a server name of (local) like "server=(local);integrated security=SSPI;database=DBNAME"?</p>
  
  <p>I'm working with another developer on a project and it's getting annoying having to have 2 different version of web.config because he is using SQL Server 2008 and (local) works, but I can't seem to get it to work with SQL Server 2008 Express locally.</p>
  
  <p>The database is located on the same computer as the .NET code in case that matters.</p>
  
  <p>Thanks.</p>