question

CharlieLor-4693 avatar image
0 Votes"
CharlieLor-4693 asked LukasYu-msft commented

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

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, Action`1 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(TaskCompletionSource`1 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-generalsql-server-reporting-services
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

LukasYu-msft avatar image
0 Votes"
LukasYu-msft answered


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.
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

CharlieLor-4693 avatar image
0 Votes"
CharlieLor-4693 answered LukasYu-msft commented

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?

· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

I'm trying to connect this SSRS to a Report Server remotely.


SSRS is a Report Server, so I guess you are connecting SQL Server here?

This error above is when I tried to create a Report Server database remotely.

I guess you get this in the Report Server configuration manager? Do you have SQL Server machine and SSRS machine in a same domain, the SSRS Service account must have permission on the SQL Server , that could access and create database.


Does the remote SQL Server has to be a Enterprise or can it be just Standard edition?

No particular requirements , Enterprise or Standard SQL Server both can work.
0 Votes 0 ·