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!
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.