Using SQL Server Management tools and Integrated Security/Windows Authentication from a non-domain joined machine

John Paul Cook -  Using Windows Authentication from a non-domain joined machine

“Sometimes it is necessary to use Windows domain credentials to authenticate to SQL Server from a non-domain joined machine. Here’s a trick from my coworker Martin Kastenbaum to pass Windows domain credentials from a non-domain joined machine. Modify the shortcut (or create a copy and modify it) you use to start SQL Server Management Studio to pass your Windows domain and username.

…

…”

I thought this was a neat trick and one I’ll be able to use in a couple ways. First from VM’s that are not domain members and to access other, non-trusted domain resources.

The magic is via shortcuts, RunAs and the /netonly parameter.

On a related note, I find it funny how information flows. Seems this trick has been around for over 7+ years… lol