Hi,

is the SQL Server reachable from the SCCM Server, also two ways? Simple but what says ping? DNS is OKAY?

We are working with a administrativ Service Account in AD, the Account doesnt do anything, only connecting between the Servers!

Run it same time or is this a Problem after installation the system?

Try it out and repost.

• Edited by mr. AAJ Friday, January 25, 2013 4:34 PM

Hi:

According to all the Reporting Services logs my Reporting Point was setup correctly.  When I try and run any report I see the entries below in the srsrp.log on the SQL Server.  The report names show up in the Console but when I right any of the listed reports I get errors and no report runs.

I am running SQL Server 2008 R2 SP2 on a remote server.  SQL is installed on its own server.  There is no firewall between the Configuration Manager server and SQL Server.

Thanks.

Mark

(!) Error retrieving folders - [A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: TCP Provider, error: 0 - A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.)].   SMS_SRS_REPORTING_POINT 1/25/2013 9:15:07 AM    4532 (0x11B4)

No folder configuration information found.      SMS_SRS_REPORTING_POINT 1/25/2013 9:15:07 AM    4532 (0x11B4)

Next security configuration at [1/25/2013 9:22:42 AM] SMS_SRS_REPORTING_POINT 1/25/2013 9:15:07 AM    4532 (0x11B4)

Root Folder exists      SMS_SRS_REPORTING_POINT 1/25/2013 9:15:07 AM    4532 (0x11B4)

Successfully checked that the SRS web service is healthy on server DBSCCM.LOCAL     SMS_SRS_REPORTING_POINT 1/25/2013 9:15:07 AM  4532 (0x11B4)

Waiting for changes for 1 minutes   SMS_SRS_REPORTING_POINT 1/25/2013 9:15:07 AM    4532 (0x11B4)

SRSRP registry key change notification triggered.     SMS_SRS_REPORTING_POINT 1/25/2013 9:15:16 AM    4532 (0x11B4)

Waiting for changes for 1 minutes   SMS_SRS_REPORTING_POINT 1/25/2013 9:15:16 AM    4532 (0x11B4)

Timed Out...      SMS_SRS_REPORTING_POINT 1/25/2013 9:16:16 AM    4532 (0x11B4)

Reporting Services URL from Registry [http://dbsccm/ReportServer/ReportService2005.asmx]  SMS_SRS_REPORTING_POINT 1/25/2013 9:16:16 AM  4532 (0x11B4)

Reporting Services is running SMS_SRS_REPORTING_POINT 1/25/2013 9:16:16 AM    4532 (0x11B4)

Retrieved datasource definition from the server.      SMS_SRS_REPORTING_POINT 1/25/2013 9:16:16 AM    4532 (0x11B4)

Retrieved datasource definition from the server.      SMS_SRS_REPORTING_POINT 1/25/2013 9:16:16 AM    4532 (0x11B4)

Updating data source {5C6358F2-4BB6-4a1b-A16E-8D96795D8602} at ManagedDesktops_MD1  SMS_SRS_REPORTING_POINT 1/25/2013 9:16:16 AM  4532 (0x11B4)

(!) Error retrieving folders - [A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: TCP Provider, error: 0 - A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.)].   SMS_SRS_REPORTING_POINT 1/25/2013 9:17:40 AM    4532 (0x11B4)

No folder configuration information found.      SMS_SRS_REPORTING_POINT 1/25/2013 9:17:40 AM    4532 (0x11B4)

Next security configuration at [1/25/2013 9:22:42 AM] SMS_SRS_REPORTING_POINT 1/25/2013 9:17:40 AM    4532 (0x11B4)

Root Folder exists      SMS_SRS_REPORTING_POINT 1/25/2013 9:17:40 AM    4532 (0x11B4)

Successfully checked that the SRS web service is healthy on server DBSCCM.LOCAL     SMS_SRS_REPORTING_POINT 1/25/2013 9:17:40 AM  4532 (0x11B4)

Waiting for changes for 1 minutes   SMS_SRS_REPORTING_POINT 1/25/2013 9:17:40 AM    4532 (0x11B4)

Timed Out...      SMS_SRS_REPORTING_POINT 1/25/2013 9:18:40 AM    4532 (0x11B4)

Reporting Services URL from Registry [http://dbsccm/ReportServer/ReportService2005.asmx]  SMS_SRS_REPORTING_POINT 1/25/2013 9:18:40 AM  4532 (0x11B4)

Reporting Services is running SMS_SRS_REPORTING_POINT 1/25/2013 9:18:40 AM    4532 (0x11B4)

Retrieved datasource definition from the server.      SMS_SRS_REPORTING_POINT 1/25/2013 9:18:40 AM    4532 (0x11B4)

Retrieved datasource definition from the server.      SMS_SRS_REPORTING_POINT 1/25/2013 9:18:40 AM    4532 (0x11B4)

Updating data source {5C6358F2-4BB6-4a1b-A16E-8D96795D8602} at ManagedDesktops_MD1  SMS_SRS_REPORTING_POINT 1/25/2013 9:18:40 AM  4532 (0x11B4)

Hi,

is the SQL Server reachable from the SCCM Server, also two ways? Simple but what says ping? DNS is OKAY?

We are working with a administrativ Service Account in AD, the Account doesnt do anything, only connecting between the Servers!

Run it same time or is this a Problem after installation the system?

Try it out and repost.

• Edited by mr. AAJ Friday, January 25, 2013 4:34 PM

Hi:

Windows Firewall is off on both systems.

I can ping the Configuration Manager server from the SQL Server by netbios name, ip address and fully qualified domain name.   I can ping the SQL Server from the Configuration Manager server by netbios name, ip address and fully qualified domain name.

I have uninstalled and installed the Reporting Point Service a couple of times and everything looks fine according to the logs after the install finishes but these errors only appear each time I try and Run a report.

Mark

Yes, I know this is an old post, but Im trying to clean them up. Did you solve this problem, if so what was the solution?

Since no one has answer this post, I recommend opening  a support case with CSS as they can work with you to solve this problem.