Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

ERROR with OPENROWSET on remote servers in DMZ Expand / Collapse
Author
Message
Posted Wednesday, January 20, 2010 7:43 AM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Thursday, December 11, 2014 8:32 AM
Points: 574, Visits: 817
Hello,

Getting following error if i create an OLE DB soruce to remote DB

OLE DB provider "SQLNCLI" for linked server "(null)" returned message "Login timeout expired".
OLE DB provider "SQLNCLI" for linked server "(null)" 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 2, Level 16, State 1, Line 0
Named Pipes Provider: Could not open a connection to SQL Server [2].


If i remove the OPENROWSET it works fine.

Is there any alternate to OPENROWSET, which will eventually remove the problem of "Ad-Hoc Remote Queries"
OR
How to fix the above error ?

Cheers
Post #850494
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse