SQL 2005 Login With Windows Accounts

Hello,

I'm having a problem using Windows Accounts to login to a SQL 2005 Server.

Here is my setup. The SQL server and web server are separate machines. I'm also not developing directly on the web server.

SQL Server 
- Windows 2003 Server
- SQL 2005
- Set to use SQL and Windows Authentication

Web Server
- Windows 2003 Server
- IIS 6.0
   - Anonymous Authentication is disabled
   - Integrated Windows Authentication is enabled

Application web.config:



<?xml version="1.0"?>

<configuration xmlns="http://schemas.microsoft.com/.NetConfiguration/v2.0">
<appSettings>
   <add key="ETR_Environment" value="Dev"/>
</appSettings>

<connectionStrings>
   <add connectionString="Data Source=sql-dev-server, 1179;Initial Catalog=ENV_ETR;Integrated Security=SSPI;" name="ETR_Dev"/>
   <add connectionString="" name="ETR_Prod"/>
</connectionStrings>

<system.web>
   <compilation debug="true" strict="false" explicit="true"/>
   <pages>
      <namespaces>
         <clear/>
         <add namespace="System"/>
         <add namespace="System.Collections"/>
         <add namespace="System.Collections.Specialized"/>
         <add namespace="System.Configuration"/>
         <add namespace="System.Text"/>
         <add namespace="System.Text.RegularExpressions"/>
         <add namespace="System.Web"/>
         <add namespace="System.Web.Caching"/>
         <add namespace="System.Web.SessionState"/>
         <add namespace="System.Web.Security"/>
         <add namespace="System.Web.Profile"/>
         <add namespace="System.Web.UI"/>
         <add namespace="System.Web.UI.WebControls"/>
         <add namespace="System.Web.UI.WebControls.WebParts"/>
         <add namespace="System.Web.UI.HtmlControls"/>
      </namespaces>
   </pages>

  <authentication mode="Windows"></authentication>
  <customErrors mode="Off"></customErrors>
  <authorization>
     <allow users="XXXWilliam.Klein"/>
     <deny users="*"/>
  </authorization>
</system.web>
</configuration>

The reason why I want to use the windows login to connect to the database is the application needs to keep track of who did what when entering and updating data but still keep them using there windows login accounts. So using a generic account will not work.

What keeps happening is I keep getting this error: Login failed for user 'NT AUTHORITYANONYMOUS LOGON'. When trying to connect the database. I've tried this on two web servers on another I get something slightly different: Login failed for user 'XXXWeb-Server$'.

Anybody able to give me any suggestions on how to fix this?