New security maybe? The Data Source added to the root is not seen on the remote node but the Reports folder is and if I create a Data Source in the Reports folder I can then see them on the remote node. I also have all the menus on the remote node when the Reports folder is selected. ??? _________________________________________________________________________ The portal opens and works on the SSRS server but on a remote server the options are missing. No "New" menu, so I can't add a folder or Data Source. Local: Remote: Not currently on a domain but the same local Admin account is used on all servers and was used for the install and setup. At first I also could not look at Security in the Site settings but they are now there after adding the local account to the security settings but the menu options are still not there. The old system with SQL 2012 SSRS has all the options on the local or remote web page.

Few reports are failing with 'ExcelOpenXML' render format error after rs migration from 2014 to 2016. I made following change to the RS config file so I can use old excel format however some of the reports are using 'ExcelopenXML' format. How can I use both 'Excel' and 'ExcelOpenXML' format so report will be sent out based on render format setup in subscription?

I'm trying to configure SSRS to use email subscription feature. This SSRS server is hosted on AWS and I have an SMTP relay to use. This SMTP relay requires an userid and password to authenticate. I tried SSRS configuration manager and also the config file, but couldnt find how and where to use this user name and password for the relay. I would appreciate if someone can help me with the configurations. The same SMTP relay and account details are working fine when I'm trying to configure the Database email on SQL Server.

how can I create the pie chart that displays the Count of columns with filters like ( Active Paths / Courses / Sections /----- this is my column name )from 4 different tables and combined them in one query?

