While dealing with a SQL Server 2005 Reporting configuration, faced multiple issues, below is list of issues and applied fixes along with some useful link to redirect in case freshly setting up SSRS.   Main issue which arises is Authentication, SSRS 2005 authentication is handled via IIS manager, and there are multiple options available for e.g. Integrated Windows authentication, Basic authentication, Anonymous Authentication. Based on security requirement one of these can be setup, easiest one […]

While trying to open Report Manager URL via IE received HTTP STATUS CODE 500 error   In order to troubleshoot further, reporting log files are analyzed present in MSSRS root folder   Log file folder: <driver>:\Program Files\Microsoft SQL Server\MSRS10.MSSQLSERVER\Reporting Services\LogFiles\   Error logged: Error resolution: As per link, this error is because FIPS (Federal Information Processing Standard 140-1) Compliance was enabled and in order to meet certain standards this is required for audits. One option […]