Allright, this is the situation.
We have this ASP application running on IIS 5. It accesses an SQL Server
2000 through a couples of views that gets the data from the databases.
Everything works fine.
Configuring the exactly same application under IIS 6, we get a pop-up box
asking for user/password to access our IIS 6 webserver. No matter what we
type, it results on a 401.1 authorization error. This error only happens when
a specific ASP page is loaded, which accesses a view from the SQL Server
which contains fields from database A and database B. It is the only view
that merges fields from two different databases, and if we remove the field
that belongs to database B, everything works.
In IIS 5 the page loads normally, getting the data from both databases with
no problems.
Even though it seems like an IIS issue, we've checked the authorizations on
the SQL Server databases and also on IIS, and all seems fine.
We've also checked the IIS and SQL log files, the Microsoft IIS
Authentication Tool, the IIS metabase, the Microsoft Knowledge Base and still
no clues on what may be causing this.
The IIS 5 is just for test purposes, since all other applications run nicely
under IIS 6.
Our environment:
Windows NT Domain
SQL Server 2000 running on a Windows 2000 Server
IIS 6 running on a Windows 2003 Web Edition
IIS 6 configured to use Windows Integrated Authentication
IIS 6 metabase file configured to use NTLM
Any help would be greatly appreciated, and if more information is needed,
please let me know.
Best regards,
Konrad Sauer
FAQ
Search
Profile
Private Messages
Log in
