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

CharlieLor 551 Reputation points

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)
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.
12,600 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,784 questions
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. Lukas Yu -MSFT 5,816 Reputation points

    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.

    0 comments No comments

  2. CharlieLor 551 Reputation points

    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?