I received the below error while login into instance,
Login failed. The login is from an untrusted domain and cannot be used with Windows authentication. (Microsoft SQL Server, Error: 18452)
I tried with SQL Authentication, it is working whereas windows authentication is not working. Later I verified in the error log, if found lot of event - 17806 SSPI handshake failed errors on the error log file.
This might be because of SPN Entry is missing on the server which you are looking for.
Work Around
Register SPN for the SQL Service
Setspn -A MSSQLSVC/MySQLServer:3443/SQLService
List SPN Entries
Setspn -L <serviceAccount>--Displays list of entries of hosts which is using this service account.
Login failed. The login is from an untrusted domain and cannot be used with Windows authentication. (Microsoft SQL Server, Error: 18452)
I tried with SQL Authentication, it is working whereas windows authentication is not working. Later I verified in the error log, if found lot of event - 17806 SSPI handshake failed errors on the error log file.
This might be because of SPN Entry is missing on the server which you are looking for.
Work Around
Register SPN for the SQL Service
Setspn -A MSSQLSVC/MySQLServer:3443/SQLService
List SPN Entries
Setspn -L <serviceAccount>
No comments: