Submit a ticketCall us

Putting Your Logs Where They Belong with the New SolarWinds Log Manager for Orion

The new SolarWinds® Log Manager for Orion® finally puts your log data right where it belongs, in the heart of your Orion console. Gain insight into the performance of your infrastructure by monitoring your logs in a unified console allowing you to see a wealth of information about the health and performance of your network and servers.

Reserve a Seat for Wednesday May 23rd 11am CDT | Reserve a Seat for Tuesday May 22nd 10:30am GMT | Reserve a Seat for Tuesday May 22nd 1pm SGT / 3pm AEST

Home > Success Center > Database Performance Analyzer (DPA) > DPA 11.1 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

Tags

Classifications

Public