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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-01-31 : 08:52:47
|
| Rakesh writes "Hi I am new to SQL serevr but would like to know if its possible to get data from a SQl server database which is on a different network i.e something like DB link in Oracle. But here important point is other server is on different network of different company may be on different continent.Actually I want to select data from SQl Server A(At Client site different network) and update my SQl server B(At my company network) database. if this is possible than it will be great if I can get the Software / Hardware requirements if any and steps/links to steps how we can do this.Thanks and RegardsRakesh" |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2006-01-31 : 09:16:23
|
| If you have a login on the remote server, then it shouldn't be a problem, simply use the tcp/ip address of the server to connect. |
 |
|
|
|
|
|
SQl server Database access over different network