I can't figure out how to increase/decrease the space between paragraphs for Textbox content that comes from a placeholder. If I type multiple paragraphs of text directly into a Textbox, the SpaceBefore/SpaceAfter settings control the space between paragraphs as expected. This doesn't work when I have a Textbox with a placeholder that loads multiple paragraphs of text. I see that the placeholder has its own formatting settings, but I don't see one that is equivalent to SpaceBefore/SpaceAfter. It's entirely possible I've misunderstood how each property works. I use SpaceAfter to control space after each line feed/carriage return. I use LineHeight to affect the space between all lines of text. Also, there is no HTML involved. I feel like I must be missing something simple or is this really going to be a challenge, lol?

I need to apply the default settings on SSRS Web Service URL and Web Portal URL, but i need to do it automatically somehow. Is it possible to do it via command line? I have looked through this SSRS documentation from Microsoft, but don't see any option to do that. As per Microsoft, You must write custom code that makes calls into the Report Server WMI provider. There are no command line utilities or script templates for configuring the URLs.

I have two SQL Server 2016 instances (Instance A and Instance B) on the same server. Both instances have SSRS. At one point I upgraded Instance A to SQL Server 2019 but then due to the changes made to SSRS in 2019 I decided to bring Instance A back to 2016. I can connect to Instance A just fine on SQL Server 2016 Reporting Services Configuration Manager but now every time I try to connect to Instance B I receive this error: Report Server WMI Provider error: Invalid namespace. I've done some research and can't find a situation exactly like this. Does anyone know of a fix for this or have an idea of where I could find some more information on the problem? Before I try uninstalling and reinstalling SSRS on Instance B I wanted to see if I could find a fix that didn't require uninstalling and reinstalling.

How can external parameters be passed to a SSRS 2016 mobile report in order to pre-select values / settings for the report? The same scenario is possible for paginated reports as it always was. It's one of the key functionalities. In my scenario I need to integrate the reports into an existing application. So some settings like USERID or LANGUAGE must be passed to the integrated report to initialize it correctly. It's not tolerable to expect a user of the application to choose a language every time he/she runs a report inside of the application... Besides setting parameters for the datasets within the mobile report I could not find any option to take values from external / url...? Any solutions?

I'm still new to ssrs. In my query the color is determined by location. In my query I did ORDER BY [Location], Underwriter. Now this works perfectly fine in my query, but when I run it in SSRS it doesn't sort like in the query. I get this what I would like to do is first group the colors together and & set the underwriters in alphabetical order i.e. Balluka, Bill(light blue) Matanane, Brian(green) Walsh, Daniel(green) Davidson, Christine (pink) Hamilton, Marianne (pink) Karger, Tierney (pink) Marroquin, Melanie (pink) Sylvester, Todd (pink) Hopp, Robert (white) Lohr, Jeff (white) Raskovic, Hanna (white) Now what I tried doing in ssrs was in the design I right clicked underwriter> interactive sorting: tried sorting by underwriter & location but nothing happens when I run it. Please help

TL;DR: How can I link to an SSRS (2016) report by URL, with a parameter in the query-string, AND retain (show) the FULL MENU bar (the top "SSRS chrome" that has the Favorites, Browse, Settings, breadcrumb navigation, etc.). Why: I'm phasing out an old 2008R2 instance by putting a clickable link on the old RDLs to new versions of similar reports in the 2016 instance. When the user has selected/filled-in a parameter value, I obviously want to pass that forward to the new report when possible. I've followed the dox and built the URL like so:

://ssrsInstance/ReportServer/Pages/ReportViewer.aspx?%2fFolder+Name%2fOrder+Line+Details&rs%3aCommand=Render&OrderNo=123456

or, the non-encoded more readable version:

://ssrsInstance/ReportServer/Pages/ReportViewer.aspx?/Folder Name/Order Line Details&rs:Command=Render&OrderNo=123456

This works insofar as it shows the report with the parameter values filled-in, but it does NOT show the top level SSRS menu section, i.e. the branding (logo/title), the Settings/Download/Help buttons in the upper-right, and the Favorites & Browse links in the upper left. I **WANT** this stuff to show up, because it conveys to them that they're in the new reporting system and they can navigate around and find other reports. What else I've tried: just using the 'standard' URL of the report (as in browsing to it from the menu in the new instance), and just appending the parameter to the end, like so:

://ssrsInstance/reports/report/Folder%20Name/Order%20Line%20Details&OrderNo=123456

or, for the non-encoded version:

://ssrsInstance/reports/report/Folder Name/Order Line Details&OrderNo=123456

That gives an "invalid item path" error:

path of the item '/Folder Name/Order Line Details&OrderNo=123456' is not valid. The full path must be less than 260 characters long; other restrictions apply. If the report server is in native mode, the path must start with slash. (rsInvalidItemPath)

And obviously the other (less favorable) option is to simply use that URL **without** the parameter, but that forces the user to have to re-do work (especially in the case of more complex parameter sets and multi-valued params), which would suck. Hope there is a way! Thanks all. :)

