Connecting servers remotely.

  • Hello All,

    This might be a small problem but is bugging me for long. I have three servers, one is my local server (SERVER1-on which I am working) and it is running SQL 2008. And two other(SERVER2 & SERVER3) which are running SQL 2005.

    I want to fetch data from SERVER3 when I am logged in SERVER2.

    I am running following query when I am on SERVER2

    select * from SERVER3.DbName.TableName

    and its giving me error

    OLE DB provider "SQLNCLI" for linked server "SERVER3" returned message "Login timeout expired".

    OLE DB provider "SQLNCLI" for linked server "SERVER3" returned message "An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections.".

    Msg 53, Level 16, State 1, Line 0

    But the same query doesn't gave me any error and worked fine when I am logged on to my local server SERVER1.

    I have already added both the servers using sp_addlinkedserver.

    Any help would be really appreciated.

    Thanks

    Named Pipes Provider: Could not open a connection to SQL Server [53].

  • Sql Servers 2005 and 2008 probably have different default settings for linked servers, therefore they behaves differently. I would suggest for 2005 you:

    1) check connection/security (from srv2 to srv3);

    2) check Linked Server "Server Options";

    3) select only 1 row for test purpose from srv3

    This way you can probably find what is the reason for error.

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

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