Follow these steps:
- Check database details.
- Click Start on the server and type "ODBC", then choose ODBC Data Sources (x64).
- Navigate to the System DSN tab and double-click the ControlManager_DataBase with "64-bit" option.
- After double-clicking the option, the SQL Server will be shown.
- Clicking Next will show the authentication method selected.
- Click Next again to view the database selected for use.
- Test the connection.
- Click Start on the server and type "ODBC", then choose ODBC Data Sources (x64).
- Click Add.
- Select "SQL Server" and click Finish.
- Enter a Name and Description. For the Server, enter the SQL server FQDN or IP.
- Choose Windows account authentication or SQL authentication
- Click Next. A pop-up message will indicate if connection succeeded or failed.
- Update the database configuration. Please refer to the following articles.