Cannot alter the role 'RSExecRole', because it does not exist or you do not have permission.

CharlieLor 451 Reputation points
2021-05-07T13:53:19.683+00:00

I kept getting this error in Report Configuration Manager/Change Database to a remote Report Server database. I'm using a SQL Server Credential instead of Service Credentials.

System.Data.SqlClient.SqlException (0x80131904): Cannot alter the role 'RSExecRole', because it does not exist or you do not have permission.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at Microsoft.ReportingServices.Common.DBUtils.ApplyScript(SqlConnection conn, String script, ICommandWrapperFactory commandWrapper)
at Microsoft.ReportingServices.Common.DBUtils.ApplyScript(String connectionString, String script)
at ReportServicesConfigUI.SqlClientTools.SqlTools.ApplyScript(String connectionString, String script)
ClientConnectionId:3b2a05b4-4463-4170-8285-89e2b88f198c
Error Number:15151,State:1,Class:16

The RSExecRole are both the master, msdb, and ReportServer database. The SQL Server account I'm using also have DB owner on ReportServer DB and member of RSExecRole on both master and msdb.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
8,574 questions
SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,123 questions
No comments
{count} votes

2 answers

Sort by: Most helpful
  1. Lukas Yu -MSFT 5,796 Reputation points
    2021-05-10T09:08:53.777+00:00

    The RSExecRole are both the master, msdb, and ReportServer database.

    Could you elaborate this ?
    master, msdb are system databases, I think they would not be involved into this kind of SSRS server issues.

    No comments

  2. CharlieLor 451 Reputation points
    2021-05-10T14:21:13.847+00:00

    I'm basically trying to install SSRS on a remote machine/box that has no SQL Server installed locally. I'm trying to connect this SSRS to a Report Server remotely. I'm getting various errors regarding connecting as well as creating a new Report Server remotely. This error above is when I tried to create a Report Server database remotely. Do what type of permissions do I need? Does the remote SQL Server has to be a Enterprise or can it be just Standard edition?