Saturday, February 27, 2010

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.

…

image

…”

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

No comments:

Post a Comment

NOTE: Anonymous Commenting has been turned off for a while... The comment spammers are just killing me...

ALL comments are moderated. I will review every comment before it will appear on the blog.

Your comment WILL NOT APPEAR UNTIL I approve it. This may take some hours...

I reserve, and will use, the right to not approve ANY comment for ANY reason. I will not usually, but if it's off topic, spam (or even close to spam-like), inflammatory, mean, etc, etc, well... then...

Please see my comment policy for more information if you are interested.

Thanks,
Greg

PS. I am proactively moderating comments. Your comment WILL NOT APPEAR UNTIL I approve it. This may take some hours...