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
