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

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Query between servers...

Author  Topic 

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!

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.
Go to Top of Page


22859 Posts

Posted - 2005-12-12 : 14:23:35

"They don't seem to want to talk to each other"

How are you currently trying to get them to talk to each other?

Go to Top of Page

Posting Yak Master

145 Posts

Posted - 2005-12-12 : 14:28:15
You can use Linked Servers and do this, or maybe openrowset.

-Like a kidney stone, this too shall pass.
Go to Top of Page

- Advertisement -