SQL Server Using Windows NT Authentation Connection String

Database Server:

SQL Server 2005

Server = tsohaephqdb001

Database = D01DMAINTPLAN

Process Id: Windows
NT Authentation

Login = asplog

Password = 123456

 

IIS Server:
  (separate machine from server)

ASP.NET Version 2.0.50727Anonymous Access = TrueUser Name = asplogPassword = 123456All other options = False 























(Generated by ASPRunner.Net)

web.config:

<?xml
version="1.0"?>

<configuration>


  <appSettings>




 
  <add key="LoginMethod"
value="WITHOUTLOGIN" />




    <add key="MenuFile"
value="menu.aspx" />




    <add key="StartPage"
value="menu.aspx" />


    <add key="LCID"
value="1033" />




    <add key="StringEmpty"
value="DBNull" />




  </appSettings>




  <connectionStrings>


  <add
name="Project1ConnectionString" connectionString="data
source=tsohaephqdb001;initial catalog=D01DMAINTPLAN;integrated
security=true;packet size=4096"


  
providerName="System.Data.SqlClient" />


 </connectionStrings>


  <system.web>




    <compilation debug="true"/>




    <authentication
mode="Windows"/>




  </system.web>

</configuration>



Generated Error when choosing a ASP
menu item that requires the connect string above.

Error:
                                                                           


Error description: Login
failed for user ''. The user is not associated
   

with
a trusted SQL Server connection

I’m
sure the SQL server and IIS server is configured correctly because I have
regular ASP running fine using DSN connect string.



I’m
new to ASP.Net and not sure about the Web.conf connect string.