Monday, February 09, 2009

Connect to SQL Server using Windows Authentication when computer is not on Active Directory Domain

Steve Novoselac wrote this article over a year ago, and I only found it last week.  Sometimes you aren't logged into the approprate domain, but you are using Windows authentication on the SQL Server.  How can you get SQL Server Management Student (SSMS) to connect to the server when you aren't logged in?

How To: Connect to SQL Server, VS TFS, etc using Windows Authentication when computer is not on Active Directory Domain (XP and Vista!) - stevienova.com

Can't vouch for the XP instructions, but the Vista instructions worked like a charm!  Just create a new SSMS shortcut that looks like this

C:\Windows\System32\runas.exe /netonly /user:domain\user "C:\path to SSMS\Ssms.exe"

Thanks Steve!

5 Comments:

At Sat Dec 19, 07:55:00 am , Anonymous Doyle said...

HI scott
sql server management studio
sql server management student <--is this new?

 
At Mon Sep 27, 09:27:00 am , Anonymous Membrane Switches said...

This solved a big problem for me. Thanks.

 
At Mon Nov 15, 04:37:00 pm , Blogger Windows 7 Key said...

This is my first time i visit here. I discovered so numerous interesting stuff in your weblog especially its discussion. From the tons of comments on your articles, I guess I am not the only one having all of the enjoyment here! maintain up the great work.
Windows Upgrade

 
At Mon Jan 17, 04:41:00 am , Anonymous Anonymous said...

I have an issue which is as follows.

How can i load xlsx file into oracle db without converting it into .cvs file as when u try to convert into .cvs there is a chance of loosing the data.

looking forward for ur reply.

thank you

 
At Mon Jul 11, 12:25:00 pm , Anonymous email archiving said...

thank you, oh, problem solver. Thumbs up, for your effort!

 

Post a Comment

Subscribe to Post Comments [Atom]

Links to this post:

Create a Link

<< Home