Login Failed for User "NT Authority/Network Service"

Giganews Newsgroups
Subject: Login Failed for User "NT Authority/Network Service"
Posted by:  GregoryJ
Date: Tue, 30 Dec 2008

I just deployed my C#.Net 2008 3.5 Web Application to IIS 6.0. My site is
loading just fine with the exception of any pages that connect to my SQL
Server database. On my development machine my application connects with no
problem. I am using Windows Authentication. I don't believe my
ConnectionString would require any changes, but I'm not sure. I've pasted my
ConnectionString below:

<add name="myDataBase" connectionString="Data Source=SQLTEST;Initial
Catalog=DatabaseName;Integrated Security=SSPI"/>

Why would my web site not connect to my SQL Server database with the
connectionString that works on my development box? I don't want to use SQL
Authentication, so any help on how I can get my IIS 6.0 web application to
work as my development application does would be very helpful.

FYI: I am looking into Application Pools as a book of mine suggests
something along that line.