SQL Server

For SQL Server:

New Server Connection panel for SQL Server

Providing the basic connection information

1. In the Host field, provide the hostname for the server.

2. In the Port field, provide the port to connect through.

3. From the SSL/TLS dropdown list, select whether to enable or require Secure Socket Layer (SSL) or Transport Layer Security (TLS).

Configuring the authentication

Selecting the authentication method

From the Authentication dropdown list, select the type of authentication to use.

The options are:

• Username & Password. This is the default.

• Azure AD Service Principal. To use this option, you must first configure the available Azure service principals for the workspace.

Providing a username and password

For username and password authentication:

1. In the Username field, provide the username to use to make the connection.

2. In the Password field, provide the password.

Providing an Azure service principal

For Azure AD service principal authentication:

1. In the Username field, provide the username for the Microsoft Entra user to use to make the connection. The user must be mapped to the service principal that you select.

2. From the Azure Service Principal dropdown, select the service principal to use.