dbTalk Databases Forums  

How can you connect to SQL 2005 with Windows authentication, but different credentials than your current login?

microsoft.public.sqlserver.clients microsoft.public.sqlserver.clients


Discuss How can you connect to SQL 2005 with Windows authentication, but different credentials than your current login? in the microsoft.public.sqlserver.clients forum.



Reply
 
Thread Tools Display Modes
  #41  
Old   
Truan
 
Posts: n/a

Default RE: How can you connect to SQL 2005 with Windows authentication, but d - 04-24-2008 , 05:33 AM






I couldn't get the NET USE to work either, but I found using the 'Run As...'
option when starting management studio and specifying my other credentials
worked fine.

hope that helps

Truan

"Paul Shapiro" wrote:

Quote:
Sometimes I need to work on a client system from my laptop, but my laptop is
not part of the client's domain. I have login credentials in their domain,
but I don't know how to pass their domain credentials to SQL Server for
integrated Windows authentication. I tried from a Win XP Pro SP2 computer,
by setting their domain credentials in the Windows Password Manager for the
SQL Server, but it didn't work. Do you need to include the domain name with
the machine name?

Is their a way to specify alternate Windows login credentials?



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.