I have an SSRS Report with a lot of calculations. I have a function with the report that supposed to take care divide by 0 error but I still get the error. The function code is ` Function Divide(Numerator as Double, Denominator as Double) If Denominator = 0 Then Return 0 Else Return Numerator/Denominator End If End Function ` I also have a expression that is `=Code.Divide(ReportItems!Textbox41.Value, Fields!mnypotientalRentTotal.Value)' I have no idea how to fix the divide by 0 error any ideas would be great.

Owing to a ransomware attack on our production server Reporting Services went down. This server was installed few years ago and its been in production for long. We have quite a few reports on this server. It was decided we build a new server and migrate the ReportServer Database. Unfortunately we don't have the Encryption Key. Because the service is down I can't even take the back up now, its too late. I tried backing up the ReportServer and ReportServerTempDB databases and then restoring those to the new servers. Restore went well, I even changed the database from the reporting services configuration manager. But, When I tried to go to the web portal URL, It shows the error , The report server isn't configured properly. Check the report server trace log for details. I found out that logs shows the scale out deployment errors. I believe since I don't have the encryption key file and password I am receiving this error. What can I do to get reporting services up and running...? What should be my approach..? Can I restore the encryption key some how or create a new one with rskeymgmt..? If not then can I delete it (if it is possible) and try to reconfigure all the reports again..? (There are about 350 different reports on this server). Please help.

A stored procedure that updates data in production data tables was written by a very talented staff member (with developer-only rights) and works fine when executed in SSMS. However, the same SP does not run when it is invoked by an SSRS subscription. The subscription was created by and is owned by a manager with System Administrator rights. If this problem is caused by SSRS not recognizing the proper credentials (whatever they may be), how can we change the subscription so that it works? If it's not caused by incorrect authentication or authorization, what might the cause be? Thank you for your responses; they are very much appreciated. The "very talented" reference is a (not-so-obvious) joke and self-reference. SQL SMSS is version 2014, SQL DB Server is 2005, and the SSRS server is...2003. We use the subscription to perform a weekly update to customer records, changing/increasing their credit limit and terms if they are in good standing. The SP and report works fine when invoked directly by either the author or the manager (administrator). But the subscription, created by the manager, does not perform any update in the report's SP. So the question might be, "will a subscription created by the developer work?" Or, "does the authentication to the report's data-source need to be changed?" Or, "how can the SP be changed to permit its invocation from the SSRS subscription?" Or, "if the subscription is using the credentials of the SSRS service, how do we change it?"

Is there a way to audit access given to reports \ folder in SSRS ? Trying to figure out who granted browser access to a user to a specific folder. Thank you.

I'm troubleshooting a SSRS security issue where one user is being denied access, while another user with apparently identical settings is working as expected. I'm seeing "The permissions granted to user 'mydomain\myAccount' are insufficient for performing this operation" in the browser, but curiously NOT seeing the (rsAccessDenied) at the end. Is this indicative of something that can help me troubleshoot the issue?

ERROR: When editing a report in report builder, opening the query editor gives the following error

You have specified integrated security or 
credentials in the connection string for the 
data source, but the data source is configured 
to use a different credential type. To use the values 
in the connection string, you must configure 
the unattended report processing account for the report server.

SETUP: 1. SQL server 14.0.2027.2 (2017) 2. SSRS 14.0.600 .1274 (2017) configured with an **unattended service account** 3. Reporting portal is accessed through active directory login 4. The report uses a shared datasource with this connection string

Server=tcp:xxxxx;Database=yyyy;Integrated Security=true;
Encrypt=SSPI;Connection Timeout=30;MultipleActiveResultSets=True;
Persist Security Info=False;App=SSRS;

5.The Credentials are set to **Without Any Credentials** 6. Setup as documented by MSFT https://learn.microsoft.com/en-us/sql/reporting-services/install-windows/configure-the-unattended-execution-account-ssrs-configuration-manager?view=sql-server-ver15 OBSERVATIONS: 1. Viewing reports and subscriptions work as expected 2. If i set credentials to **As the user viewing the report**, this fixes the issue but breaks subscriptions as they need either stored credentials or no credentials 3. In report builder, doing a **Test Connection** on the data source, returns **Connection created successfully** WORKAROUND: 1. In report builder, changing the datasource from **Use a shared connection or report model** to **Use a connection embedded in my report** with the exact same connection string as above allows the query editor to open. However i have to change it back to the using a shared connection after I make the required edits. The workaround is not ideal for our user base and I would like to fix the underlying issue. Has any one experienced this issue before ?

Just a quick questions regarding DBAs, recently I was asked about the scope of DBA in terms of SSRS and BI, in your experience who handles and maintain/configure your SSRS, is this part of the DBA or Sysadmin. and for Datawarehouse do we need a DBA to develop that or a DW engineer? Thank you for all who will answer.

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.

My question sound stupid but i didn't understand and searching on google didn't helped either. I have a SQL query which i use in SCCM Reporting. I just want to say that my hands are bit tight in SQL and database related stuffs. Below is the SQL query. SELECT top 3 * FROM fn_appdtclientsummarizedstate(dbo.fn_LShortNameToLCID(1033)) acs This is, i get from existing report (SSRS). I checked the SCCM database but this table, views is not there. Hence i can't make the modifications as needed. If you can help me then i would be very grateful. I spent almost 2 days but no luck finding/understanding this query.

Is it possible to used a Windows Managed account to access a file share in a Report subscription? When creating a Windows file share report subscription, on Step 4 - Create a data-driven subscription, I must specify the Username and Password of the account which has access to the file share. Can this be a Windows Managed Account and if so, what do I specify for the password to get the field to validate and allow me to move to the next screen?

can someone please help me so that I can have a job tomorrow. Fairly new at this and I've searched and tried several suggestions on this site to no avail. I made an error in my data driven script and now it's emailing me constantly. It's only a matter of time before our security department comes down on me. I can see the job ID but I don't see the subscription as running under SSMS Job Activity Monitor. I've disabled the job under Subscriptions in SSRS. How can I stop the emails? It's sending batches every second. I can turn off the MSSQLSERVER service and it temporarily stops, likewise I can set the IsSchedulingService in the rsreportserver.config file and it temporarily stops, but what is driving the constant emails? I'm at a loss. Any help appreciated.

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.

I've been using ReportingServicesTools , a powershell tool for managing SSRS to migrate from a 2016 SSRS server to an SSRS 2022 server. Reports came over, datasources came over, yet every report gives this error: The report server cannot process the report or shared dataset. The shared data source 'Name' for the report server is not valid. Browse to the server or site and select a shared data source. (rsInvalidDataSourceReference) If I manually feed the report the DataSource in the Manage menu it works, but there's about 100 reports to do this on. I've used Write-RsFolderContent to upload a bulk download of the reports from the old server. Everything is there except Subscriptions, but every report gives me the same error that the shared Datasource isn't there. The datasources are there, in the same folder path they were on the old server. I restored the encryption key from the old server, still nothing. I'm not sure what happened differently, but I imported reports from this same server to this same new server before without this issue. I had to refresh the set of reports so I imported them all recursively again, and now the datasource error occurs. I also tried this (old) fix updating the datasources table but no dice. USE [ReportServer] GO UPDATE [dbo].[DataSource] SET [Link] = (SELECT TOP 1 [ItemID] FROM [dbo].[Catalog] where name = [dbo].[DataSource].[Name]) WHERE name is not null and link is null Anything I can do to reconnect these reports to their datasources without going the manual way?

I am currently investigating an issue wherein sometimes the SSRS just suddenly stops accepting requests until we do an IISRESET command. This happens after we added an additional processor on the server. No new report is added on that time. Right now we have 2x Quad Core with HT enabled processors. Information in 'sys.dm_os_sys_info' is giving me the correct cpu_count which is 16. However, while looking at the 'ReportServer_XXX.log', I noticed that it's logging incorrect cpu count. w3wp!resourceutilities!1!3/22/2014-14:29:16:: i INFO: Reporting Services starting SKU: Standard w3wp!resourceutilities!1!3/22/2014-14:29:16:: i INFO: Evaluation copy: 0 days left w3wp!resourceutilities!1!3/22/2014-14:29:16:: i INFO: CPU throttling turned on w3wp!resourceutilities!1!3/22/2014-14:29:16:: i **INFO: Running on 127 physical processors, 255 logical processors** I am not certain if this is the cause but either way, how do I correct this issue? The count is way off. Also, on our other server, the ***CPU throttling turned on*** message is not being logged. Could also be this another reason? SSRS is running under this environment: - Windows Server 2003 R2 32-bit (PAE enabled) - SQL Server 2005 SP4 (AWE enabled) - 2xQuad core with HT processors - 64GB memory

I've enable DDL audits on few of our servers, The past two months, Im seeing a weired behavior on a server where we host our reportserver database. I'm seeing lots of drop procedures/view followed by create to same objects. Is this normal or something to worry about? Activates being done by the service account running the mssql service. Attached is a sample of the objects being dropped and recreated. Please advise. Thanks