I connect to my clients environment through VPN but my machine is not in client domain. I was not able to connect to SQL engine with Windows Authentication by using Run as different user option.
Thanks to Madhukar Gilla who helped me to find a simple solution;
runas /user:domain\user /netonly "C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\Ssms.exe"
/user Provide the remove domain and user name.
/netonly This option allows remote authentication instead of local authentication.
“C:\Program Files (x86)\Microsoft SQL………………..” complete path of the app that you want to run along with the exe file.
I need not TS (remote login) to a server in domain every time 🙂
Tag: connect to sql server with windows authentication on different domain