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?
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.