Hello,
I am deploying an asp.net 2.0 website with a sql server 2005 back end. It is an intranet application and my investigation so far has led me to believe that the best security option is windows authentication for both the web app and database. However any web page involving the database gives a 401 error. What am I missing?
Details:
-the database is configured to allow both sql and windows authentication
-the database and web application reside on separate servers
-it has been confirmed that users can access both the database server and windows server
-the web app is configured in IIS as a virtual directory with only integrated windows authentication selected.
-in the web config we have specified authentication < ...
Go to the complete details ...