Reporting Services: The permissions granted to user are insufficient for performing this operation. (rsAccessDenied)

Reporting Services error:

"The permissions granted to user are insufficient for performing this operation. (rsAccessDenied)"

Need to Grant the user group "Everyone" FULL ACCESS to C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer.

Automated backup in SQL Express

There is no inbuilt support for automated backup in SQL Express, but there is a very powerful and intuitive scrip by Jasper Smith which can do the same work through Windows Scheduler:

http://www.sqldbatips.com/showarticle.asp?ID=27