I'm absolute newby to asp and web programming.
I have a well built-up web site using asp and a database (created in sql server).
In the first step this site logs on the user by asking for a UserID and a Password and cheking it in the database. If this logon succeds, the user can go on using the page otherwise he can't.
I would like to make this page usable, but it is only accessible through the internet, if I give administrator rights to the user IUSR. Otherwise the login fails (even is I give the correct userID and pwd), and I get the following error:
>HTTP 500.100 - Internal Server Error - ASP error
>Internet Information Services
>Technical Information (for support personnel)
>Microsoft VBScript runtime (0x800A01FB)
>An exception occurred: 'Session(...).AuthenticateUser'
>/MwareNet/LoggingUser/Authentication.asp, line 34
>Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 4.0)
I am using Windows 2000 server with IIS and SQL Server 2000 (enterprise edition).
I would like to know what should I do if I want IUSR to be able to log in and I dont want to give it administrator rights.
Thank you for your help in advance,