I have the following powershell script that downloads all the RDL from a reporting services server . I am not the author to whom I am very thankful. It has been very useful for downloading the RDLs. #note this is tested on PowerShell v2 and SSRS 2008 R2 #marcelo miorelli #23-oct-2018 #How to Download All Your SSRS Report Definitions (RDL files) Using PowerShell #Written by belle #Here’s a short PowerShell script that : #1. Connects to your report server #2. Creates the same folder structure you have in your Report Server #3. Download all the SSRS Report Definition (RDL) files into their respective folders #In addition to backing up your Source Project, your ReportServer database, or good old RSScripter #(see http://sqlserver-indo.org/blogs/mca/archive/2009/03/08/extract-and-transfer-rdl-files-from-ssrs.aspx) #this is just another way you can “backup” or archive your reports. [void][System.Reflection.Assembly]::LoadWithPartialName("System.Xml.XmlDocument"); [void][System.Reflection.Assembly]::LoadWithPartialName("System.IO"); $ReportServerUri = "http://qg-v-sqlrs-pr/Reportserver/Reportservice2005.asmx " #"http://yourreportserver/ReportServer/ReportService2005.asmx "; $Proxy = New-WebServiceProxy -Uri $ReportServerUri -Namespace SSRS.ReportingService2005 -UseDefaultCredential ; #check out all members of $Proxy #$Proxy | Get-Member #http://msdn.microsoft.com/en-us/library/aa225878(v=SQL.80).aspx #second parameter means recursive $items = $Proxy.ListChildren("/", $true) | select Type, Path, ID, Name | Where-Object {$_.type -eq "Report"}; #create a new folder where we will save the files #PowerShell datetime format codes http://technet.microsoft.com/en-us/library/ee692801.aspx #create a timestamped folder, format similar to 2011-Mar-28-0850PM $folderName = Get-Date -format "yyyy-MMM-dd-hhmmtt"; $fullFolderName = "D:\SSRS_Export\" + $folderName; foreach($item in $items) { #need to figure out if it has a folder name $subfolderName = split-path $item.Path; $reportName = split-path $item.Path -Leaf; $fullSubfolderName = $fullFolderName + $subfolderName; if(-not(Test-Path $fullSubfolderName)) { #note this will create the full folder hierarchy } $rdlFile = New-Object System.Xml.XmlDocument; [byte[]] $reportDefinition = $null; $reportDefinition = $Proxy.GetReportDefinition($item.Path); #note here we're forcing the actual definition to be #stored as a byte array #if you take out the @() from the MemoryStream constructor, you'll #get an error [System.IO.MemoryStream] $memStream = New-Object System.IO.MemoryStream(@(,$reportDefinition)); $rdlFile.Load($memStream); $fullReportFileName = $fullSubfolderName + "\" + $item.Name + ".rdl"; #Write-Host $fullReportFileName; $rdlFile.Save( $fullReportFileName); } The problem that I am having on this particular server is that apparently I don't have enough permissions to download reports. I would like to identify where exactly I am lacking permissions. How can I achieve that? Alternatively, how could I list all the permissions in each folder in SSRS? Here is the error message I get: here is the text of the error message:

Exception calling "GetReportDefinition" with "1" argument(s): "The permissions granted to user 'mycompany\MMiorelli' are insufficient for performing this operation. ---> 
Microsoft.ReportingServices.Diagnostics.Utilities.AccessDeniedException: The permissions granted to user 'mycompany\MMiorelli' are insufficient for performing this 
operation."
At line:62 char:5
+     $reportDefinition = $Proxy.GetReportDefinition($item.Path);
+     ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    + CategoryInfo          : NotSpecified: (:) [], MethodInvocationException
    + FullyQualifiedErrorId : SoapException
 
New-Object : Exception calling ".ctor" with "1" argument(s): "Buffer cannot be null.
Parameter name: buffer"
At line:68 char:43
+ ... memStream = New-Object System.IO.MemoryStream(@(,$reportDefinition)); ...
+                 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    + CategoryInfo          : InvalidOperation: (:) [New-Object], MethodInvocationException
    + FullyQualifiedErrorId : ConstructorInvokedThrowException,Microsoft.PowerShell.Commands.NewObjectCommand
 
Exception calling "Load" with "1" argument(s): "Root element is missing."
At line:69 char:5
+     $rdlFile.Load($memStream);
+     ~~~~~~~~~~~~~~~~~~~~~~~~~
    + CategoryInfo          : NotSpecified: (:) [], MethodInvocationException
    + FullyQualifiedErrorId : DotNetMethodException
 
Exception calling "Save" with "1" argument(s): "Invalid XML document. The document does not have a root element."
At line:73 char:5
+     $rdlFile.Save( $fullReportFileName);
+     ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    + CategoryInfo          : NotSpecified: (:) [], MethodInvocationException
    + FullyQualifiedErrorId : DotNetMethodException

I am troubleshooting an error in SSRS we want to alter a subscription and set it to the next 5 min from now, but when it gets there it does not run. other than that, I see these error messages in the reporting services execution logs : > 0-27!4270!07/01/2024-12:54:47:: e ERROR: Throwing > Microsoft.ReportingServices.Diagnostics.Utilities.NotEnabledException: > , > Microsoft.ReportingServices.Diagnostics.Utilities.NotEnabledException: > The requested functionality is not currently enabled.; question: How to enable these diagnostics utilities? I can query the ReportServer database, I see the errors, but not the details:

select r.* 
from reportserver.dbo.ExecutionLog3 r
where status  'rsSuccess'
order by r.TimeStart DESC

