September 7, 2011 at 5:44 am
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].
September 13, 2011 at 8:33 am
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