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.
| Author |
Topic |
|
boksantos
Starting Member
6 Posts |
 Posted - 2007-06-28 : 03:51:08
|
| i have 2 server in different domains, eg. a.xxx.com and b.yyy.com, how can i map b.yyy.com when im in a.xxx.com? i added an admin user account in both server, but it still wont work.i have no problem when two servers are in the same domain.. but with this situation, what must i do? tnx a lot |
|
|
bjani
Starting Member
2 Posts |
Posted - 2007-06-28 : 10:02:13
|
| If your servers allow sql server authentication then it shoudn't be a problem setting up a connection with a user and password local to that server. If not, have you considered creating a trust relationship among your domains?Let me know if this helped.[Borix] |
 |
|
|
boksantos
Starting Member
6 Posts |
Posted - 2007-06-28 : 21:36:42
|
| tnx a lot. Both servers are using Sql Server and Windows authentication or mixed mode. i also use the sp_addlinkedsvrlogin to map accounts but it still doesn't work. i read though that i need to create a trust relationship between the two server and i'll try this one. thanks again |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-06-28 : 23:26:46
|
| Try map user to standard sql login on linked server. |
|
|
|
|
|
|
linked server help