While debugging .NET Web Applications interfaced to SQL Server 2000 SP4 there are some things to check due to structural changes to IIS 6.0 in Windows Server 2003.

IIS 6.0 server user has changed to [NT AUTHORITY\NETWORK SERVICE] (on the Italian version is [NT AUTHORITY\SERVIZIO DI RETE]) and when accessing SQL Server, this one stop us telling that the user cannot login (obvious ).

Open the Enterprise manager, go to Query Analyzer and execute the following Stored Procedure:

exec sp_grantlogin [NT AUTHORITY\NETWORK SERVICE]

Now your IIS user can login successfully according to the assigned permission.

Popularity: unranked