hello, we are planning to update sql server 2014 + reporting services to sql server 2019 + reporting services. both products will be updated. i've been browsing the articles on the matter here in q&a, but i still have a few questions. we're using visual studio 2012 report editor to author the reports running on current rs 2014. can i keep using the visual studio 2012 to author the reports for rs 2019 as well or should i upgrade to visual studio 2019, for example?

in our 2014 sql server, we can run two instances of reporting services. however, in sql server 2019, it seems we're limited to only one instance. how do i combine two or point reporting services to two different reporting databases?

hey, i am using ssrs reporting and facing an weird issue, hope you guys help me out. for creating report i am using visual studio 2019. my report is simple just used grouping in it with totals and subtotals. the issue is when i review the report in tool by clicking the preview button. some of the columns not showing data on some rows. its shows empty space. but the weird thing is when i export to the pdf, excel etc it showing complete data. please let me know why is this happening and how can i resolve this problem. if you see the image above the status and trx number not showing data on some columns. but when i export it will show the complete data please help me out thanks and regards

i would like to understand more on the reporting services folder structure . the webportal and webservice virtual directory is under the root of the reporting service instance root ??

error installing sql server reporting services index was out of range. must be non-negative and less than the size of the collection.parameter name: index error code: 0x80131502 recieved the above error : ssrs error while upgrading the insatnce from sql 2012 to sql 2016. and the ssrs was down as well unable to start .. any idea why the error ?

hi, please may you assist. we have recently migrated to sql 2019 and utilising ssrs 2019 now. we have a custom task in azure devops that was created using powershell reportingservicestools the task removes the current ssrs reporting site and then uploads all the new reports again. we may have up to 5+ reporting sites on 1 database server running ssrs. when 2 or more of the sites deploy at the same time i'm getting the following error on [only] one of the sites requiring a new deployment [error]failed to create item {reportname}.rdl : failed to create catalog item {uploadpathtoreport}.rdl : exception calling "createcatalogitem" with "7" argument(s): "system.web.services.protocols.soapexception: an error occurred within the report server database. this may be due to a connection failure, timeout or low disk condition within the database. ---> microsoft.reportingservices.diagnostics.utilities.reportserverstorageexception: an error occurred within

i am adding the reporting services point to a current branch primary server. the primary uses an sql server 2019 instance located on a windows server 2022 core host. what is the convention for this layout, should sql reporting services be installed on the primary server (which already has iis), or on the database server (which does not seem to be optimal)?

i am a builtin\administrator and can perform everything i need to in reporting services. i have developed a report for use by several users in the following folder structure on reporting services: http://myserver/reports/browse/reports/xyzreports. the users are in a network user group called xyzusers. they have read/write and execute permissions on the necessary objects on sql server. in reporting services i have gone into the security on the xyzreports folder and added the xyzusers group with a role of browser. when the user(s) attempt to executed the report they get the following error: • an error has occurred during report processing.

is it possible to use ssrs web services to export reports in the backend when a ssrs server is not available?

scenario table1 has encrypted data using always encypted, with certificate given only to user1, and reporting services service account serviceaccount1 ssrs is running under serviceaccount1 user1 has access/certificate to table1 serviceaccount1 has impersonation enabled so that reports can connect through and connect to table1 as user1. objective prevent anyone with access to the reporting server/ service account from decrypting the data. my problem even though impersonation is enabled and the users credentials are being used to connect to the database, the certificate has to be installed in the service account's personal vault. therefore anyone accessing the report can view the encrypted data, by creating their own datasource. therefore the security becomes as simple as database security and the encryption piece is now weak. any way to allow only the user being impersonated able to access the certificate and the encrypted data?

i have a report that runs in 2 minutes in visual studio connected to the production database (16k rows, 50 columns), but it takes more than 16 minutes when run by reporting services in production after deployment (i have to cancel each time). both dev and prod boxes have the same cpu and memory assets. also, when i simply run the same sql view in the production database the 16k rows are returned in 20 seconds. what can i do to increase the performance of the report when run by reporting services in production?

microsoft sql server reporting services version 11.0.7507.2 is not allowing me to set the permission on a folder in edge. the drop down will appear in ie 11. is there a setting that will allow this drop down to appear !

hi all, i have two sql server node joined with ag on high availability. and one of the node ssrs services are configured. as expected when we are fail over to another sql node it report services are stop working. so my question is how we can configure it with sql server failover automatic move ssrs instance to another server. i have sql server 2017. can i use same sql server for high availability of ssrs reports?

hi, when i am adding number of report is master list and navigating to the report breadcrumb is not changing in ssrs 2017 example: master list-report1,report2,repor3 when click on the report breadcrumb is not showing the report path.it only shots report parent tab i.e. report\report_folder\report1 it only shows report\report_folder\ please suggest roemesh

i have : 1) a sharepoint 2013 server running on windows server 2012 r2 standard. ssrs reporting 12 (12.0.5000.0) is installed here in native mode. currently the ssrs report uses http, if that makes any difference. 2) an adfs server running windows server 2019 standard. not sure how to check the adfs version. i can reach sharepoint via adfs authentication. currently ssrs reporting is only reachable from within the sp/ssrs server itself. i want it reachable from sharepoint with adfs. is it possible to have ssrs in native mode or must it be in integrated mode?