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 |
|
vyelchri
Starting Member
12 Posts |
 Posted - 2009-01-02 : 07:28:38
|
| How to access data in two different domains. Suppose 'Emp' table is in Server1, this is in ABC Domain(network) and 'Marks' table is in Server2, this Server2 is in XYZ Domain(another network). I will connect to only Server1 and i need to access 'Marks' table which is in server2.Can any body explain the procedure ?Thanks,VB |
|
|
raky
Aged Yak Warrior
767 Posts |
Posted - 2009-01-02 : 07:34:09
|
| As per my knowledge try thisCreate Linked Server and then use the following syntaxselect * from servername.databasename.schema.tablename to get data |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-01-02 : 12:24:20
|
quote:
Originally posted by raky
As per my knowledge try thisCreate Linked Server and then use the following syntaxselect * from servername.databasename.schema.tablename to get data
You should be good with SQL Login for linked server if you are connecting across domain. |
|
|
|
|
|
|
Access Data from two different Domains