Submit a ticketCall us

Don’t fall victim to a ransomware attack
Backups are helpful, but sometimes that’s not enough to protect your business against ransomware. At our live webcast we will discuss how to protect against ransomware attacks with SolarWinds® Patch Manager and how to leverage log data to detect ransomware. Register now for our live webcast.

Home > Success Center > Database Performance Analyzer (DPA) > Register SQL Server instances as monitored databases using a Windows Computer Account

Register SQL Server instances as monitored databases using a Windows Computer Account

Created by Anthony.Rinaldi_ret, last modified by MindTouch on Jun 23, 2016

Views: 102 Votes: 1 Revisions: 7

Overview

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:

  • Adjust the DPA service on the computer running SolarWinds DPA.
  • Modify the SQL Server permission of the monitored servers.
  • Reconfigure SolarWinds DPA.

 

Note: You can only use Computer Account authentication if the SolarWinds DPA server has a Windows operating system.

Environment

  • DPA 10.1 and later

Windows configuration

Modify the SolarWinds DPA IgnitePI service to run under the Computer Account.

  1. From a command prompt, enter services.msc.
  2. Right-click the Ignite PI Server service, and select Properties.
  3. On the Log On tab, click This Account and enter the credentials for the Windows Computer Account.

 

Grant the Computer Account full control to the DPA installation directory and subdirectories.

  1. Open a File Explorer window, and browse to the DPA installation directory. The default is:

    C:\Program Files\SolarWinds\DPA

  2. Right-click the folder, and click Properties.
  3. Click the Security tab, and click Edit.
  4. Click Add, enter the account, and then click OK.
  5. Under Permissions, select Full control, and then click OK.

SQL Server configuration

Add following user or login to the SQL Server:

DOMAIN\<DPA_MACHINE_NAME>$

 

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

DPA configuration

Registering new SQL Server instances using a Windows Computer Account is only supported by the Mass Registration feature.

Register a new instance and repoint using a Windows Computer Account

  1. Click Options > Administration.
  2. Under Configuration, click Advanced Options.
  3. Select the Support Options check box.
  4. Click the SQL_SERVER_COMP_ACC_AUTH_ENABLED system option.
  5. Select True from the New Value list, and click Update.

Register new SQL Server databases using Mass Registration

  1. Click Options.
  2. Under Database Instance, click Mass Registration.
  3. From the Database Type list, select SQL Server.
  4. From the Authentication Type list, select Computer Account.
  5. Follow the on-screen How to instructions.
  6. Follow the steps in the Mass Database Instance Registration Wizard.

Update a SQL Server that was already registered

  1. Click Options.
  2. Under Database Instances, click Update Connection Info.
  3. Select a SQL Server instance, and click Next.
  4. Next to Authentication type, select Computer Account.
  5. Select the Domain check box, and enter the information.
  6. Click Next to finish the wizard.

Advanced: Use SQL statements to mass update a SQL Server that was already registered

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: DOMAIN\

 

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'

Troubleshooting

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:

<DPA_INSTALLATION_DIR>\iwc\jre\bin\ntlmauth.dll

 

The location of the Java version used by DPA is in the following file:

<DPA_INSTALLATION_DIR>\iwc\tomcat\ignite_config\java_loc.txt

Last modified
19:17, 22 Jun 2016

Tags

Classifications

Public