Friday, October 14, 2011

SSRS DB is properly working but SSRS webservice url is giving 500 error.

Check event view entry and if u find below entry:-

Message: The current identity (NT AUTHORITY\NETWORK SERVICE) does not have write access to 'C:\Program Files\Microsoft SQL Server\MSRS10.MSSQLSERVER\Reporting Services\RSTempFiles\'.

Solution :- Assign Full Control to NETWORK SERVICE user account for this folder C:\Program Files\Microsoft SQL Server\MSRS10.MSSQLSERVER\Reporting Services\RSTempFiles\