Enterprise SQL Job Activity Reporting

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Craig Benson » Enterprise SQL Job Activity Reporting

15 posts, Page 2 of 2

««1 2

Enterprise SQL Job Activity Reporting

Rate Topic

Display Mode

Topic Options

Author

Message

iBar

Posted Monday, February 01, 2010 8:19 AM

Mr or Mrs. 500

Group: General Forum Members
Last Login: Thursday, April 18, 2013 11:16 AM
Points: 572, Visits: 746

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

dave-dj

Posted Monday, February 01, 2010 9:42 AM

Old Hand

Group: General Forum Members
Last Login: Yesterday @ 11:47 AM
Points: 380, Visits: 1,014

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

smthembu

Posted Wednesday, May 25, 2011 11:33 PM

Right there with Babe

Group: General Forum Members
Last Login: Today @ 6:17 AM
Points: 772, Visits: 729

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 Smile

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

Post Attachments

SSRS graph.JPG (4 views, 27.64 KB)

Post #1115189

D-SQL

Posted Monday, January 09, 2012 5:33 PM

Valued Member

Group: General Forum Members
Last Login: Thursday, May 16, 2013 5:44 PM
Points: 69, Visits: 428

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

D-SQL

Posted Wednesday, February 01, 2012 10:05 AM

Valued Member

Group: General Forum Members
Last Login: Thursday, May 16, 2013 5:44 PM
Points: 69, Visits: 428

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 »

15 posts, Page 2 of 2

««1 2

Permissions