putukas
ADSM.ORG Member
- Joined
- Aug 10, 2006
- Messages
- 41
- Reaction score
- 1
- Points
- 0
- Location
- Estonia, Tallinn
- Website
- Visit site
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)
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)