Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 SQL 2005 cross domain connection

Author  Topic 

reading2009
Starting Member

22 Posts

Posted - 2010-09-28 : 09:57:11
I am on domain A on Win XP with SQL 2005 management studio only installed on my PC. My login account in on domain A. I am trying to connect to SQL 2005 server on domain B, on win 2003 server. I can remote login to the server on domain B with a domain B account, but I want to be able to connect to the server from management studio installed on my PC.

Is it possible? How?

harsh_athalye
Master Smack Fu Yak Hacker

5581 Posts

Posted - 2010-09-28 : 10:01:55
What if you run management studio by impersonating domain B account (using Run As option) ?

Harsh Athalye
http://www.letsgeek.net/
Go to Top of Page

reading2009
Starting Member

22 Posts

Posted - 2010-09-28 : 10:05:08
I tried. It wont allow me to login. Error; Cannot log on. Bad username password.
Go to Top of Page

reading2009
Starting Member

22 Posts

Posted - 2010-09-28 : 11:10:17
any suggestions here?
Go to Top of Page

robvolk
Most Valuable Yak

15732 Posts

Posted - 2010-09-28 : 11:17:13
Some discussion here that may help:

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=150732

Only other option I can think of is Kerberos, but I have no experience or knowledge with it.
Go to Top of Page
   

- Advertisement -