Is it possible to have a SQL Server stored procedure in Domain A read data from tables in Domain B?
Home > IT Answers > SQL Server > Is it possible to have a SQL Server stored pr...
SQL Server Ask the Experts
2445 pts.
0
Q:
Is it possible to have a SQL Server stored procedure in Domain A read data from tables in Domain B?
Stored Procedures, SQL Server 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?
ASKED: Apr 28 2008  3:49 PM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
RELATED QUESTIONS
0
Mrdenny
46765 pts.
0
A:
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
  • AddThis Social Bookmark Button
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
Last Answered: Apr 29 2008  4:55 PM GMT by Mrdenny   46765 pts.
  •   
0
0
RSS - Discussions Help
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

Mrdenny   46765 pts.  |   Apr 29 2008  4:55PM GMT

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

 
0