• How to correctly set the access rights on your IIS server

Dear user
90 % of our support questions are raised because of missing access rights for the database in our applications. We have made this white paper to help you set up your IIS 4.0/IIS 5.0 servers correctly when you install our applications.

First some background info.

When a user access your homepage he is normally not authenticated, so what the IIS server does is to use the rights form a anonymous user who is automatically created on your IIS server.

When you are using a access database in a web application this anonymous user doesn't by default have the access rights to change or update the database so you will get an error like this:

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query.

/gallery/default.asp, line 231

So what you will need to do is to set Read/Write and modify rights on the directory where the database is located for the anonymous user.

First step is to find out the name of this anonymous user:

1 . Open IIS using MCC (Microsoft Management Console) and select your web.

1 .First select your web


2 . Right click on the web and select 'Properties'.

3 . Select the 'Directory security' tab and click 'Edit...'.



4 . Click the 'Edit...' button under Anonymous access.


5 . Write down the username. ( in this case IUSR_ATAF_IIS)


6 . Click cancel twice and select home directory. Write down the location of your website on the server.



7 . On the web server open windows explorer and navigate to the directory of your web application



 

8 . Click right mouse button and select 'Properties'. After this select 'Security'.
Then select the anonymous user (in this case IUSR_ATAF_IIS) and click permission
Modify/Read/Write. You can leave the other default values.

9 . Click 'Ok' and then you are finished.

Congratulations! You have now properly set up the permissions for you IIS server, and your database applications should work correctly.