且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

通过 vpn 的 windows 身份验证连接到 sql

更新时间:2023-02-22 19:13:55

尝试创建快捷方式:

runas /noprofile /netonly /user:domainusername ssms.exe

您可能需要对 ssms.exe 的路径进行硬编码.在一些位置,它会在 SSMS 中看起来,就像您使用本地凭据一样,但您应该能够在远程服务器上验证您的凭据正在传递.

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.

这当然取决于您的请求是否正确路由到目标 SQL Server.

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