Reporting Services Point status message errors.

My Reporting Services Point seems to work OK -all reports are available and run correctly both through the console and via the website. However, I am seeing the following warning in the SMS_SRS_REPORTING_POINT status messages every hour:

"The SQL Reporting Services datasource on Reporting point server "Databaseserver.contoso.com" is missing or has been changed outside of Configuration Manager.  It will be rebuilt based on the RSP configuration."

Here's what I think is causing the issue, but I don't know how to solve it.

The reports database is on the same remote SQL server as my site database. Because these site systems were installed automatically through the SCCM installation process, they show up in the Servers and Site Systems Role without an intranet FQDN. However, when I add the RSP to the database server, it creates a new entry because when manually adding site systems SCCM insists on automatically adding the intranet FQDN. So I now have two separate entries for the same server:

\\DBServer01 - component server, site database server, site system

\\DBServer01.contoso.com - component server, reporting services point, site system

Any thoughts on how to stop these errors?

November 5th, 2013 6:54am

Yes, I know this is an old post, but Im trying to clean them up.

In the past when I have seen this, they will automatically clean themselves up after a few days. (aka up to a week later). Have it clean itself up yet?

Free Windows Admin Tool Kit Click here and download it now
December 29th, 2014 12:40am

Thanks Garth. Yes, it took quite a while, but eventually it stopped showing like that cleaned itself up.

I now just have a single instance showing and the strange messages stopped appearing.

February 2nd, 2015 4:52am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics