I have been trying to get the web site running by using the instructions in the readme file. I followed the instructions (SQL Server 2005 - Non-Express Edition Setup). I have one windows server 2003 configured for IIS and another windows server 2003 running sql express 2005. As a sanity check I'am able to run (ODBC) as a User DSN from both machines to test the database connection. and all works fine until step 5.

I can not get the connection to work from the web.config file.
I get the following error...

Login failed for user'<Server_name\User_name>' The user is not associated with a trusted sql server connection.

<connectionStrings>
      <remove name="LocalSqlServer"/>
      <add name="LocalSqlServer" connectionString="Data Source=<Server_Name\SQLEXPRESS;Initial Catalog=<Database_Name;uid=Server_Name\User_name;p wd=Password" providerName="System.Data.SqlClient"/>
      <!--
      <add name="LocalSqlServer" connectionString="Data Source=.\SQLExpress;Integrated Security=True;User Instance=True;AttachDBFilename=|DataDirectory|aspn etdb.mdf" providerName="System.Data.SqlClient"/>
      <add name="LocalSqlServer" connectionString="Data Source=.\SQL05;Initial Catalog=TheBeerHouse_Remote;User ID=sa;Password=ok" providerName="System.Data.SqlClient"/>
      -->
   </connectionStrings>

Help...

Frankly, I'm a little confused. Are you trying to login using Windows authentication or SQL authentication. If it is SQL authentication (as I suspect, then you don't need to specify "server_name\username" for the uid, just the username. SQL Server doesn't care about the server name.

I'am using Windows Authentication only, not SQL or mixed mode