For database connection issues, you can use the test.udl file to confirm the database credentials used to access the SQL database from the ePO - On-prem server.
You must know the SQL database server name and database name on the server. Use the https://<localhost>:8443/core/config-auth URL to learn this information.
If you are troubleshooting ePO - On-prem database connection problems, you might see this error in the orion.log file:
Login failed for user ''. The user is not associated with a trusted SQL Server connection
For details about product features, usage, and best practices, click ? or Help.
On the ePO - On-prem server, create a file named
test.udl.Double-click the file you created to display the Data Link Properties user interface.
Click the Provider tab, select Microsoft OLE DB Provider for SQL Server from the OLE DB Provider(s) list, then click Next.
On the Connection tab, configure this information:
Select or enter a server name — Type the server name, instance, and port using this format:
<servername>\<instancename>,<port>.If no named database instance is used, use this format:
<servername>,<port>Enter information to log on to the server — Type the SQL database credentials.
Select the database on the server — Type the database name.
Click Test Connection.
The Microsoft Data Link dialog box should display Test connection succeeded.