PBI RS (May 2021) report URLs changing or changed & Email subscription links (paginated reports)
I had a user point out that the url link that PBI RS inserts at the bottom of an email body does not take them to the report, but rather a variation of the reports' url resulting in a "Not Found HTTP Error 404. The requested resource is not found." error. In looking at the issue closer I found that after upgrading report server to May 2021 version that report urls are changing when the report is accessed. Once the report is accessed by a user, the reports' url is getting "/report/" added to the url. This is where the "Include Link" function for paginated report subscriptions breaks for users. This is new behavior to me, I need to resolve it. Please help.Unable to create a report server database
Hi , I came up with a problem when I was configuring the RS. User does not have permission to perform this action. System.Data.SqlClient.SqlException (0x80131904): User does not have permission to perform this action. 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:667c4b63-22c7-4e0c-9580-c077482f4b8f Error Number:15247,State:1,Class:16 How to fix it? Do I need a db owner or other roles? Thanks in advance!
