November 17, 2016 at 11:41 am
I have a SQL Server 2008 DB Engine and 4 RS instances on a machine. When I open the SSRS Configuration Manager only three SSRS instances are in the drop down menu to make a connection to. All four were working as recently as 11/11. When I look at the RS logs for the instance that is missing, nothing sticks out as being the problem. The report Manager URL returns a 404 File or Directory Not Found message.
Any ideas on what to look for or how to troubleshoot what has happened to this SSRS instance that is no longer working?
November 17, 2016 at 12:42 pm
I found the below in the Windows Application Log.
Service cannot be started. Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The report server has encountered a configuration error. ---> System.Xml.XmlException: The 'SemanticQuery' start tag on line 210 does not match the end tag of 'Extension'. Line 229, position 6.
I came across the answer here:
The issue was that someone had commented out a single line in the config file while trying to address an error related to TERADATA. That left a syntax error in the config file. As soon as I corrected that the SSRS Config Manager again showed the missing instance in the Connection drop down.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply