question

VeenaSrinivas-0229 avatar image
0 Votes"
VeenaSrinivas-0229 asked AmeliaGu-msft commented

Cannot connect to listener in SSMS

Hello,

When I try to connect to a AG listener using SSMS, I get the following error:

"The login is from an untrusted domain and cannot be used with integrated authentication"

I'm using a Domain account which has sys admin role.

Please help.

Thanks,
Veena S

sql-server-general
· 3
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi VeenaSrinivas-0229,
Was your issue resolved?
Did the answer help you?
Please feel free to let us know if you have any other question.
If you find any post in the thread is helpful, you could kindly accept it as answer.
Best Regards,
Amelia

0 Votes 0 ·

Hi Amelia,

Actually no it did not work ...

I'm still getting the error.

Thanks,
Veena

0 Votes 0 ·

Hi VeenaSrinivas-0229,
Thanks for your reply.
What account are you using as the SQL Server service account?
Was the SPN for listener registered for SQL Server service account?
Best Regards,
Amelia

0 Votes 0 ·

1 Answer

AmeliaGu-msft avatar image
0 Votes"
AmeliaGu-msft answered

Hi VeenaSrinivas-0229,

You could try to disable the loopback check setting on machine as follows:

  1. Edit the Windows registry: Start –> Run > Regedit

  2. Navigate to: HKLM\System\CurrentControlSet\Control\LSA

  3. Add a DWORD value called “DisableLoopbackCheck”

  4. Set this value to 1

If this solution doesn’t solve the issue, this issue might be cause by Kerberos and SPN issue.
We need to use FQDN of Listener along with listener port to configure SPN for SQL Server Always On.
You can use the following command in the command line to check if SPN for Listener is registered for SQL Server service account:

 setspn –l accountname

If it doesn’t exist, please configure the SPN for listener:

 setspn -A MSSQLSvc/ <FQDN>: <port> accountname

Please refer to this article and Register a SPN for Kerberos Connections which might help.
Best Regards,
Amelia


If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.