Connecting to an Installation

Accessing SQL Sentry Database Connection Management

When you start the SQL Sentry client, if you have more than one server in the SQL Sentry Database Connection Management menu, you are prompted to choose an installation to connect to. You may have more than one server in the SQL Sentry Database Connection Management menu if you have moved the SQL Sentry database to a new location.

SQL Sentry Database Connection Management

If you don't have more than one connection, you are brought directly to the SQL Sentry client when opening the application. To access the SQL Sentry Database Connection Management window from the client, select Connect to Installation from the File menu:

 select File Connect to Installation

Connection Properties

The SQL Sentry Database Connection Management menu controls the active SQL Sentry database for the locally installed SQL Sentry client.

SQL Sentry Database Connection Management window New Connection

Specifying the Server

Enter the name of the server to connect to in the field provided.

Specifying the Database Name

Specify the database name that the SQL Sentry database connects to.

Using the Integrated Windows Authentication

By default, this option is selected. To use the SQL Server authentication, select No, and then enter the SQL Server credentials. After connecting to the server, a new instance of the SQL Sentry client launches that connects to the specified alternate installation.

SQL Sentry Database Connection Management SQL Authentication

Advanced Properties

Select Show Advanced Properties to access advanced options.

SQL Sentry Database Connection Management Advanced Properties

Port Number

The default port is 1433 for SQL Server. See the Performance Analysis Required Ports article for additional information. See the Setting the Connection Properties topic from Microsoft Docs for more information on the portNumber property.

Packet Size

The default size is 4096 bytes. See the Configure the network packet size Server Configuration Option topic from Microsoft Docs for additional information on SQL Server network pack sizes.

Encrypt Network Traffic

The default value is No. Set to Yes to use encrypted connections between the SQL Sentry database server, SQL Sentry monitoring services, and SQL Sentry client.

Important:  To use this property, you must first complete the steps to Enable Encrypted Connections to the Database Engine as outlined in Microsoft Docs.

Trust Server Certificate

The default value is No. Set to Yes to trust SQL Server's SSL Certificate without additional validation. See the Setting the Connection Properties topic from Microsoft Docs for more information on the trustServerCertificate property.

Important:  If you choose to Encrypt Network Traffic, then this property must be set to Yes.

Multi Subnet

The default value is No. Set to Yes if this SQL Server connection uses a Multi Subnet Failover. See the Setting the Connection Properties topic from Microsoft Docs for more information on the multiSubnetFailover property.

Removing a Connection

Old servers may be removed through the Edit option on the SQL Sentry Database Connection Management window. To remove an old server from the SQL Sentry Database Connection Management menu so that you are no longer notified about it when opening the SQL Sentry client, complete the following steps:

1. Choose the server you would like to remove, select Edit, and then at the bottom of the screen select Remove Connection.

SQL Sentry Database Connection Management Edit connection
SQL Sentry Database Connection Management Remove Connection

2. Select OK to delete the desired connection. SQL Sentry Database Connection Management Delete Connection window