June 11, 2018 at 4:04 am
Hi friends,
We had an AlwaysOn setup with (Primary, HA and DR) in three Azure servers. All are under the same domain. Recently I noticed that when we try to Primary to HA via SSMS, I'm getting the connection error " The login is from an untrusted domain and cannot be used with windows authentication". However I'm able to connect to Primary to DR and from DR to Primary too. When I googled, blogs suggest that to create SPN for the SQL Service account. Do anyone faced this type of error?
Note: All the SQL instances are running under same SQL service account. Always On is not configured due to this error.
Thanks in advance for the your points, views and suggestions.
June 11, 2018 at 6:55 am
- Are you using a group managed service account? I think so but I want to check.
- Does your account have permission to register SPNs? You can check in the command prompt by typing setspn -l [DOMAIN\ACCOUNT] (that's safe to run).
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply