DBSolo - Cannot connect to SQL Server database - integrated security

0

I am using DBSOLO to compare 2 SQL Server database tables. I have added a server to DB solo, but the connection to that server is not successful. On checking SQL Server logs, following is the error message:

Login Failed. The login is from an untrusted domain and cannot be used with Windows Authentication. [CLIENT: X.X.X.X]

SSPI handshake failed with error code 0x8009030c, state 14 while establishing a connection with integrated security; the connection has been closed. Reason: AcceptSecurityContext failed. The Windows error code indicates the cause of the failure. [CLIENT: X.X.X.X]

I have read many articles related to this error, and most of them talk about the issue of Integrated Security. Maybe this is the issue in my case also. I am a beginner in this and don't know where or how to fix this case. Where to remove integrated security in DBSolo? Any ideas?

Note: The client, as well as the DB servers, are hosted in AWS.

sql-server
amazon-web-services
db-solo
asked on Stack Overflow Apr 5, 2018 by Biju P Dais • edited Apr 5, 2018 by marc_s

0 Answers

Nobody has answered this question yet.


User contributions licensed under CC BY-SA 3.0