Login failed for NT AUTHORITY\NETWORK SERVICE on a ASP.Net app

[Martin]

Hi,

Transferred a working ASP.Net app and database to a new machine and domain.

The app should be running as the local aspnet account (<processModel
userName="machine" password="AutoGenerate" ..... /> in machine.config)

The connection string is "packet size=4096;Integrated Security=SSPI;data
source=(local); persist security info=False;initial catalog=mydb"

the newmachine\ASPNET account has a login on SQL Server, and is a user on
mydb, and is in the group db_owner.

Can someone help me get this working?

Thanks
Martin

 

[Scott Allen]

Hi Martin:

Did you move from a 2000/XP machine to a 2003 machine? If so, ASP.NET
now runs under the BUILTIN\NETWORK SERVICE account instead of the
ASPNET account - you'll have to adjust the SQL login accordingly.

HTH,

 

[Martin]

Hi Scott,

Yes, that is exactly my scenario.

However, I have also made the group newmachine\IIS_WPG as a sql login, and
made it a user of mydb and put it in role db_owner.

newmachine\IIS_WPG has NETWORK SERVICE as member already.

Any other thoughts?

Much appreciated
Martin

 

[Martin]

Got it working by adding the NETWORK SERVICE account directly, not just as
part of the IIS_WPG group.

I wonder why that was necessary.

Thanks again
Martin

 

[Scott Allen]

Hi Martin:

Glad you have everything working.

I've added IIS_WPG as a SQL Login and have had things working, I'm not
sure what problem you ran into there.

 

[Martin]

Okay Scott,

I'll bare that in mind. Thanks alot for your help on this one.

Martin