Failed to connect to Microsoft SQL Server with Encrypted Connection Enabled (4370303)

Chatee ahora con Soporte

Regresar

Comentarios enviados

¿Este artículo solucionó su problema?

Seleccionar calificación

Título

Failed to connect to Microsoft SQL Server with Encrypted Connection Enabled
Descripción

When attempting to connect to a Microsoft SQL Server instance with encrypted connection enabled, an error “The certificate chain was issued by an authority that is not trusted” results and unable to connect.
Causa

Default configuration will not connect to SQL Server instance with encrypted connection enabled.
Resolución
The “Encrypt connection” needs to be checked and an additional parameter “TrustServerCertificate” set to “True” needs to be added to the connection properties.
Perform the steps below to make the required changes:
1. Right-click on SQL Server connection | Properties.
2. Under the Login tab, enter the required information and ‘check’ the Encrypt connection.
3. Under the Advanced tab, add the parameters “TrustServerCertificate” to “True” and hit enter.
4. Save the connection information and connect again to the instance.

Comentarios enviados

¿Este artículo solucionó su problema?

Seleccionar calificación

Contenido recomendado

Producto(s):: Toad Data Point Subscription
Current; Toad Data Studio Subscription
Current; Toad Data Point
6.3, 6.2.3, 6.1.2, 6.1; Toad for SQL Server
8.1, 8.0, 7.4.1; Toad for SQL Server Subscription
Current; Toad Data Studio
2.0, 1.1, 1.0

Historial del artículo:: Creado el: 2/20/2023
Última actualización: 7/16/2025

Título