Prev   Next

Back to the top of the FAQ

Q. I am trying to authenticate with the Software and IIS against a database on another machine on my LAN. It doesn't appear to work. What do I need to do?
A. If you are using an Access database (mdb) on another machine, or an SQL Server on another machine using "Integrated" security, then you will need to tell the Software to impersonate a user that has access to that database.

Go to Options/ODBC, check the "Impersonate user when accessing database" checkbox, and enter the username and password of the user that has permission to access the remote database.

If you are using SQL server with Standard or Mixed security, and you have the username and password in the DSN, you will not experience this problem.

Back to the top of the FAQ

Prev   Next