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) > DPA 11.0 Installation Guide > Create the repository database > Create an Azure SQL Database repository database

Create an Azure SQL Database repository database

Updated: July 6, 2017

After you install DPA, you must create the repository database, which holds the performance data that DPA collects. Use this procedure to create an Azure SQL Database repository database.

To create a different type of repository database, see Create a SQL Server repository database, Create an Oracle repository database, or Create a MySQL repository database.

Before you start

Before you run the Repository wizard:

File:Success_Center/Reusable_content_-_InfoDev/DPA/DPA_Installation_Guide/DPA_Installation_Guide/0060-Unistall_DPA/checkbox.gif Create a database in Azure SQL Database.
File:Success_Center/Reusable_content_-_InfoDev/DPA/DPA_Installation_Guide/DPA_Installation_Guide/0060-Unistall_DPA/checkbox.gif The SolarWinds DPA server connects to the repository through a TCP/IP connection. Make sure that connection is not blocked by a firewall.

Run the wizard

  1. To open DPA, click the button on the installation confirmation dialog, or enter one of the following URLs in a web browser:

    • http:<serverName_or_IP>:8123
    • https:<serverName_or_IP>:8124

    The Repository wizard opens automatically if the repository database has not been created.

  2. Click Create New Repository.
  3. Complete the remaining wizard panels as described in the following table.

Panel Instructions
Select Repository Database Instance Type Select Azure SQL as the database type.
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
17:17, 7 Jul 2017

Tags

Classifications

Public