1

I am trying to connect to remote SQL Server using Windows Authentication over VPN. I did some research on that and found two ways to achieve this From here

The first approach works fine

runas /netonly /user:domain\username ssms.exe

But according to the second answer there it can also be achieved via windows credential manager. But that seems not working for me.

I have set these credentials in in credentials manager

192.168.0.58
Domain\usermane
*****

And the SQL Server instance in SSMS looks like this

192.168.0.58\\SQL2017,32839
Windows Authentication
Domanin\username

But this is not working. What am I doing wrong here?

Dale K
  • 25,246
  • 15
  • 42
  • 71
Tech Yogesh
  • 427
  • 4
  • 18

1 Answers1

0

Please try to use server name instead of IP address, server name:port , like node3: 32839. When you connect from Management Studio, make sure you use the exact same server name as the one you entered in the credential, including the port number (only now, use a comma instead of colon if specifying the port number: server,port)

Lucky
  • 16
  • 1