Post reply

configure log shipping in sql server 2008 between two different domains

  • July 31, 2014 at 1:15 am

    #397143

    Hi,

    There is a requirement to one of our client to configure log shipping between two different domains, Is there any way is there ? could you please help me.

    Thanks & Regards,

    Annam Babu

  • July 31, 2014 at 1:31 am

    #1733937

    Yes it is possible.

    *****************************************************************************************

    Cross Domain Log Shipping

    If computers that are running SQL Server are placed in a multi-domain environment, Microsoft recommends that you set up two-way trusts between all domains that are involved in log shipping. However, if you cannot establish trusts between domains, you can use network pass-through security for log shipping. Refer to the section of this article that discusses the LocalSystem network account startup option for SQL Server-related services.

    *****************************************************************************************

    Extract is from the following KB article...

    http://support.microsoft.com/kb/321247

  • July 31, 2014 at 1:34 am

    #1733940

    Here's another article with a step-by-step guide.

    http://www.mssqltips.com/sqlservertip/2562/sql-server-log-shipping-to-a-different-domain-or-workgroup/

  • July 31, 2014 at 7:25 am

    #1734057

    annam.dba (7/31/2014)

    Hi,

    There is a requirement to one of our client to configure log shipping between two different domains, Is there any way is there ? could you please help me.

    Thanks & Regards,

    Annam Babu

    Check my guide at this link

    http://www.sqlservercentral.com/articles/Log+Shipping/76757/[/url]

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • August 1, 2014 at 1:52 am

    #1734360

    Hi,

    The two domains are un trusted, I have checked with my network team they told it's not passable to establish trusts between two domains. Is it passable please provide screenshots. I am MSBI developer, I don't know more about SQL DBA.

    Thanks,

    Annam

  • August 1, 2014 at 3:05 am

    #1734375

    Where you can't trust domains treat the servers like a workgroup and follow my guide at the link provided 😉

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

Viewing 6 posts - 1 through 5 (of 5 total)

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