Home > IT Answers > SQL Server > Is it possible to have a SQL Server stored pr...
Help

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
Help

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

IMPROVE THIS ANSWER
View History
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
Last Answered: Apr 29 2008  4:55 PM GMT  by Mrdenny




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.


RSS - Discussions Help

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.