Submit a ticketCall us

Looking to compare latest NPM features with previous versions of NPM?
The NPM new feature summary offers a comparison of new features and improvements offered with this release.

 

Home > Success Center > Database Performance Analyzer (DPA) > DPA 11.0 Administrator Guide > Create the repository database > Create an Azure SQL repository database

Create an Azure SQL repository database

Table of contents
No headers
Created by Anthony.Rinaldi, last modified by Anthony.Rinaldi on Feb 20, 2017

Views: 13 Votes: 0 Revisions: 2

After you install DPA and open it for the first time, you must create a repository database.

To use an Azure SQL instance as the repository database:

  1. On the Select Repository Database Instance Type page, click Azure SQL.
  2. Click Next.
  3. Complete the remaining wizard panels as described in the following table.
Panel Instructions
Enter Repository Connection Information

Before connecting, the database must exist in Azure and be empty.

  1. Enter the server name, port, and database name. You cannot use an IP address in the Server Name field.
  2. Select a method for creating or configuring the repository administrator.

To create a new account:

  1. Click Let DPA create and configure the user for me.
  2. Enter the credentials of an existing user with privileges to create the repository user and to grant the required permissions.

    This user must be a member of the db_owner role.

To specify an existing account, enter the user name and password of an existing account that DPA will use the interact with the repository.

Alternatively, you can use the provided script to create the repository user.

  1. Click Repository User Creation Script, and follow the on-screen instructions.
  2. Copy and run the edited script on your Azure SQL database.
  3. Provide this user as your repository administrator.
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:

  1. Click Let DPA create a new user.
  2. Enter a user name and password for the new account.

To specify an existing account:

  1. Click Let DPA configure an existing user.
  2. Enter the user name and password of an existing account.
Contact Information

Enter your name and email. SolarWinds 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.


Last modified
11:11, 20 Feb 2017

Tags

Classifications

Public