Backup of enterprise applications (Microsoft stack, IBM Db2, MongoDB, Oracle, PostgreSQL, SAP)
Post Reply
doktornotor
Expert
Posts: 107
Liked: 35 times
Joined: Mar 07, 2018 12:57 pm
Contact:

VBR 12 - MSSQL plugin broken when having ODBC 18 driver installed

Post by doktornotor »

On a Windows Server 2022 with MSSQL 2019 which happens to have Microsoft ODBC Driver 18 for SQL Server installed, the configured DB backup fails.

SQL agent job logs this on MSSQL server:

Code: Select all

Executed as user: NT Service\SQLSERVERAGENT. [Microsoft][ODBC Driver 18 for SQL Server]SSL Provider: The target principal name is incorrect.  Process Exit Code -1.  The step failed.
This is from the plugin log:

Code: Select all

[01.03.2023 14:10:00.886] <  3444> mssqlplug| Found ODBC driver: ODBC Driver 18 for SQL Server
[01.03.2023 14:10:00.886] <  3444> mssqlplug| Found Native driver: SQL Server Native Client 11.0
[01.03.2023 14:10:00.886] <  3444> mssqlplug| Found driver: SQL Server
[01.03.2023 14:10:00.886] <  3444> mssqlplug| Using ODBC driver: ODBC Driver 18 for SQL Server...
[01.03.2023 14:10:00.902] <  4104> mssqlreco| CMessageSenderQueue: sending thread ok.
[01.03.2023 14:10:00.902] <  3444> mssqlreco| ERR |MSSQL manager failed
[01.03.2023 14:10:00.902] <  3444> mssqlreco| >>  |[Microsoft][ODBC Driver 18 for SQL Server]SSL Provider: The target principal name is incorrect.

[01.03.2023 14:10:00.902] <  3444> mssqlreco| >>  |
[01.03.2023 14:10:00.902] <  3444> mssqlreco| >>  |[Microsoft][ODBC Driver 18 for SQL Server]Client unable to establish connection
[01.03.2023 14:10:00.902] <  3444> mssqlreco| >>  |Failed to initialize connection to MSSQL server.
[01.03.2023 14:10:00.902] <  3444> mssqlreco| >>  |Failed to connect to MSSQL server. Driver: ODBC Driver 18 for SQL Server.
[01.03.2023 14:10:00.902] <  3444> mssqlreco| >>  |Failed to create ODBC connection.
[01.03.2023 14:10:00.902] <  3444> mssqlreco| >>  |--tr:Failed to start recovery manager.
[01.03.2023 14:10:00.902] <  3444> mssqlreco| >>  |An exception was thrown from thread [3444].
The SQL agent backup starts immediately working as soon as the ODBC 18 driver is uninstalled on the MSSQL server.
Gostev
Chief Product Officer
Posts: 31964
Liked: 7435 times
Joined: Jan 01, 2006 1:01 am
Location: Baar, Switzerland
Contact:

Re: VBR 12 - MSSQL plugin broken when having ODBC 18 driver installed

Post by Gostev » 1 person likes this post

Thank you for letting us know, we will document this as a limitation.
markhsc
Novice
Posts: 3
Liked: never
Joined: Mar 13, 2024 8:54 pm
Full Name: Mark Davidson
Contact:

Re: VBR 12 - MSSQL plugin broken when having ODBC 18 driver installed

Post by markhsc »

@Gostev,
We had to update the ODBC Driver on a SQL server due to another product requiring it.
When will Veeam update the MSSQL plugin to allow ODBC 18 to be used for SQL back up using the product?
This is a logical progression for the product to be used for sql backup and recovery.
Andreas Neufert
VP, Product Management
Posts: 7145
Liked: 1532 times
Joined: May 04, 2011 8:36 am
Full Name: Andreas Neufert
Location: Germany
Contact:

Re: VBR 12 - MSSQL plugin broken when having ODBC 18 driver installed

Post by Andreas Neufert »

Hi Mark please let me check on the actual status. Thanks.
Andreas Neufert
VP, Product Management
Posts: 7145
Liked: 1532 times
Joined: May 04, 2011 8:36 am
Full Name: Andreas Neufert
Location: Germany
Contact:

Re: VBR 12 - MSSQL plugin broken when having ODBC 18 driver installed

Post by Andreas Neufert »

From Microsoft documentation:
"The Microsoft ODBC Driver 18 for SQL Server can be installed side by side with Microsoft ODBC Driver 17 for SQL Server"
https://learn.microsoft.com/en-us/sql/c ... rver-ver16

So for your environment the solution is to install both drivers.
Andreas Neufert
VP, Product Management
Posts: 7145
Liked: 1532 times
Joined: May 04, 2011 8:36 am
Full Name: Andreas Neufert
Location: Germany
Contact:

Re: VBR 12 - MSSQL plugin broken when having ODBC 18 driver installed

Post by Andreas Neufert »

..and to complete this, with the upcoming 12.1.2 cumulative patch we have the plan to support ODBC driver 18 directly. But today you can use both drivers on same system to use our and your product.
markhsc
Novice
Posts: 3
Liked: never
Joined: Mar 13, 2024 8:54 pm
Full Name: Mark Davidson
Contact:

Re: VBR 12 - MSSQL plugin broken when having ODBC 18 driver installed

Post by markhsc »

Andreas Neufert wrote: Mar 14, 2024 7:54 am From Microsoft documentation:
"The Microsoft ODBC Driver 18 for SQL Server can be installed side by side with Microsoft ODBC Driver 17 for SQL Server"
https://learn.microsoft.com/en-us/sql/c ... rver-ver16

So for your environment the solution is to install both drivers.
We have both odbc drivers 17 and 18 installed. The Veeam plugin for SQl installed is 12.0.3.1423. Is it possible to pin the plugin to use ODBC 17 Driver for SQL even though 18 was installed for another product that requires it for their latest upgrade?

Ideas when 12.1.2 cumulative patch will be release to the general public?
Andreas Neufert
VP, Product Management
Posts: 7145
Liked: 1532 times
Joined: May 04, 2011 8:36 am
Full Name: Andreas Neufert
Location: Germany
Contact:

Re: VBR 12 - MSSQL plugin broken when having ODBC 18 driver installed

Post by Andreas Neufert »

Strange, do you have an open support case with uploaded logs? What is the ticket number, please?
tom.delozier
Lurker
Posts: 2
Liked: never
Joined: Dec 06, 2023 11:04 pm
Contact:

Re: VBR 12 - MSSQL plugin broken when having ODBC 18 driver installed

Post by tom.delozier »

We have case #07186380 open for this issue. It appears that the Veeam MS SQL plugin process wants to use version 18 of the ODBC driver instead of 17 when both are present and then fails for both backup and restores.
markhsc
Novice
Posts: 3
Liked: never
Joined: Mar 13, 2024 8:54 pm
Full Name: Mark Davidson
Contact:

Re: VBR 12 - MSSQL plugin broken when having ODBC 18 driver installed

Post by markhsc »

@andreas Neufert,
Our Veeam Admin has attached the support ticket 07186380.
Andreas Neufert
VP, Product Management
Posts: 7145
Liked: 1532 times
Joined: May 04, 2011 8:36 am
Full Name: Andreas Neufert
Location: Germany
Contact:

Re: VBR 12 - MSSQL plugin broken when having ODBC 18 driver installed

Post by Andreas Neufert »

Thank you. It looks like that this processing is not as expected. Upcoming patch in April will use always use the version 17 ODBC driver and will fall back to the latest. It will have a xml setting to select a specific one. If you can, please delay the ODBC18 installation and maybe if you can not consider backing up the server for some time with our Image level backup option until the new update is out.
Andreas Neufert
VP, Product Management
Posts: 7145
Liked: 1532 times
Joined: May 04, 2011 8:36 am
Full Name: Andreas Neufert
Location: Germany
Contact:

Re: VBR 12 - MSSQL plugin broken when having ODBC 18 driver installed

Post by Andreas Neufert »

Corrected my post based on new feedback from DEV.
Post Reply

Who is online

Users browsing this forum: No registered users and 4 guests