when I open the file rsreportserver.config that in my environment lives at C:\Program Files\Microsoft SQL Server\MSRS13.MSSQLSERVER\Reporting Services\ReportServer I can only see the following line related to diagnostics:

I need to update the password for the SSRS Execution account for every 15 days. How can I automate this process using powershell or some other scripting?

SSRS 2016 - Standard Default Settings. Work Horse for Reporting. Some large reports can run 5 hours+. Most reports cannot be optimized/tuned - 3rd party vendor. On occasion noticed procs "WriteLockSession,CreateChunkSegment,ReadChunkSegment" in multiple sessions with millions of reads and writes , and at times Blocking. Noticed these table have over 400k records: SegmentedChunk, ChunkSegmentMapping and Segment. Is there a standard process to clean up these tables (unused data) ,or check these tables for orphan records? Does 400k sound high (like a problem), have other SSRS instances with much lower counts. Restarted SSRS - no change. Shrink db - no change. Index optimization and update stats - regular maintenance.

We have a requirement to design some sort of reporting the status of SQL agent job status for all the sql servers in the org. I am able to do it via querying dmvs in msdb directly for that instance but it holds true only for one server at a time. Meaning if i create an SSRS report, i can filter based on instance name. However the requirement we have that all sql instances, approx 50 should show under a common repository from where we can see the status. For example we can see job failed on how many servers if one wants to view at a given time. I am not sure how real time this would be compared to direct querying but any idea how can this be achieved or any solution already available that i can use or customize? Thanks

We have an SQL Server database engine on the 2016 version. We also have SSRS in the 2016 version. I plan to upgrade the SQL database engine from the 2016 version to the 2017 for it to participate in AG with the 2017 database server. After SQL Database engine upgrades from 2016 to 2017(that has SSRS reporting databases), will SQL 2016 SSRS connect to upgraded SQL 2017 with no issues? We plan to take VM snapshot of the box with SQL 2016 server installed.

The SSRS link works locally and works on some users laptops but not others. Now I have checked, and its not a firewall issue - can access on port 80 from the problematic laptops to the SSRS server. It is not an issue with the proxy as we all have the same proxy settings (I also disabled the proxy completely to test), still the same issue. Permissions are all set correctly, as the users where it works are all in the same active directory groups as the users where it doesn't work (plus it doesn't even load a login prompt which it should do). I have also tried on multiple browsers, which all produce the same error. see error below. Any help or pointers in the right direction to find the issue would be great Thanks

