Skip to main content

SQL Server

Following are the options specific to the SQL Server:

  1. Single Instance: Provide the following details.

    1. Connection Name: Enter a unique connection name. This fields accepts letters, numbers, and symbols.

    2. SSL: For an additional layer of security, check the SSL (Secure Socket Layer) checkbox.

    3. Server Name: Enter the name of the SQL Server or select from the list of available IPs. You can also search for the hostnames and IP addresses of databases by Find DBMS.

    4. IP Address: Enter the IP Address for the connection.

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

    6. Database Name: Enter the name of the database.

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

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

      2. Windows Impersonation: Authenticates the connection using the Windows Impersonation Username and Password.

      3. Windows: Authenticates the connection based on the connection to the local IP address.

        *Note: To make connection with GCP SQL Server using Windows Authentication method, specify true for integratedSecurity parameter in the connection string.

      4. Username: Enter the database username.

      5. Password: Enter the database password.

      6. 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 to authenticate the connection using a connection string instead of through username and password.

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

      8. Databases/Schemas: Enter the name of the database in the Filter By Schema/DB Name text box. Check the Include System Schema/DB Name checkbox to include the required schemas and databases and click Fetch Metadata. It will list down the available databases/schemas for the connection.


        Check the databases/schemas name that you want to add as the target databases/schemas. The checked databases or schemas will appear in the Target Databases/Schemas panel.

  2. Multiple Instances: To connect to multiple instances on an SQL Server, perform the following steps:

    1. Check the radio button for Multiple Instances below the Connection Type.

    2. Enter the name of the SQL Server instance or click Browse Instances to view all the instances available on the SQL Server.

    3. Select the required instances from the Available Instances panel and click Add. The default authentication method is Windows.

    4. The selected server instances will be added under the Selected Instances panel.

    5. To change the authentication method for an instance, select the instance and click on the pen icon under the Action field. Enter the following details in the Edit Connection Details pop up:

      1. Location: Select either On-Premises or Cloud.

      2. Connection Name: Enter unique connection name. This fields accepts letters, numbers, and symbols.

      3. Server Name: This field is auto populated.

      4. IP Address: Enter the IP Address for the connection.

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

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

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

        2. Windows Impersonation: Authenticates the connection using the Windows Impersonation Username and Password.

        3. Windows: Authenticates the connection based on the connection to the local IP address.

          *Note: The prerequisites for creating a connection to multiple instances on the SQL Server, are:

          1. The sqlcmd utility must be installed.

          2. Sqlcmd-L command must be executed to get the list of the available instances.

          3. The Server name is auto populated when the detection IDP fetches the name of the server where the command sqlcmd-L is executed.

            Refer to Appendix H: Configure Multiple SQL Server Instances in PK Protect for more details.

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

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

JavaScript errors detected

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

If this problem persists, please contact our support.