Post reply

Problem with using Linked Server across the network

  • April 28, 2009 at 7:13 am

    #384458

    Hello!

    Please, help to find a solution.

    I have two SQL Servers 2005 (SERVER1 and SERVER2). I created a linked server on SERVER1 that goes to the SERVER2 and is called "SERVER2". I created it from the wizard in the MS SQL Studio and set options "RPC" and "RPC OUT" to true.

    When I go to the SERVER1, open SQL Studio, connect to "localhost" and try to get information from SERVER2 using that linked server - it's OK.

    BUT when I open SQL Studio from another computer, connect to SERVER1 and try to use linked server - timeout expired.

    The most interesting thing is that when I'm using linked server on SERVER1 computer and connection is opened (5 minutes) - I can use this linked server from another computer. But just after the connection was closed - timeout error.

    Do you have any thoughts or suggestions?

  • April 28, 2009 at 7:28 am

    #985069

    Are you using windows authentication and passing through credentials?

    If so you have to enable kerberos double-hop by setting a service principal name on both SERVER1 and SERVER2.

    There are dozens of articles available on this topic, but this one is pretty good: http://support.microsoft.com/kb/319723

    good luck!

    ~BOT

    Craig Outcalt


    Tips for new DBAs: http://www.sqlservercentral.com/articles/Career/64632
    My other articles: http://www.sqlservercentral.com/Authors/Articles/Craig_Outcalt/560258

  • April 28, 2009 at 10:17 pm

    #985634

    Thanks a lot! Thats it. Under SQL authorization the linked server works fine.

    I'm a little confused by giving SQL Server service account privileges of domain administrator or possibility to create SPNs dynamically... Is that secure enough?

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

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