Question

  Asked: Apr 28 2008   3:49 PM GMT
  Asked by: SQL Server Ask the Experts


Is it possible to have a SQL Server stored procedure in Domain A read data from tables in Domain B?


SQL Server stored procedures, Stored procedures

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?

Subscribe to Alerts! Get questions and answers delivered to your Inbox.


E-mail me updates on this question



   SUBSCRIBE

hidden modal window

Answer Wiki (Improve, edit or add to this answer)


 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0



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.

SELECT *
FROM [RemoteServer].YourDatabase.dbo.YourTable
  • AddThis Social Bookmark Button

Browse more Questions and Answers on SQL Server and Database.

Looking for relevant SQL Server Whitepapers? Visit the SearchSQLServer.com Research Library.


Discuss This Answer


You must be logged-in to discuss a question. Log-in/Register

Mrdenny  |   Apr 29 2008  4:55PM GMT

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