Skip to main content

Azure Dedicated SQL Pool

Following are the options specific to Azure Dedicated SQL Pool

  • Connection Name: Enter a unique Connection Name. This fields accepts letters, numbers, and symbols.

  • Server Name: Enter the name of the Azure Dedicated SQL Pool Server or select from the list of available IPs.

  • Group/IP Range: Select the Group/IP range from the drop-down. For details on how to create and assign an IP range, please refer to the PK Protect Installation Guide.

  • Authentication Method: The following authentication methods are available for SQL Server:  

    • SQL Server: Authenticates the connection using SQL Server Username and Password.

    • Active Directory Integrated: Authenticates the connection using the details provided at the time of Azure Active Directory setup.
            

  • Port Number: Enter the Port Number for establishing a connection. You can also edit the port number later, if required.

  • Database Name: Enter the name of the database.

  • Username: Enter the database username.

  • Password: Enter the database password.

  • Use Connection String: It specifies the information about the data source and the means of connecting to it. Check the Use Connection String checkbox and provide the connection string. Use this option if you want to authenticate the connection using a connection string instead of username and password.

  • Connection Attribute: Select the attribute name from the Connection Attribute drop-down. This functionality allows you to add tags to the created connection.

  • Databases/Schemas: Enter the name of the database in the Filter By Schema/DB Name text box and press enter. This lists down the existing databases for the selected connection. Check the Include System Schema/DB Name checkbox if you want to include the system schema in the panel. It will list down the available databases/schemas for the connection.


    Check the checkbox next to the name of the databases/schemas that you want to add as the target databases/schemas. The checked databases or schemas will be appeared in the Target Databases/Schemas panel.

To proceed further for remaining steps, refer Step 2 in Azure Detection.

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.