cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
npokhrel
New Member

Assigning Reporting services rights to users

Issue found in Power BI Report Server 
Version: 15.0.2.389
Everything works with the original service account which was used at the time of installation. Now we need to change the service account, while doing this we are getting following error after changing to different service account.
Yes we validated that this new service account is assigned database role of db_owner and RSExecRole.
Same new service account works for MSSQLSERVER and it does not work for PBIRS.

This is the error.

System.Data.SqlClient.SqlException (0x80131904): Windows NT user or group '(null)' not found. Check the name again.
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)

 

Assigning Reproting services rights to users
reporting services rights were not applied properly user may not have appropirate access to reporting services resources.

 

Could anyone please help.

Thanks

Nera

 

1 REPLY 1
naulloa
New Member

Were you able to resolve this issue? I am having the same problem

Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!