asp.net/iis/sql help

[Charlie Ting]

Hi.

Let me tell you my domain environment. It's NT 4.0 domain with a
Windows 2000 member server running as ASP.NET/IIS/MS SQL 2000, all in one
box, and it worked fine. Recently, we bought a new box with Windows 2003
standard version and trying to move ASP.NET and IIS to this box. However;
we're getting "Login failed for user 'NT Authority\Anonymous Logon'" error
when we access the ASP.NET page. I believe it has something to do with
moving the asp.net/iis to a different box and leave SQL in the old box. I've
done some research and there're some possibilities that have caused this:

1. It would require Active Directory domain environment when you move
asp.net/iis to a different box and authenticates with the SQL
server on the old box?

2. ASPNET account locally on both boxes need to be matched?

3. reconfigure the Machine.config and Web.config in the asp.net?


Can anyone help me on this with the details?


Thanks

 

[Lionel LASKE]

My guess is that you need to change your anonymous account on the virtual
directory.
You must use a domain account to ensure it would be visible from both SQL
Server and IIS/.NET.
The default ASPNET account is defined locally so it's only visible from your
IIS/ASP.NET server.

Lionel.

 

[Patrick Olurotimi Ige]

Are u getting the
Login failed for user 'NT Authority\Anonymous Logon'" error
when trying to access SQlServer?
What u can do is just Add ASPNET acct to the SQL Server.
And make sure IIS has this account too
Hope it helps.
Patrick