Temporarily login to another windows domain

Question

I'm using Vista, and need to temporarily (1 day a week at a client) logon to another windows domain (my laptop is on the work domain, and I don't want to have to put the machine permanently on the client's domain).

I need to actually logon to the domain, because I need to use windows authentication for things like SQL Server, I know that you can put in the username/pass for file shares.

I have a login for the domain, and admin rights on my machine.

Is this possible?

Answer 1

If you have a domain account, you should be able to authenticate to the target machine with your domain credentials and have those credentials passed for other operations (such as your SQL login). Try authenticating to the IPC Share on the target machine as follows. Run a command prompt as administrator and do ...

net use \\10.1.1.1\IPC$ /u:DOMAIN\UserName password

Substitute 10.1.1.1 with the IP Address of the computer you want to connect to and put your credentials in properly for the /u switch.

Answer 2

This solution is supposed to work with 2005

http://www.eggheadcafe.com/conversation.aspx?messageid=32222857&threadid=31792004

The solution given is for the management studio.

Answer 3

This blog entry seems to help with a lot of cross-domain issues: http://www.olegsych.com/2009/05/crossing-domain-boundaries-windows-authentication/

I've successfully used the runas /user:domain\account /netonly <program> command to start up sqlwb.exe and therefore connect to sql server. It also seems to work with other network applications.