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 |
MikeO
Starting Member
1 Post |
Posted - 2005-12-12 : 10:55:11
|
We have 2 SQL Servers running, each with different corp. databases. We now have a need to build queries using data from BOTH databases. They don't seem to want to talk to each other, is it possible something was missed on the set-up of 1 or both of the servers?TIA for the help, I'm the only DB guy here - Admin/Server setup is a learning experience, and much of this was inherited! |
|
Srinika
Master Smack Fu Yak Hacker
1378 Posts |
Posted - 2005-12-12 : 11:28:34
|
R those 2 servers running on the same network? Same Workgroup ? Same Domain ?Can u access one server from the other (in both ways ?)Do u have same user setup on both machines (A user in SQL Server) ?While on one server, open query analyzer and access a table in a DB in the other Server!!Give a feedback to proceed. |
|
|
Kristen
Test
22859 Posts |
Posted - 2005-12-12 : 14:23:35
|
and:"They don't seem to want to talk to each other"How are you currently trying to get them to talk to each other?Kristen |
|
|
bakerjon
Posting Yak Master
145 Posts |
|
|
|
|