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 ««12

Enterprise SQL Job Activity Reporting Expand / Collapse
Author
Message
Posted Monday, February 01, 2010 8:19 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: Friday, November 29, 2013 3:09 AM
Points: 574, Visits: 792
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 #857217
Posted Monday, February 01, 2010 9:42 AM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Tuesday, April 01, 2014 7:50 AM
Points: 404, Visits: 1,124
Check that you have

a) remote connections enable for named pipes in is enabled in SQL Server Surface Area Manager > Surface Area Configuration for Services and Connections

b) OPENROWSET is enabled in SQL Server Surface Area Manager > Surface Area Configuration & Features


_____________________________________________________________________________
MCITP: Business Intelligence Developer (2005)
Post #857329
Posted Wednesday, May 25, 2011 11:33 PM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Yesterday @ 6:13 AM
Points: 923, Visits: 861
Great article Craig, just to acknowledge your work i also modified the reports to include a graph to get a quick glance before scanning the report to check for failed jobs.

Tx once more





It's better to fail while trying, rather than fail without trying!!!


  Post Attachments 
SSRS graph.JPG (4 views, 27.64 KB)
Post #1115189
Posted Monday, January 09, 2012 5:33 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: 2 days ago @ 8:34 AM
Points: 73, Visits: 571
This post is pretty old but I have a question i have the report all set up but Im having issues getting one of my reports to show up one server. I added one more server to the report but the in tables if I select still cant get the job activity. This is a instance sql server thats the only difference from the other 9 servers.

I have 9 working and set up exaclty the same.

Any help would be appreciated
Post #1232875
Posted Wednesday, February 01, 2012 10:05 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: 2 days ago @ 8:34 AM
Points: 73, Visits: 571
This is a great. I have a question now that I have this all set up I have added a SQL instance can you point me in the right direction in the SQL to use the instance ion the server?

Thanks
Post #1245191
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse