TDP7.1.6.4 with Windows 2016 and MSSQL2016 issue

[putukas]

Hello!

We ran into problem with TSM server version 7.1.4, client TDP 7.1.6.4 and new windows 2016 with mssql2016 server.
According to documentations 7.1.6.4 should be compatible with mssql2016 and win2016 but while trying to run a backup we got error.

It seems like mssql2016 does not understand some commands TSM is forwarding
Some google post we have found talk about kinda same "Microsoft.SqlServer.BatchParser" problem with some versions of visualstudio but i have not found any posts about the same error with TSM and sql.

The error messag below:
MS SQL Server 2016

DP for SQL 7.1.6.4


Backup-DpSqlComponent somedb-ConfigFile "C:\Program Files\Tivoli\tsm\TDPSql\tdpsql.cfg" -TsmOptFile "C:\Program Files\Tivoli\tsm\TDPSql\dsm.opt" -FULL -BackupDestination TSM -BackupMethod Legacy -SqlServer "hostname,1433" -SQLAUTHentication INTegrated -SqlChecksum No -Stripes 1


Failed - Error: RC: 402

ACO0151E Errors occurred while processing the request.

At Backup-DpSqlComponent -Private somedb-ConfigFile "C:\Program Files\Tivoli\tsm\TDPSql\tdpsql.cfg" -TsmOptFile "C:\Program Files\Tivoli\tsm\TDPSql\dsm.opt" -FULL -BackupDestination TSM -BackupMethod Legacy -SqlServer "hostname,1433" -SQLAUTHentication INTegrated -SqlChecksum No -Stripes 1

InvalidResult: (Capability.Impl....Sql.SqlContext:SqlContext) [Backup-DpSqlComponent], Exception

402,IBM.Tivoli.TSM.Cmdlets.SQL.BackupDpSqlComponent, ACO5422E Received the following from the MS SQL server: Could not load file or assembly 'Microsoft.SqlServer.BatchParser, Version=12.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified. (HRESULT:0x80070002)

 

[moon-buddy]

What is the TSM BA Client version you installed - 7.1.4?

If it is, update to a much higher version than your TDP version.

Other references:

http://www-01.ibm.com/support/docview.wss?uid=swg1IT11894

 

[Julia]

What is the TSM BA Client version you installed - 7.1.4?

If it is, update to a much higher version than your TDP version.

Other references:

http://www-01.ibm.com/support/docview.wss?uid=swg1IT11894

We had BA Client version 7.1.6, I updated it to 7.1.8, but still the same error message.
By the way VSS backup is working, but it's not possible to do log backup with vss.

 

[Julia]

Anyways we found a solution for this problem.

Copied C:\Program Files (x86)\Microsoft SQL Server\130\Tools\Binn\ManagementStudio\Microsoft.SqlServer.BatchParserClient.dll to folder C:\Windows\assembly\GAC_MSIL\Microsoft.SqlServer.BatchParserClient\12.0.0.0__89845dcd8080cc91

After this action legacy backup works fine from GUI/Command Line