Adding Microsoft SQL Server Connector Using Named Instance

  1. (Optional) If you know the Microsoft SQL Server instance name, perform the following:

    1. On the home page of the console, click Hosts.

    2. In the left pane, click Database Connectors.

      The Database Connectors page displays all the agents that have dbaudit package installed with the list of connectors.

    3. Click Add for the required agent.

    4. Specify the following:

      • Type: Select Microsoft SQL Sever from the dropdown menu.

      • Use with Instance: The Use with Instance checkbox is selected by default.

      • DB Proxy Port: Specify the port number on which the Privileged Account Manager accepts the connection from database clients to connect to a specific database server. Privileged Account Manager maps this port number to a specific database that has a specific DB address and DB Port.

      • DB Server Address: Specify the IP address or host name of the Microsoft SQL server.

      • Instance Name: Enter the Database Instance name and click Fetch Details.

        NOTE:The SQL Server Browser service should be enabled in the SQL Server for which the instances are being fetched.

      • DB Server Port: Specify the port number of the Microsoft SQL server.

      • Dynamic Port: Click the Dynamic Port checkbox if a dynamic port is set for the configured server.

      • Network Packet Size: The default value is 4096. You can enter any value within the range 512 to 16000.

        NOTE:You need to enter the same value as specified here in the client, while connecting through this connector.

  2. (Optional) If you do not know the Microsoft SQL Server instance name, you can search and fetch the instance as follows:

    1. On the home page of the console, click Hosts.

    2. In the left pane, click Database Connectors.

      The Database Connectors page displays all the agents that have dbaudit package installed with the list of connectors.

    3. Click Microsoft SQL Server Instances.The Microsoft SQL Server Instances window is displayed.

    4. Enter the host name or the IP for which you want to fetch the instances and click Fetch.

      NOTE:The SQL Server Browser service should be enabled in the SQL Server for which the instances are being fetched.

    5. Select the desired instance and click Ok.

      NOTE:Click the Dynamic Port checkbox if a dynamic port is set for the configured server.

    6. Click Save.