Here's a tough one!!!

[Bill Farrell]

Wrote a database in SQLServer2000 and an ASP.NET front end in C#.
Database access works just fine on my machine (WindowsXP Pro). But on
my client's machine (Microsoft Windows Server 2003) I get an error
saying: 'Login for NT AUTHORITY\NETWORK SERVICE fails'.

I've looked at (I think) every piece of literature Microsoft has put out
and I've tried a million things to fix this but nothing!!! I can't find
the key to either make the NT login work or change it. I'm wondering if
there is some compatibility issue between Visual Studio .NET 2003 and
Windows Server 2003? Has anyone out there run into this problem???
Thanks in advance

 

[Peter Bromberg [C# MVP]]

The error message tells all -- NT AUTHORITY\NETWORK SERVICE (apparently the
identity under which your deployed code is running) doesn't have login
permissions to the database.

The database is either set for Windows Authentication only (consider mixed
mode instead), or you can try using the web.config setting <identity
impersonate="true" userName="userThatCanLoginToDb" password="password" />

Hope that helps.
Peter