Devolutions ForumDevolutions Forum

SSMS Addon - "The target principal name is incorrect. Cannot generate SSPI context."

SSMS Addon - "The target principal name is incorrect. Cannot generate SSPI context."

avatar
greg06
Disabled

I'm having trouble configuring the Sql Server Management Studio add-on to use "Net Only".

Desktop is Windows 1809 (OW Build 1763.195) which has been Azure AD Joined.
Server is Azure VM running Windows and joined to Azure Domain Services.
Connectivity is over Azure P2S VPN

I can connect successfully to SQL Server from the Desktop using the following command:
runas /netonly /user:domainname\loginname ssms
After SSMS starts, I enter the server name and select authentication "Windows Authentication"
I'm using SSMS v17.9.1

I'm trying to use "Sql Server Management Studio Add-on" version 2.6.1.0 to replicate what I can do with the command line using the following settings:


















When I try to connect using the Add-on, I get the error:
"The target principal name is incorrect. Cannot generate SSPI context."

I tried disabling the firewall on the server which had no impact.

All Comments (5)

avatar
Stéfane Lavergne

Can you try setting the RunAs Username to domainname\loginname and leaving the domain field empty.

I have a feeling that it might work. If that doesn't work let me know and I will investigate.

Best regards,

Stéfane Lavergne

avatar
greg06

Thanks for the quick response. And sorry for my delayed response. I thought I replied immediately but must have missed the button click...

Unfortunately the changing the username and clearing the domain name did not work.

Let me know if there is anything else I can do to aid in your investigation.

avatar
Stéfane Lavergne

I am unable to reproduce your issue (see attached video). Am I doing anything different from what you are doing?

Could you please duplicate your session, change the servername/database/username/domain and all other sensitive fields. Save then export session (right click > Export > Export selection (RDM)...). Please send me the .rdm file via email (slavergne@devolutions.net). I will have a look at it to see if there is anything odd going on.

Best regards,

Stéfane Lavergne

SSMS.mp4

avatar
Jeff Dagenais

Hello,

I have created a ticket in our ticketing system to perform a remote session with you.
The ticket number is DEVO-1583.

I've sent you an email via this system, let me know if you didn't received it.

Best regards,

Jeff Dagenais

avatar
David Grandolfo

Hello Greg,

Thanks for the session yesterday, base on the remote diagnostic and multiple tests perform in my infrastructure. I'm afraid that I'm not able to reproduce the issue so I start googling for information.

I found a Microsoft support web page for How to troubleshoot the "Cannot generate SSPI context" error message .

Before testing the Microsoft Tools, could you test RDM on another computer.

Best regards,

David Grandolfo