In SolarWinds DPA, you can register and monitor a SQL Server database using a Windows Computer Account.
To use this feature, you must make the following configuration changes:
Note: You can only use Computer Account authentication if the SolarWinds DPA server has a Windows operating system.
Modify the SolarWinds DPA IgnitePI service to run under the Computer Account.
Grant the Computer Account full control to the DPA installation directory and subdirectories.
Add following user or login to the SQL Server:
<DPA_MACHINE_NAME> is the hostname of the SolarWinds DPA server. This must be done on all monitored SQL Servers.
To create the user, run the following SQL statements on the SQL Server:
CREATE LOGIN [DOMAIN\<DPA_MACHINE_NAME>$] FROM WINDOWS WITH DEFAULT_DATABASE=[master]
ALTER SERVER ROLE sysadmin ADD MEMBER DOMAIN\<DPA_MACHINE_NAME>$
For more information about required permissions, see this knowledge base article.
Registering new SQL Server instances using a Windows Computer Account is only supported by the Mass Registration feature.
Connect to the repository database with a SQL tool, and execute the following command:
UPDATE COND SET AUTH_SCHEMA='SSO', PASSWORD=NULL, USERNAME='<USERNAME>' WHERE DB_TYPE='SQL Server' AND ID IN (...)
<USERNAME> must be in the following format:
In the parenthesis (...), insert IDs from the COND table that belong to the database you are changing.
The following SQL statement can help you choose the correct ID:
SELECT ID, NAME, USERNAME, CONN_HOST FROM COND WHERE DB_TYPE='SQL Server'
There are two causes of the following error: Could not load library required for Computer Authentication.
Is your DPA installation running on a Linux server?
This feature is only available for DPA running on a Windows operating system.
Is your DPA installation using a Java Runtime Environment (JRE) other than the embedded version?
You must copy the following file to the
bin folder of the Java version used to run DPA:
The location of the Java version used by DPA is in the following file: