RSExecRole missing

I have multiple servers and 4 of them have reporting services installed with the ReportServer & ReportServerTempDB databases.

A few days ago I was setting up security for a new login and I found out that the RSExecRole role is missing in my dev server (in the reportserver database). It exists on the ReportServerTempDB, master & msdb databases.

I have found a way to create it on the master & msdb databases on msdn
but it didn't help me creating it on reportserver with all the securibles & properties similar to the other environents I run.

Has anyone encountered this problem before? Can anyone help me with a script and an explanation about this role?

Open "Reporting Services Configuration Manager" --> Database, verify the login under [Current Report Server Database Credential] is one of users in RSExecRole or not, if not, click "Change Credentials" button to change to an user in RSExecRole.

You can also use commnadline utility rsconfig as well http://technet.microsoft.com/en-us/library/ms162837.aspx

Since you wanted the code as well, I have scripted it out for you ....

Edit: I have edited, so that below becomes the full code.

```
/ Object: Schema [RSExecRole] ***/

CREATE SCHEMA [RSExecRole] AUTHORIZATION [RSExecRole]
GO
/* Object: DatabaseRole [RSExecRole] ****

/ CREATE ROLE [RSExecRole] AUTHORIZATION [dbo]
GO

--Security creation script for role RSExecRole

--Add Role To Database

EXEC sp_addrole
@rolename 'RSExecRole'

--Set Object Specific Permissions For Role
GRANT
EXECUTE
ON [dbo].[FindItemsByDataSource]
TO RSExecRole
GRANT
SELECT,INSERT,UPDATE,DELETE,REFERENCES
ON [dbo].[History]
TO RSExecRole
GRANT
EXECUTE
ON [dbo].[FindItemsByDataSet]
TO RSExecRole
GRANT
EXECUTE
ON [dbo].[FindItemsByDataSourceRecursive]
TO RSExecRole
GRANT
EXECUTE
ON [dbo].[GetDBVersion]
TO RSExecRole
GRANT
EXECUTE
ON [dbo].[CreateRole]
TO RSExecRole
GRANT
SELECT,REFERENCES
ON [dbo].[ExtendedCatalog]
TO RSExecRole
GRANT
EXECUTE
ON [dbo].[GetRoles]
TO RSExecRole
GRANT
SELECT,INSERT,UPDATE,DELETE,REFERENCES
ON [dbo].[ConfigurationInfo]
TO RSExecRole
GRANT
SELECT,REFERENCES
ON [dbo].[ExtendedDataSources]
TO RSExecRole
GRANT
EXECUTE
ON [dbo].[DeleteRole]
TO RSExecRole
GRANT
EXECUTE
ON [dbo].[SetKeysForInstallation]
TO RSExecRole
GRANT
EXECUTE
ON [dbo].[ReadRoleProperties]
TO RSExecRole
GRANT
SELECT,INSERT,UPDATE,DELETE,REFERENCES
ON [dbo].[Catalog]
TO RSExecRole
GRANT
EXECUTE
ON [dbo].[GetAnnouncedKey]
TO RSExecRole
GRANT
EXECUTE
ON [dbo].[SetRoleProperties]
TO RSExecRole
GRANT
EXECUTE
ON [dbo].[AnnounceOrGetKey]
TO RSExecRole
GRANT
EXECUTE
ON [dbo].[GetPoliciesForRole]
TO RSExecRole
GRANT
EXECUTE
ON [dbo].[SetMachineName]
TO RSExecRole
GRANT
SELECT,INSERT,UPDATE,DELETE,REFERENCES
ON [dbo].[SubscriptionsBeingDeleted]
TO RSExecRole
GRANT
EXECUTE
ON [dbo].[UpdatePolicy]
TO RSExecRole
GRANT
EXECUTE
ON [dbo].[ListInstallations]
TO RSExecRole
GRANT
EXECUTE
ON [dbo].[SetPolicy]
TO RSExecRole
GRANT
SELECT,INSERT,UPDATE,DELETE,REFERENCES
ON [dbo].[ModelDrill]
TO RSExecRole
GRANT
EXECUTE
ON [dbo].[ListSubscriptionIDs]
TO RSExecRole
GRANT
SELECT,INSERT,UPDATE,DELETE,REFERENCES
ON [dbo].[Segment]
TO RSExecRole
GRANT
EXECUTE
ON [dbo].[SetSystemPolicy]
TO RSExecRole
GRANT
EXECUTE
ON [dbo].[ListInfoForReencryption]
TO RSExecRole
GRANT
EXECUTE
ON [dbo].[SetModelItemPolicy]
TO RSExecRole
GRANT
EXECUTE
ON [dbo].[GetDatasourceInfoForReencryption]
TO RSExecRole
GRANT
EXECUTE
ON [dbo].[UpdatePolicyPrincipal]
TO RSExecRole
GRANT
EXECUTE
ON [dbo].[SetReencryptedDatasourceInfo]
TO RSExecRole
GRANT
SELECT,INSERT,UPDATE,DELETE,REFERENCES
ON [dbo].[ChunkSegmentMapping]
TO RSExecRole
GRANT
EXECUTE
ON [dbo].[UpdatePolicyRole]
TO RSExecRole
GRANT
SELECT,INSERT,UPDATE,DELETE,REFERENCES
ON [dbo].[ModelPerspective]
TO RSExecRole
GRANT
EXECUTE
ON [dbo].[GetSubscriptionInfoForReencryption]
TO RSExecRole
GRANT
EXECUTE
ON [dbo].[GetPolicy]
TO RSExecRole
GRANT
EXECUTE
ON [dbo].[SetReencryptedSubscriptionInfo]
TO RSExecRole
GRANT
EXECUTE
ON [dbo].[GetSystemPolicy]
TO RSExecRole
GRANT
SELECT,INSERT,UPDATE,DELETE,REFERENCES
ON [dbo].[CachePolicy]
TO RSExecRole
GRANT
EXECUTE
ON [dbo].[DeleteEncryptedContent]
TO RSExecRole
GRANT
EXECUTE
ON [dbo].[DeletePolicy]
TO RSExecRole
GRANT
EXECUTE
ON [dbo].[DeleteKey]
TO RSExecRole
GRANT
SELECT,INSERT,UPDATE,DELETE,REFERENCES
ON [dbo].[SegmentedChunk]
TO RSExecRole
GRANT
EXECUTE
ON [dbo].[CreateSession]
TO R

StackExchange Database Administrators Q#36041, answer score: 4