Is it possible to have a SQL Server stored procedure in Domain A read data from tables in Domain B?
I want to have a stored procedure on a server in Domain A, read data from some tables in Domain B. Is this possible in SQL Server?

Software/Hardware used:
ASKED: April 28, 2008  3:49 PM
UPDATED: April 29, 2008  4:55 PM

Answer Wiki:
Yes is is possible via a linked server. Use the UI to setup a linked server between the two servers. The domains do not need to be trusted, you just need to know the IP of the remote machine, and have a hole in the firewall to connect to the SQL Server on the remote machine. Then use the full four part name to access data across the linked server. <pre>SELECT * FROM [RemoteServer].YourDatabase.dbo.YourTable</pre>
Last Wiki Answer Submitted:  April 29, 2008  4:55 pm  by  Denny Cherry   64,520 pts.
All Answer Wiki Contributors:  Denny Cherry   64,520 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _


 

Check out my SQL Server blog “SQL Server with Mr Denny” for more SQL Server information.

 64,520 pts.