connect to sql via windows authentication over vpn

问题:

Is there any way I can connect to a remote SQL server with Windows Authentication over VPN?

I can connect to the VPN server in Windows 7 using Domain Credentials like \DOMAIN\user but I want to be able to connect to the SQL server with the Domain Credentials because I don't have the sa account .

回答1:

Try creating a shortcut with:

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

You may have to hard-code the path to ssms.exe. In a few locations it will look in SSMS like you are using your local credentials, but you should be able to verify on the remote server that your credentials are being passed.

This of course depends on your requests being correctly routed to the destination SQL Server.