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?
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!
posted by Scott Stonehouse @ 5:59 PM
5 Comments
Links to this post
5 Comments:
HI scott
sql server management studio
sql server management student <--is this new?
This solved a big problem for me. Thanks.
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
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
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