I have a single SSRS server available to me (it's a HA cluster) and am looking for a solution to logically separate dev/stg/prd data that isn't too burdensome to maintain. There is no option to stand up another server or use VMs. One of the original ideas was to use schemas, but I think this would require a set of queries customized for each environment. Ideally, changing the pointer between instances (e.g., from stg to prd) would be quick. For example, if I could just change the connection string without modifying anything else. So, maybe we need to set up additional databases if SSRS supports this. I'm struggling a bit to articulate this point, and I may not even be on the right track. Also, I'm a guy that sometimes works with databases and has a working knowledge (hopefully) of MS SQL/SQL, but I do not have the expertise that comes with time.

One of our report servers is raising errors when trying to reach it from clients computers and works just fine from the actual server. the error is: I found that it was a bug in sql 2016 using this article by Microsoft: https://support.microsoft.com/en-us/help/3172981 I upgraded to SP2 and then upgraded to the last CU update as Microsoft suggested but it still didn't work. 1. Other things i tried that did not work: 2. adding permission from SSRS 3. changing ssrs service user and giving it local admin as well 4. giving permissions from ssms to the service user. 5. looking at event viewer and error log for an error which i didn't see. 6. opening IE as admin 7. compering IE security configuration 8. changing the service from automatic to automtic with delay 9. changing UTC 10. reinstalling the instance installing CU1 for RTM, SP1, SP2.. 11. comparing config file to an sql ssrs 2016 that works 12. comparing IE version with ssrs server that works.. errorlog: appdomainmanager!DefaultDomain!414!08/16/2018-12:22:19:: i INFO: Registering AppDomain: type='ReportServer'; id='3'; Name='ReportServer_MSSQLSERVER_0-1-131788849389917877' appdomainmanager!DefaultDomain!414!08/16/2018-12:22:19:: i INFO: Creating a new AppDomainLifeCycleManagementEntry for AppDomain id '3' appdomainmanager!DefaultDomain!414!08/16/2018-12:22:19:: i INFO: Appdomain STARTED: id='3'; name='ReportServer_MSSQLSERVER_0-1-131788849389917877' appdomainmanager!ReportServer_0-1!414!08/16/2018-12:22:23:: i INFO: RS authentication mode is 4; effective ASP.NET authentication mode is Windows. vdir=/ReportServer. appdomainmanager!DefaultDomain!414!08/16/2018-12:22:23:: i INFO: Appdomain:3 ReportServer_MSSQLSERVER_0-1-131788849389917877 initialized (#1). appdomainmanager!DefaultDomain!414!08/16/2018-12:22:23:: i INFO: SetInitialized AppDomain id '3': initialized = 1 webserver!ReportServer_0-1!414!08/16/2018-12:22:50:: i INFO: Reporting Web Server started library!ReportServer_0-1!414!08/16/2018-12:22:50:: i INFO: SQLDump flags: ReferencedMemory, AllThreads, SendToWatson library!ReportServer_0-1!414!08/16/2018-12:22:50:: i INFO: MiniDump flags: DataSegs, UnloadedModules, ProcessThreadData library!ReportServer_0-1!414!08/16/2018-12:22:50:: i INFO: Dump on: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogExceptionMicrosoft.ReportingServices.Modeling.InternalModelingExceptionMicrosoft.ReportingServices.ReportProcessing.UnhandledReportRenderingException library!ReportServer_0-1!414!08/16/2018-12:22:50:: i INFO: Do not dump on: System.Threading.ThreadAbortExceptionSystem.Web.UI.ViewStateExceptionSystem.OutOfMemoryExceptionSystem.Web.HttpExceptionSystem.IO.IOExceptionSystem.IO.FileLoadExceptionMicrosoft.SharePoint.SPExceptionMicrosoft.ReportingServices.WmiProvider.WMIProviderExceptionSystem.AppDomainUnloadedException library!ReportServer_0-1!414!08/16/2018-12:22:50:: i INFO: Minidump location: C:\Program Files\Microsoft SQL Server\MSRS13.MSSQLSERVER\Reporting Services\Logfiles runningjobs!ReportServer_0-1!414!08/16/2018-12:22:50:: i INFO: Running Requests Scavenger timer enabled: Next Event: 60 seconds. Cycle: 60 seconds runningjobs!ReportServer_0-1!414!08/16/2018-12:22:50:: i INFO: Running Requests DB timer enabled: Next Event: 60 seconds. Cycle: 60 seconds resourceutilities!ReportServer_0-1!414!08/16/2018-12:22:50:: i INFO: Reporting Services starting SKU: Enterprise ui!ReportServer_0-1!414!08/16/2018-12:22:50:: i INFO: Installed SKU: Enterprise edition ui!ReportServer_0-1!414!08/16/2018-12:22:50:: i INFO: Software Usage Metrics not enabled for Enterprise edition library!ReportServer_0-1!414!08/16/2018-12:22:51:: i INFO: Call to GetItemTypeAction(/). User: NT AUTHORITY\SYSTEM. library!ReportServer_0-1!414!08/16/2018-12:22:51:: i INFO: Catalog SQL Server Edition = Enterprise crypto!ReportServer_0-1!414!08/16/2018-12:22:51:: i INFO: Initializing crypto as user: BRIUTNT\vmbi crypto!ReportServer_0-1!414!08/16/2018-12:22:51:: i INFO: Exporting public key crypto!ReportServer_0-1!414!08/16/2018-12:22:52:: i INFO: Importing existing encryption key library!ReportServer_0-1!414!08/16/2018-12:22:52:: i INFO: Entering StreamRequestHandler.ExecuteCommand - Command = library!ReportServer_0-1!414!08/16/2018-12:22:52:: i INFO: Call to ListParentsAction(/). User: NT AUTHORITY\SYSTEM. library!ReportServer_0-1!414!08/16/2018-12:22:52:: i INFO: Call to ListChildrenAction(/, False). User: NT AUTHORITY\SYSTEM. webserver!ReportServer_0-1!414!08/16/2018-12:22:52:: i INFO: Processed folder '/' library!ReportServer_0-1!414!08/16/2018-12:22:52:: i INFO: Exiting StreamRequestHandler.ExecuteCommand - Command = (success) library!ReportServer_0-1!1b1c!08/16/2018-12:27:18:: i INFO: Call to GetItemTypeAction(/). User: NT AUTHORITY\SYSTEM. library!ReportServer_0-1!1b1c!08/16/2018-12:27:18:: i INFO: Entering StreamRequestHandler.ExecuteCommand - Command = library!ReportServer_0-1!1b1c!08/16/2018-12:27:18:: i INFO: Call to ListParentsAction(/). User: NT AUTHORITY\SYSTEM. library!ReportServer_0-1!1b1c!08/16/2018-12:27:18:: i INFO: Call to ListChildrenAction(/, False). User: NT AUTHORITY\SYSTEM. webserver!ReportServer_0-1!1b1c!08/16/2018-12:27:18:: i INFO: Processed folder '/' library!ReportServer_0-1!1b1c!08/16/2018-12:27:18:: i INFO: Exiting StreamRequestHandler.ExecuteCommand - Command = (success) library!WindowsService_0!58!08/16/2018-12:28:52:: i INFO: Call to CleanBatch() library!WindowsService_0!58!08/16/2018-12:28:52:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams, 0 segments, 0 segment mappings, 0 edit sessions. library!WindowsService_0!58!08/16/2018-12:28:52:: i INFO: Call to CleanBatch() ends library!ReportServer_0-1!1838!08/16/2018-12:32:18:: i INFO: Call to GetItemTypeAction(/). User: NT AUTHORITY\SYSTEM. library!ReportServer_0-1!1838!08/16/2018-12:32:18:: i INFO: Entering StreamRequestHandler.ExecuteCommand - Command = library!ReportServer_0-1!1838!08/16/2018-12:32:18:: i INFO: Call to ListParentsAction(/). User: NT AUTHORITY\SYSTEM. library!ReportServer_0-1!1838!08/16/2018-12:32:18:: i INFO: Call to ListChildrenAction(/, False). User: NT AUTHORITY\SYSTEM. webserver!ReportServer_0-1!1838!08/16/2018-12:32:18:: i INFO: Processed folder '/' library!ReportServer_0-1!1838!08/16/2018-12:32:18:: i INFO: Exiting StreamRequestHandler.ExecuteCommand - Command = (success) library!ReportServer_0-1!4a4!08/16/2018-12:37:18:: i INFO: Call to GetItemTypeAction(/). User: NT AUTHORITY\SYSTEM. library!ReportServer_0-1!4a4!08/16/2018-12:37:18:: i INFO: Entering StreamRequestHandler.ExecuteCommand - Command = library!ReportServer_0-1!4a4!08/16/2018-12:37:18:: i INFO: Call to ListParentsAction(/). User: NT AUTHORITY\SYSTEM. library!ReportServer_0-1!4a4!08/16/2018-12:37:18:: i INFO: Call to ListChildrenAction(/, False). User: NT AUTHORITY\SYSTEM. webserver!ReportServer_0-1!4a4!08/16/2018-12:37:18:: i INFO: Processed folder '/' library!ReportServer_0-1!4a4!08/16/2018-12:37:18:: i INFO: Exiting StreamRequestHandler.ExecuteCommand - Command = (success) library!WindowsService_0!2244!08/16/2018-12:38:52:: i INFO: Call to CleanBatch() library!WindowsService_0!2244!08/16/2018-12:38:52:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams, 0 segments, 0 segment mappings, 0 edit sessions. library!WindowsService_0!2244!08/16/2018-12:38:52:: i INFO: Call to CleanBatch() ends library!ReportServer_0-1!1b0!08/16/2018-12:42:18:: i INFO: Call to GetItemTypeAction(/). User: NT AUTHORITY\SYSTEM. library!ReportServer_0-1!1b0!08/16/2018-12:42:18:: i INFO: Entering StreamRequestHandler.ExecuteCommand - Command = library!ReportServer_0-1!1b0!08/16/2018-12:42:18:: i INFO: Call to ListParentsAction(/). User: NT AUTHORITY\SYSTEM. library!ReportServer_0-1!1b0!08/16/2018-12:42:18:: i INFO: Call to ListChildrenAction(/, False). User: NT AUTHORITY\SYSTEM. webserver!ReportServer_0-1!1b0!08/16/2018-12:42:18:: i INFO: Processed folder '/' library!ReportServer_0-1!1b0!08/16/2018-12:42:18:: i INFO: Exiting StreamRequestHandler.ExecuteCommand - Command = (success) library!ReportServer_0-1!1848!08/16/2018-12:47:18:: i INFO: Call to GetItemTypeAction(/). User: NT AUTHORITY\SYSTEM. library!ReportServer_0-1!1848!08/16/2018-12:47:18:: i INFO: Entering StreamRequestHandler.ExecuteCommand - Command = library!ReportServer_0-1!1848!08/16/2018-12:47:18:: i INFO: Call to ListParentsAction(/). User: NT AUTHORITY\SYSTEM. library!ReportServer_0-1!1848!08/16/2018-12:47:18:: i INFO: Call to ListChildrenAction(/, False). User: NT AUTHORITY\SYSTEM. webserver!ReportServer_0-1!1848!08/16/2018-12:47:18:: i INFO: Processed folder '/' library!ReportServer_0-1!1848!08/16/2018-12:47:18:: i INFO: Exiting StreamRequestHandler.ExecuteCommand - Command = (success) appdomainmanager!DefaultDomain!1848!08/16/2018-12:47:59:: i INFO: SetUnloadStarted AppDomain id '3': unloadStarted = 1 appdomainmanager!DefaultDomain!1848!08/16/2018-12:48:29:: i INFO: SetUnloadStarted AppDomain id '3': unloadStarted = 2 webserver!ReportServer_0-1!4a4!08/16/2018-12:48:29:: i INFO: Reporting Web Server stopped appdomainmanager!DefaultDomain!1844!08/16/2018-12:48:34:: i INFO: Unregistering AppDomain id='3' appdomainmanager!DefaultDomain!1844!08/16/2018-12:48:34:: i INFO: Unregistering AppDomain: searching for AppDomain id '3' appdomainmanager!DefaultDomain!1844!08/16/2018-12:48:34:: i INFO: Appdomain:3 ReportServer_MSSQLSERVER_0-1-131788849389917877 unregistered. rshost!rshost!1844!08/16/2018-12:48:34:: i INFO: Application domain type ReportServer statistics: created: 1, unloaded: 1, failed: 0, timed out: 0. library!WindowsService_0!2244!08/16/2018-12:48:52:: i INFO: Call to CleanBatch() library!WindowsService_0!2244!08/16/2018-12:48:52:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams, 0 segments, 0 segment mappings, 0 edit sessions. library!WindowsService_0!2244!08/16/2018-12:48:52:: i INFO: Call to CleanBatch() ends appdomainmanager!DefaultDomain!2010!08/16/2018-12:52:18:: i INFO: Registering AppDomain: type='ReportServer'; id='4'; Name='ReportServer_MSSQLSERVER_0-2-131788867384302225' appdomainmanager!DefaultDomain!2010!08/16/2018-12:52:18:: i INFO: Creating a new AppDomainLifeCycleManagementEntry for AppDomain id '4' appdomainmanager!DefaultDomain!2010!08/16/2018-12:52:18:: i INFO: Appdomain STARTED: id='4'; name='ReportServer_MSSQLSERVER_0-2-131788867384302225' appdomainmanager!ReportServer_0-2!2010!08/16/2018-12:52:20:: i INFO: RS authentication mode is 4; effective ASP.NET authentication mode is Windows. vdir=/ReportServer. appdomainmanager!DefaultDomain!2010!08/16/2018-12:52:20:: i INFO: Appdomain:4 ReportServer_MSSQLSERVER_0-2-131788867384302225 initialized (#2). appdomainmanager!DefaultDomain!2010!08/16/2018-12:52:20:: i INFO: SetInitialized AppDomain id '4': initialized = 1 webserver!ReportServer_0-2!2010!08/16/2018-12:52:26:: i INFO: Reporting Web Server started library!ReportServer_0-2!2010!08/16/2018-12:52:27:: i INFO: SQLDump flags: ReferencedMemory, AllThreads, SendToWatson library!ReportServer_0-2!2010!08/16/2018-12:52:27:: i INFO: MiniDump flags: DataSegs, UnloadedModules, ProcessThreadData library!ReportServer_0-2!2010!08/16/2018-12:52:27:: i INFO: Dump on: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogExceptionMicrosoft.ReportingServices.Modeling.InternalModelingExceptionMicrosoft.ReportingServices.ReportProcessing.UnhandledReportRenderingException library!ReportServer_0-2!2010!08/16/2018-12:52:27:: i INFO: Do not dump on: System.Threading.ThreadAbortExceptionSystem.Web.UI.ViewStateExceptionSystem.OutOfMemoryExceptionSystem.Web.HttpExceptionSystem.IO.IOExceptionSystem.IO.FileLoadExceptionMicrosoft.SharePoint.SPExceptionMicrosoft.ReportingServices.WmiProvider.WMIProviderExceptionSystem.AppDomainUnloadedException library!ReportServer_0-2!2010!08/16/2018-12:52:27:: i INFO: Minidump location: C:\Program Files\Microsoft SQL Server\MSRS13.MSSQLSERVER\Reporting Services\Logfiles runningjobs!ReportServer_0-2!2010!08/16/2018-12:52:27:: i INFO: Running Requests Scavenger timer enabled: Next Event: 60 seconds. Cycle: 60 seconds runningjobs!ReportServer_0-2!2010!08/16/2018-12:52:27:: i INFO: Running Requests DB timer enabled: Next Event: 60 seconds. Cycle: 60 seconds resourceutilities!ReportServer_0-2!2010!08/16/2018-12:52:27:: i INFO: Reporting Services starting SKU: Enterprise ui!ReportServer_0-2!2010!08/16/2018-12:52:27:: i INFO: Installed SKU: Enterprise edition ui!ReportServer_0-2!2010!08/16/2018-12:52:27:: i INFO: Software Usage Metrics not enabled for Enterprise edition library!ReportServer_0-2!2010!08/16/2018-12:52:27:: i INFO: Call to GetItemTypeAction(/). User: NT AUTHORITY\SYSTEM. library!ReportServer_0-2!2010!08/16/2018-12:52:27:: i INFO: Catalog SQL Server Edition = Enterprise crypto!ReportServer_0-2!2010!08/16/2018-12:52:27:: i INFO: Initializing crypto as user: BRIUTNT\vmbi crypto!ReportServer_0-2!2010!08/16/2018-12:52:27:: i INFO: Exporting public key crypto!ReportServer_0-2!2010!08/16/2018-12:52:27:: i INFO: Importing existing encryption key library!ReportServer_0-2!2010!08/16/2018-12:52:27:: i INFO: Entering StreamRequestHandler.ExecuteCommand - Command = library!ReportServer_0-2!2010!08/16/2018-12:52:27:: i INFO: Call to ListParentsAction(/). User: NT AUTHORITY\SYSTEM. library!ReportServer_0-2!2010!08/16/2018-12:52:27:: i INFO: Call to ListChildrenAction(/, False). User: NT AUTHORITY\SYSTEM. webserver!ReportServer_0-2!2010!08/16/2018-12:52:27:: i INFO: Processed folder '/' library!ReportServer_0-2!2010!08/16/2018-12:52:27:: i INFO: Exiting StreamRequestHandler.ExecuteCommand - Command = (success) library!ReportServer_0-2!2290!08/16/2018-12:57:18:: i INFO: Call to GetItemTypeAction(/). User: NT AUTHORITY\SYSTEM. library!ReportServer_0-2!2290!08/16/2018-12:57:18:: i INFO: Entering StreamRequestHandler.ExecuteCommand - Command = library!ReportServer_0-2!2290!08/16/2018-12:57:18:: i INFO: Call to ListParentsAction(/). User: NT AUTHORITY\SYSTEM. library!ReportServer_0-2!2290!08/16/2018-12:57:18:: i INFO: Call to ListChildrenAction(/, False). User: NT AUTHORITY\SYSTEM. webserver!ReportServer_0-2!2290!08/16/2018-12:57:18:: i INFO: Processed folder '/' library!ReportServer_0-2!2290!08/16/2018-12:57:18:: i INFO: Exiting StreamRequestHandler.ExecuteCommand - Command = (success) Any advice?

I have a requirement of migrating my whole SQL Server from SQL Server 2012 to 2016. I have already migrated the database engine part. I have not really worked on SSRS (the reporting part), so I need some assistance there. I will be taking the following steps: 1. I have to backup and restore the ReportServer database and ReportServerTempDB 2. I have to backup and restore the encryption keys 3. I will configure SSRS through Reporting Server Configuration Manager What else should I do to run the reports here on SQL 2016 the same as on SQL 2012? I have heard we have to manually copy some RDL files to new server, etc.

I am planning a migration to 2016 Reporting Services and have noticed a particular problem. On two separate new installs for SSRS 2016 Developer Edition, I am unable to save a subscription to a report. The report was downloaded as RDL from the current 2008 R2 server, then saved to the new 2016 environment. The new server is build 13.0.4466.4. I also installed the same version of SQL onto a second server and have reproduced this problem. All servers are running in Native Mode. Within Report Manager, I am able to view the contents of the report (on-demand). When I try to create a subscription, the web page is stuck with the "Loading...." prompt after I click 'Create subscription'. It does this regardless of the Render Format I choose. I am attempting to deliver via e-mail. I have domain credentials for the SSRS service account configured, and I have put the IP address for the SMTP server in RS Configuration Manager, so I know it is configured for email ok. In the SSRS log file, I see these types of errors at the time I try to create the subscription: library!ReportServer_0-1!2888!03/06/2018-16:19:17:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.NotEnabledException: , Microsoft.ReportingServices.Diagnostics.Utilities.NotEnabledException: The requested functionality is not currently enabled.; extensionfactory!ReportServer_0-1!2888!03/06/2018-16:19:17:: i INFO: Skipped instantiating Report Server PowerBI report server extension. Extension was not enabled. library!ReportServer_0-1!2888!03/06/2018-16:19:17:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.OperationNotSupportedNativeModeException: , Microsoft.ReportingServices.Diagnostics.Utilities.OperationNotSupportedNativeModeException: This operation is not supported on a report server that runs in native mode.; library!ReportServer_0-1!2668!03/06/2018-16:19:18:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.NotEnabledException: , Microsoft.ReportingServices.Diagnostics.Utilities.NotEnabledException: The requested functionality is not currently enabled.; extensionfactory!ReportServer_0-1!2668!03/06/2018-16:19:18:: i INFO: Skipped instantiating Report Server PowerBI report server extension. Extension was not enabled. library!ReportServer_0-1!2bf0!03/06/2018-16:19:18:: i INFO: Call to GetPermissionsAction(/Pre-Migration/Open Activity Report). User: XXXX\xxx. library!WindowsService_0!2518!03/06/2018-16:24:35:: i INFO: Call to CleanBatch() In the Windows Application log, I see these events repeated: (Event ID 137) The Report Server PowerBI extension failed to read its configuration settings from the RSReportServer.config configuration file. The extension is not available to users. PowerBI Integration is not enabled on either of the 2016 servers, and is obviously not a part of the existing 2008 R2 configuration. I do not wish to use this feature. How do I solve this problem and begin to create subscriptions, so I can ultimately migrate all of the reports?

I have created the reports by using SSRS 2016 and Visual Studio 2015. When I build the reports it shows success, then deploying the report to the Target server URL I get the following error: > Microsoft SQL Server Report Designer: > > Could not connect to the report server http://ServerName/ReportServer_InstanceName . > Verify that the TargetServerURL is valid and that you have the correct > permissions to connect to the report server. > > Additional Info: Unable to connect to the Remote server I got the report sever URL from the configured Reporting Services: It's a named instance so I added WEB Server URL as: http://servername/reportserver_instancename and I checked permission all are in place. Is there any reason behind the URL or Permissions issue?

I had an SSRS service account password expire. This is on an Azure Windows server. I've tried the following: - Updating the password caused "The report server can’t access or use the encryption key" - Attempting to delete the key via all the normal methods fails. - Manually deleting the key (keys table) doesn't give me an option to re-create a new one. The only solution I can think of at this point is un-installing and reinstalling SSRS. Is there a better way, or is this approach even likely to work?

I have a SSRS 2016 instance which gives me below error whenever I try to view my existing report subscriptions: > An error has occurred. Something went wrong. Please try again later. Strange thing is subscriptions are working fine and I can even create new subscriptions. It only errors out while viewing subscriptions on report server. When checked in database subscriptions entries are there in the table. This is happening on my PROD environment but not on DEV environment. I tried to replicate this same error in DEV but didn't succeed. Report Server config, policy and web config are same on both PROD and DEV. I am wondering why it is happening only on PROD but not in DEV. Below errors are logged in Report Server logs when this error occurs: Microsoft.ReportingServices.Portal.WebHost!extensionfactory!57!12/20/2019-13:39:30:: e ERROR: Exception caught instantiating Report Server Email report server extension: Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The report server has encountered a configuration error. ---> System.IO.FileNotFoundException: Could not load file or assembly 'ReportingServicesEmailDeliveryProvider' or one of its dependencies. The system cannot find the file specified.. Microsoft.ReportingServices.Portal.WebHost!library!57!12/20/2019-13:39:30:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: Unable to load assembly ReportingServicesEmailDeliveryProvider, Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The report server has encountered a configuration error. ---> System.IO.FileNotFoundException: Could not load file or assembly 'ReportingServicesEmailDeliveryProvider' or one of its dependencies. The system cannot find the file specified. at System.Reflection.RuntimeAssembly._nLoad(AssemblyName fileName, String codeBase, Evidence assemblySecurity, RuntimeAssembly locationHint, StackCrawlMark& stackMark, IntPtr pPrivHostBinder, Boolean throwOnFileNotFound, Boolean forIntrospection, Boolean suppressSecurityChecks) at System.Reflection.RuntimeAssembly.InternalLoadAssemblyName(AssemblyName assemblyRef, Evidence assemblySecurity, RuntimeAssembly reqAssembly, StackCrawlMark& stackMark, IntPtr pPrivHostBinder, Boolean throwOnFileNotFound, Boolean forIntrospection, Boolean suppressSecurityChecks) at System.Reflection.Assembly.Load(AssemblyName assemblyRef) at Microsoft.ReportingServices.Diagnostics.ExtensionClassFactory.LoadAssemblyFromFile(String name) --- End of inner exception stack trace ---; Microsoft.ReportingServices.Portal.WebHost!extensionfactory!57!12/20/2019-13:39:30:: e ERROR: Exception caught instantiating Report Server Email report server extension: Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The report server has encountered a configuration error. ---> System.IO.FileNotFoundException: Could not load file or assembly 'ReportingServicesEmailDeliveryProvider' or one of its dependencies. The system cannot find the file specified.. Microsoft.ReportingServices.Portal.WebHost!reportserverwebapp!57!12/20/2019-13:39:30:: e ERROR: [4ti0n45o]: OData exception occurred: System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.InvalidOperationException: Sequence contains no matching element at System.Linq.Enumerable.First[TSource](IEnumerable1 source, Func2 predicate) at Microsoft.ReportingServices.Portal.Repositories.SystemService.PopulateLocalizedExtensionNames(IPrincipal userPrincipal, List`1 subscriptions) at Microsoft.ReportingServices.Portal.Repositories.CatalogItemRepository.GetSubscriptions(IPrincipal userPrincipal, String itemPath) at Model.ReportRepository.LoadSubscriptions() at Model.Report.get_Subscriptions() at lambda_method(Closure , ReportRepository ) --- End of inner exception stack trace --- at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor) at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments) at System.Delegate.DynamicInvokeImpl(Object[] args) at System.Web.OData.Query.Expressions.SelectExpandBinder.Bind(Object entity) at System.Web.OData.Query.SelectExpandQueryOption.ApplyTo(Object entity, ODataQuerySettings settings, IAssembliesResolver assembliesResolver) at System.Web.OData.Query.ODataQueryOptions.ApplySelectExpand[T](T entity, ODataQuerySettings querySettings) at System.Web.OData.Query.ODataQueryOptions.ApplyTo(Object entity, ODataQuerySettings querySettings) at System.Web.OData.EnableQueryAttribute.ExecuteQuery(Object response, HttpRequestMessage request, HttpActionDescriptor actionDescriptor) at System.Web.OData.EnableQueryAttribute.OnActionExecuted(HttpActionExecutedContext actionExecutedContext) at System.Web.Http.Filters.ActionFilterAttribute.OnActionExecutedAsync(HttpActionExecutedContext actionExecutedContext, CancellationToken cancellationToken) --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at System.Web.Http.Filters.ActionFilterAttribute.d__5.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at System.Web.Http.Filters.ActionFilterAttribute.d__0.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at System.Web.Http.Controllers.ActionFilterResult.d__2.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at System.Web.Http.Controllers.ExceptionFilterResult.d__0.MoveNext(). The above errors tells me that it couldn't find ReportingServicesEmailDeliveryProvider assembly/dll. However I have checked in my Report Server's \bin directory and the ReportingServicesEmailDeliveryProvider.dll already exists and I have also copied it to the public and private assembly folders of Visual Studio. But still the error happens. Also, along with this error I get one more error at the same time in Event Viewer Security log: Log Name: Security Source: Microsoft-Windows-Security-Auditing Date: 20/12/2019 13:39:30 Event ID: 4673 Task Category: Sensitive Privilege Use Level: Information Keywords: Audit Failure User: N/A Computer: Test.corp.com Description: A privileged service was called. Subject: Security ID: Corp\Test Account Name: svctest Account Domain: corp Logon ID: 0x254342CE Service: Server: Security Service Name: - Process: Process ID: 0x2544 Process Name: C:\Program Files\Microsoft SQL Server\MSRS13.MSSQLSERVER\Reporting Services\RSWebApp\Microsoft.ReportingServices.Portal.WebHost.exe Service Request Information: Privileges: SeTcbPrivilege Not sure if these errors are related. Can someone please help in finding the root cause and fix for this issue? The versions in production and development match exactly. SSRS service accounts on both the boxes are administrator on the box. SQL Server: 13.0.4259.0 Answers to questions: > Can you confirm that the time you are seeing the error on the site and the errors you're seeing in the logs are occurring at or around the same time? Timings do match and I get the same error in Microsoft.ReportingServices.Portal.WebHost_%M_%D_%Y_%H_%M_%S.log file of could not load file or assembly whenever I click on subscriptions in SSRS portal. > Can you cross-check your rsreportserver.config files between your DEV and PROD environments? Everything is same between PROD and DEV as far as rsreportserver.config is concerned. In addition to this, I did compare web.config and rssvrpolicy.config as well and both of them do match as well. Also to reproduce the scenario as a test, I replaced entire contents of PROD SSRS bin directory to DEV SSRS bin directory but it was still working in DEV and there were no errors. --- Please let me know if any further details are needed.