Unable to find where to set "Database Authentication"

Question

Hi,
I've used dbFront for a long time, and I've bought the pro version to be able to connect another DB using different users.
It seems that the documentation reported here (https://dbfront.com/connectionaccess) is not up-to-date, as those screens are unavailable on actual 1.4.0.0664 version. I can't find the place where I can enable the Database Authentication on the single connection, while the old connection seems to work smoothly. I've found something interesting in the ConnectionConfig of the old one, like

 <AuthType>DatabaseAuthentication</AuthType>
  <AuthDatabase>XXXXXXX</AuthDatabase>
  <AuthFunction>XXXXXXX</AuthFunction>
  <AdminUserList>
    <string>administrator</string>
  </AdminUserList>
  <UpdateUserList />
  <ReadOnlyUserList />
  <DeniedUserList />

that are not present in the ConnectionConfig of the new one. But even adding those data to the new connection, I'm unable to authenticate with a user present in the new DB (the SP is present in the new DB and AuthDatabase has been changed concordly).
Can you please help me please? Thanks!

Comments

You should not need to modify the config files directly.  To connect another database you would create a new connection in addition to your previous connection.   You could then set the new connection to use a different authentication.

Answer 1

A possible source of confusion is that there are two levels / types of database authentication.

1) The first is the database authentication for the database connection. That is described in this documentation which explains how to add database connections. https://dbfront.com/databaseconnection

2) The second is the option to allow uses of an existing database connection to be authenticated by a stored procedure. That is described here: https://dbfront.com/databaseauthentication

I need to review the documentation to make the difference clearer.

Comments

Hi Anthony,
thanks. But even the documentation shown here (https://dbfront.com/databaseauthentication) is not aligned with the actual version, because the "Enable Database Authentication" screen seems not to be available in the UI. How do I get there? Is the "Access" button? If positive, when I click on it, it gets an error "Can't load users, The network path was not found.". Even activating the debug-level I'm not able to understand the issue:

2025-01-21 20:47:12.888    Error: Process Error, The network path was not found. System.Exception: Can't load users ---> System.Exception: Can't load everyone (prep) ---> System.Runtime.InteropServices.COMException: The network path was not found.
<snip></snip>
2025-01-21 20:47:10.591    Can't access domain forest
2025-01-21 20:47:10.591    Warning: User Directory [EC2AMAZ-XXXXXX] is unknown

Any help here is really appreciated!
Thanks!

---

That screen/tab is enabled when the authentication is set to "Database" in the first screen.  See: https://dbfront.com/connectionaccess