asp with windows authentication

[ilang02]

hi,
i am using an asp page (not .net) which connects to a sql server with sql authentication.

i need to change the authentication mode to windows authentication.
i managed to do all the changes in .net applications but i didnt figured out how to make it when i use asp page.

the OS is windows server 2003

thx for any help

ilan

[jhardman]

open IIS, (start-> run-> "inetmgr") browse through web sites to the page or folder where the user is going to access the db (or earlier if there is a logical login point)
right click on the page or folder, select "properties". go to the "directory security" tab and select "edit" under "anonymous access and authentication control". The default is "Anonymous access" - IIS will try to authenticate as IUSR, and that's probably not what you want to use. You need to uncheck anonymous access and check integrated windows authentication.

This will prompt the user for a windows user ID and password when he gets to this point, and when trying to connect to the db IIS will pass these credentials.

Let me know if this helps.

Jared

[ilang02]

hi Jared
this worked for me only if used the asp page in localhost. when i tried to use the page from a client i got an error "login failed for user null"


the iis server and the sql server are on the same domain.

besides the passoword alert keeps popping in the client and the user dont know the passoword. is there any way to make the password alert will not be shown?

ilan

[ilang02]

i found the answer to both problems
for the problem that i couldnt get to the pages from my client i had to put a domanin account in the annonymous access and set it to true

i had to uncheck the integrated security.
so by that no password alert was shown

thx all