Fred_Butz_535

MSSQL Windows Authentication

Discussion created by Fred_Butz_535 on Jan 11, 2017
Latest reply on Jan 12, 2017 by Josef_Scharl_103
We have the database agent installed and working for native sql logins, but we want to add one for AD authentication and we are having issues.

The DLL exists in the bin folder and the system32 folder for 2012
Anonymous user has been set to Y in client 0
The ini has been updated to accept windows authentication, but we get the following error with the server name instead of the user.

2017-01-11 15:01:42 - U2000005 Job 'SQL.AUTOMIC.TRANSFER_CONTENT.WINDOWS' with RunID '124454748' started.
2017-01-11 15:01:42 - U2012031 The database driver returned the following error message:
2017-01-11 15:01:42            Login failed for user 'VHACORP\ACLD1U01PSH$'. ClientConnectionId:3d7ddd6b-dc53-44b0-b14a-c1157fe25f8a

Outcomes