Devolutions ForumDevolutions Forum

Cannot connect to SQL DB over PPTP VPN

Cannot connect to SQL DB over PPTP VPN

avatar
markw

When I am on the local network I am able to connect to the SQL DB of Remote Desktop Manager fine, however if I am working from outside the office and connect through a PPTP VPN back to my work office where the SQL server is it fails with the message:
Unable to connect to server!
The target principal name is incorrect. Cannot generate SSPI context.

The SQL Connection settings uses the SQL server IP address.

I have checked the SPN records and there are no duplicates.
I can ping the SQL server and telnet to port 1433 fine while connected to the VPN.
DNS records resolve the server fine (however the connection uses IP address).
The firewalls allow all traffic between the VPN IP and the SQL server.

The SQL DB is configured to use AD credentials.

Any help would be appreciated.

Thanks

All Comments (2)

avatar
Maurice Côté

Hi,

Some VPN clients act as a "man in the middle" and your network authentication is performed with the credentials that you have used to authenticate on the vpn client.

Are you using you domain credentials to open the vpn?

Best regards,

Maurice

avatar
markw

Hi Maurice,

Thanks for your reply.
I have tested using AD Radius instead of local accounts and confirmed that it now works.

Thanks for your help.

Mark