Post reply

Execute a stored procedure from different domain

  • May 29, 2012 at 7:52 am

    #274711

    Hi Guru,

    I have two stored procedures are on different servers and different domains. usp_A is on server A domain A. usp_B is on server B domain B. I want usp_A to fire off usp_B. Is that possible? I'm not so sure if linked server or other options are possible if we have firewall rule open properlty.

    Thanks,

    Attopeu

  • May 29, 2012 at 9:02 am

    #1494223

    The fact that the two servers are in different domains is only relevant if you want to use NT Authentication to fire off usp_B using a Linked Server.

    If you have an open network path (allowing firewall rules) for SQL Server on Server A to connect to SQL Server on Server B then you can use SQL Authentication if there is no domain trust.

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply