OLE "DB login failed" for SSIS job through SSH

0

I have an SSIS job that I need to activate via ssh. SSH service is BitVise. I am able to connect using keys generated on my unix host.

I run the following script on my unix host:

#!/usr/bin/env bash

# expects host configuration in ~/.ssh/config
# Host ssis-test
#     HostName SSISTEST
#     User WINDOWSUSER
#     Port 22
#     IdentityFile /home/foo/.ssh/ssis_dsa
#     PasswordAuthentication no
#
ssh ssis-test "D:\\Airflow\\run-ssis.bat"

. . . which simply calls a script on the windows host.

I then see the following error:

Microsoft (R) SQL Server Execute Package Utility
Version 12.0.4100.1 for 64-bit
Copyright (C) Microsoft Corporation. All rights reserved.

Started:  1:39:31 PM
Progress: 2017-09-15 13:39:31.70
   Source: Data Flow Task 
   Validating: 0% complete
End Progress
Progress: 2017-09-15 13:39:31.70
   Source: Data Flow Task 
   Validating: 50% complete
End Progress
Error: 2017-09-15 13:39:31.77
   Code: 0xC0202009
   Source: Extract VR CSV file Connection manager "WINDOWS-HOST\MY_CLIENT_RPT"
   Description: SSIS Error Code DTS_E_OLEDBERROR.  An OLE DB error has occurred. Error code: 0x80040E4D.
An OLE DB record is available.  Source: "Microsoft OLE DB Provider for SQL Server"  Hresult: 0x80040E4D  Description: "Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.".
End Error
Error: 2017-09-15 13:39:31.77
   Code: 0xC020801C
   Source: Data Flow Task OLE DB Destination [67]
   Description: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER.  The AcquireConnection method call to the connection manager "WINDOWS-HOST\MY_CLIENT_RPT" failed with error code 0xC0202009.  There may be error messages posted before this with more information on why the AcquireConnection method call failed.
End Error
Error: 2017-09-15 13:39:31.77
   Code: 0xC0047017
   Source: Data Flow Task SSIS.Pipeline
   Description: OLE DB Destination failed validation and returned error code 0xC020801C.
End Error

The script works fine when I call it from a command prompt when logged into my windows host via winrm.

It appears that when I log in via ssh, whatever mechanism OLE uses to get my domain\username is not being properly tickled. How do I let OLE know who I am before running my SSIS batch?

ssh
windows-server-2012-r2
kerberos
windows-command-prompt
ssis
asked on Server Fault Sep 15, 2017 by Foo Barberger

0 Answers

Nobody has answered this question yet.


User contributions licensed under CC BY-SA 3.0