Unable to connect to instance after fresh install or upgrade to SQL Server plugin to 12.2.0.12 (4043097)

Chatee ahora con Soporte

Obtener ayuda en vivo
Completar registro

Iniciar sesión

Solicitar precios

Comuníquese con Ventas

Regresar

Comentarios enviados

¿Este artículo solucionó su problema?

Seleccionar calificación

Título

Unable to connect to instance after fresh install or upgrade to SQL Server plugin to 12.2.0.12
Descripción

Unable to connect to instance after fresh install or upgrade to SQL Server plugin to 12.2.0.12

This issue does not occur with the previous versions of the plugin.
Causa

In 12.2.0.12 SQL Server plugin, a new parameter field SQL Server ODBC Driver was added to allow access to the SQL instance using ODBC drivers. This request was to facilitate TLS 1.2 connection which does not work with the older drivers. By default, this field has the value "ODBC Driver 17 for SQL Server". This error occurs when the client machine does not have this driver.
Resolución

WORKAROUND1

Install the ODBC Driver 17 for SQL Server.

Note: For SQL Server 2017 on Windows, Microsoft recommends that you use the default driver, Microsoft ODBC Driver 17 for SQL Server.

WORKAROUND2

Check the ODBC Data Sources (drivers tab) and verify which ODBC Driver is available.

For example:

ODBC Driver 13.1 for SQL Server

ODBC Driver 13 for SQL Server

ODBC Driver 11 for SQL Server

SQL Server

Note: For more information on the distinction between each of the different ODBC driver versions, please refer to Microsoft.

Next left-click on the Plug-in for SQL Server, select Configure, scroll to "SQL Server ODBC Driver" and update the field accordingly.

Please note that in previous versions of the plug-in it would always and only use the driver named 'SQL Server'. If you use 'SQL Server' the plug-in will also work in the same manner like the previous versions. Note that 'SQL Server' driver does not support latest versions of TLS, but it would work in your environment if older versions of TLS are installed.

Comentarios enviados

¿Este artículo solucionó su problema?

Seleccionar calificación

Solicitar un artículo KB

Contenido recomendado

Producto(s):: NetVault
13.1.2, 13.1.1, 13.1, 13.0.3, 13.0.2, 13.0.1, 13.0, 12.4, 12.3, 12.2

Tema(s):: Troubleshooting, Configuration

Historial del artículo:: Creado el: 8/22/2019
Última actualización: 7/27/2023

Buscar todos los artículos

Seleccione su producto:

Con el fin de ofrecerle un mejor servicio, complete el campo Motivo del chat:

Soluciones recomendadas para su problema

Unable to connect to instance after fresh install or upgrade to SQL Server plugin to 12.2.0.12 (4043097)

Título

Descripción

Causa

Resolución

Leave a Comment