September 9, 2021 at 4:10 pm
Thanks for posting your issue and hopefully someone will answer soon.
This is an automated bump to increase visibility of your question.
September 10, 2021 at 8:29 am
What do you mean by "there is a small difference in DNS between VM and SQL hostname"
What software do you use for the connection?
Do you connect using the fully qualified domain name myservera.mydomaina.com ?
The situation is ?
MyDBA is on myservera.mydomaina.com
MyDBB is on myserverb.mydomainb.com
Created the login myuser@domaina.com on both SQL-servers.
Logged in as myuser@domaina.com on myservera.mydomaina.com
Connecting from myservera.mydomaina.com to myserverb.mydomainb.com fails with The target principal name is incorrect. Cannot generate SSPI context. Using SSMS on myservera with windowsauthentication
Is this assumption correct?
September 27, 2021 at 12:48 pm
Hi, I am really sorry for such late response.
What do you mean by "there is a small difference in DNS between VM and SQL hostname"
DNS of VM is 'xxxxxxx-01', while in management studio while if I go to 'Object Explorer' right-click on the server name, and properties as a name of the server (first line of General page) I can see 'xxxxxxx' (without '-01' )
What software do you use for the connection?
I was trying only with management studio.
Do you connect using the fully qualified domain name myservera.mydomaina.com ?
I was testing xxxxxxx.mydomaina.com, xxxxxxx-01.mydomaina.com, xxxxxxx, xxxxxxx-01 each time effect was the same. The only difference was when i was using IP address (in that case I was able to connect).
Is this assumption correct?
yep, that's pretty much mine situation.
Viewing 3 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply