Restore of SQL Server Database Fails

Symptom

When TLS 1.0 and 1.1 are disabled on a machine where the SQL Server is installed with a legacy driver, the SQL Server connection fails. Hence, the restore of the SQL Server database fails, and the following error occurs:

“Unable to connect to SQL Server. If TLS 1.2 is enabled, make sure supported ODBC version is installed on the machine.”

Note: When TLS 1.2 is enabled on a machine where the SQL Server is installed, make sure the supported ODBC driver version is installed on the same machine.

The supported ODBC driver versions for the corresponding Windows OS versions are as follows:

Drivers/SQL ODBC Driver Versions

ODBC 11

ODBC 13

ODBC 17

ODBC 18

Windows Server 2008 R2

Yes

Yes

No

No

Windows Server 2012

Yes

Yes

Yes

No

Windows Server 2012 R2

No

Yes

Yes

Yes

Windows Server 2016

No

Yes

Yes

Yes

Windows Server 2019

No

Yes

Yes

Yes

Windows Server 2022

No

Yes

Yes

Yes

Solution

To resolve this issue, follow these steps:

  1. Go to the machine where the SQL Server is installed.
  2. Navigate to Control Panel > System and Security > Administrative Tools > ODBC Data Sources, and then confirm that the supported ODBC driver is installed.
  3. If the supported ODBC driver is not installed, download, and install the supported ODBC driver on the SQL Server, and then perform restore. To download, click here.
  • Note: If you want to establish a connection with the SQL Server using a specific ODBC driver version, do the following:
    1. Open the Registry Editor on a machine where the SQL Server is installed, and then navigate to the following registry key:
    2. HKEY_LOCAL_MACHINE\SOFTWARE\Arcserve\Unified Data Protection\Engine\VssWrap
    3. Right-click the VssWrap folder, and the click New > String Value.
    4. Double-click the string, and then add the following name in the Value_name field:
    5. DriverNameToConnectSQLServer
    6. Navigate to the following location, double-click the ODBC driver string that you want to use it to establish a connection with the SQL Server, and then copy the Value name:
    7. HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI
    8. Go to the VssWrap folder again, double-click the newly added string, and then paste the value name that you have copied into the Value data field.
    9. Using this driver, Arcserve UDP connects with the SQL Server.