Create a SQL Server repository database
After you install DPA, you must create the repository database, which holds the performance data that DPA collects. Use this procedure to create a SQL Server repository database.
If one or more monitored database instances is created with multi-byte support, the repository database should also be created with multi-byte support.
Before you start
Before you run the Repository wizard:
|Make sure the repository database server meets the system requirements.|
|Install a supported version of SQL Server on the database server.|
|If you run the wizard from a different computer (not the server where DPA was installed), make sure the required firewall port is open. By default, port 8124 must be open.|
|The DPA server connects to the repository through a TCP/IP connection. Make sure that connection is not blocked by a firewall.|
|Make sure you have credentials to a login with SYSADMIN privileges for the SQL Server database instance.|
Run the wizard
To open DPA, enter the following URL in a web browser, where
yourServeris the hostname or IP address of the DPA server:
If the repository database has not been created, the Repository wizard opens automatically.
- Click Create New Repository.
Complete the remaining wizard panels as described in the following table.
|Select Repository Database Instance Type||Select Microsoft SQL Server as the database type.|
|Enter Repository Connection Information||
|Enter Repository Login||
DPA can create the repository administrator account, or you can specify an existing account. To ensure that the account has the required permissions, SolarWinds recommends creating a new account.
To create a new account:
To specify an existing account:
You can also authenticate using a Windows Computer Account.
For SQL Server authentication, only the user name is required. Do not specify a domain.
|Specify Database for the Repository||
Create a new database, or select an existing, empty database if one is available:
Enter your name and email. DPA sends database performance reports to this address.
|Summary||Review the information and click Create Repository.|
|Finished Repository Creation||
After the repository has been created, click Register Database Instance to start registering instances, or close the wizard and register instances later.