Tips for finding Knowledge Articles

  • - Enter just a few key words related to your question or problem
  • - Add Key words to refine your search as necessary
  • - Do not use punctuation
  • - Search is not case sensitive
  • - Avoid non-descriptive filler words like "how", "the", "what", etc.
  • - If you do not find what you are looking for the first time,reduce the number of key words you enter and try searching again.
  • - Minimum supported Internet Explorer version is IE9
Home  >
article

KB-27811: The service was unable to access the Report Server Web Service URL

Authentication Service ,  

15 April,20 at 09:05 AM

Applies to: All versions of Centrify Infrastructure Services

Problem:

This warning window prompts at the step of specifying SSRS URLs to deploy the Centrify Reports.
User-added image

The SQL server has been configured properly, it is online and port is opened. 

Cause:

Go to this Web Service URL http://hostname:80/ReportServer_SQLInstanceName on the browser directly, below reporting services error is received. 

Invalid object name 'XXXXTempDB.dbo.TempCatalog'. Could not use view or function 'ExtendedCatalog' because of binding errors. 

User-added image
The message means the TempDB 'ReportServer$CENTRIFYSUITETempDB' is missing. 

In Reporting Services, each report server database uses a related temporary database to store session and execution data, cached reports, and work tables that are generated by the report server. Background server processes will periodically remove older and unused items from the tables in the temporary database.
If this temporary database was accidentally deleted or missing then the connection will be blocked.


Resolution: 

Create another temporary database on Reporting Services Configuration Manager. 
User-added image
Link provided as courtesy:
https://social.msdn.microsoft.com/Forums/en-US/e3a9a951-126c-47ca-bf0c-a436b95a2ec2/invalid-object-name-reportservertempdbdbotempcatalog?forum=sqlreportingservices

Still have questions? Click here to log a technical support case, or collaborate with your peers in Centrify's Online Community.