SSRS 2012 reporting services security issue

Question

I'm attempting to set some security and mailing settings on my SSRS server, however I'm getting the following error:

SQL Server Reporting Services

Error

An error occurred within the report server database. This may be due to a connection failure, timeout or low disk condition within the database. (rsReportServerDatabaseError) Get Online Help Procedure or function 'SetPolicy' expects parameter '@PrimarySecDesc', which was not supplied.

Home

Not sure what's going on as SETPOLICY appears to be in my DB as a storedproc....

I believe it to be a problem with the .config files, which were modified in order to get the reports working with anonymous log in, however when that was done, the report manager no longer worked. Is there any way to reset all .config files?

Thanks

Answer 1

The problem was errors in the .config files - reinstalling SSRS 2012 fixed the issue :)

Answer 2

SETPOLICY is related to security. Try to check the tag on your rsreportserver.config file.

Mine looks like this:

<Authentication>
    <AuthenticationTypes>
        <RSWindowsNegotiate/>
        <RSWindowsNTLM/>
    </AuthenticationTypes>
    <EnableAuthPersistence>true</EnableAuthPersistence>
</Authentication>