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

[theintrepidfox]

Hi Charlie

Not exactly sure why you are getting this error but it sounds it's more
a problem of the IIS configuration than SQL Server. You might want to
repost in an IIS group.

If you place a very simple index.aspx (a blank webform) in the root of
your website on the Windows 2003 box and try calling it like
http://localhost/myapp/index.aspx - Do you get the same error? In this
case it's a pure IIS problem. Check the properties of your web
application root and make sure that anonymous logon is enabled.

Also check that you have the right settings in web.config.

<!-- AUTHENTICATION
This section sets the authentication policies of the application.
Possible modes are "Windows", "Forms", "Passport" and "None"

"None" No authentication is performed.
"Windows" IIS performs authentication (Basic, Digest, or Integrated
Windows) according to its settings for the application. Anonymous
access must be disabled in IIS.
"Forms" You provide a custom form (Web page) for users to enter their
credentials, and then you authenticate them in your application. A user
credential token is stored in a cookie.
"Passport" Authentication is performed via a centralized
authentication service provided
by Microsoft that offers a single logon and core profile services for
member sites.
-->

Let me know the result.

M