Forum Widgets
Latest Discussions
SSRS error on sign in ERR_UNEXPECTED
Hi All, I have an error coming up when anyone tries signing into our company's Report Server Portal. The error appears for one or two seconds and then the portal starts loading successfully. This is from an Azure VM running Windows Server 2019 Datacenter. Microsoft SQL Server 2019 (RTM) - 15.0.2000.5 (X64). SSRS SQL Server Developer edition 15.0.1102.675. Below are links to log snippets from one of the attempts at signing in. This error occurs for all users and only on sign in, not while trying to run any reports. At the time of testing the issue, there were no other processes running or users running reports. RSHostingService log snippet RSPortal Log snippet Any guidance or tips would be greatly appreciated. Thanks
Reporting Functionality | Power BI paginated Reports| SSRS
Hello, I need to create a report on Power BI paginated report which is similar to SSRS ,where I need to show a report as given below. From the report which I have created got the result as below. Now I need to generate a new column called TestNo column which need to be included in my result shown above. But it should be based on SDIDATAITEMID value which I have shown above. It should give me the values as TestNo 8043366 - 1 8043367 - 2 8043368 - 3 8043369 - 1 8043370 - 1 8043371 - 2 ,.... Likewise.... I can provide more info if someone could help me here.
SSRS Measure aggregation
Hi community, It is my first post, so I'm working with report builder, I have a semantic model on power bi service so the report is live connection. In the model I have the dimensions and measures: dimension: Country, city Measures: stock, orders, avg sell this ultimate is actually: function ( orders , stock ). So in the report I summarized the measures with total. So the Sum function measures are OK, but the avg sell NOT(aggregation) the values are wrong, so which aggregate should be work? if the measure is operation between orders and stock Is it possible to use measures predefined in model? or do I have to make a custom measure in report builder (expression) ? thanks in advance.
Authentication error when refreshing SSRS 2019 report
We are encountering authentication issue when refreshing the report in SSRS web portal. Report Server is configured to run using Virtual Service Account. In the RSReportServer.config file, RSWindowsNTLM authentication type is used. The report is connecting to the data source (internal product) using custom ADO.NET Data Provider. Data source is configured with "As the user viewing the report" credentials. Test connection works. When the user opens the report for the first time, report opens successfully. In our product log, we see that the connection was made using logged on domain user account. When the user refreshes the report after some time (3 minutes), report fails to load due to authentication error. In our product log, we see that the connection was made using service account (machine account of the SSRS server) and authentication fails because the service (machine) account is not allowed to access our product. The same configuration works successfully in SSRS 2016. Not sure why the report in SSRS 2019 is connecting to data source using service account instead of logged on domain user account even though it's configured to use the user account viewing the report. I have experimented with RSWindowsNegotiate and EnableAuthPersistence in RSReportServer.config. The issue still exists. Any help/guidance would be appreciated.Backup and Restore of Native SSRS Site Restores as Sharepoint mode
I tried posting a similar message a couple of days ago but am not seeing it on the forum. As such I am reposting. I have a customer with an SSRS site that was setup with their original Dynamics GP implementation. We are in the process of moving them to a new server and upgrading GP. As part of the switch the reporting services site must also move over. I looked at their current Reporting Services Configuration manager and it showed setup in "Native" mode. But when I restored the database and attempted to set it up on the new server I received a message saying the database was in Sharepoint mode. Is there a way to set it up in Native mode? JG
ODBC driver problem
After changing the Microsoft Access Engine odbc driver from version 14 to version 16, I cannot connect to the excel file. I have a connection as follows: Driver={Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb)};DBQ=path.xlsx;ReadOnly=1;HDR=No; error with this is: ERROR [08004] [Microsoft][ODBC Excel Driver] Too many client tasks When switching to the OLE DB driver I get the error: Unspecified error On the Microsoft Access Engine version everything works fine. SSRS: Version 13.0.7050.2
SSRS - Slow SQL Connection Opening with ActiveDirectory User
Hi Everybody TL;DR: We are facing a problem with very slow SqlConnections (~20sec per connection) from a specific ReportServer to a Microsoft SQL Server and an Analysis Service Instance. Details see below. The current setup: SQL, SSAS and SSRS instances all installed on the same (Windows) server. There are two datasources configured on our SSRS (one connecting to SQL and one connecting to SSAS). The login-credentials for both datasources are configured with the same AD-user. Our problem: The SSRS-Reports are slow to load (it takes up to several minutes to render the report). We have viewed the log file and could see, that the sqlConnection opening takes up to 20 seconds. And that for each connection! On other ReportServers we have installed, it takes only a few milliseconds. It's not only the first call after some standby, but also every subsequent call. We have also made some performance tests for the specific SQL and MDX queries. The queries themselves are fast. Also the connection to the DB via OLEDB-driver (with the same AD-User) is instantaneous. What we have already tried: - During our analysis, we found the SPNs weren't registered. This has since been fixed: still the same poor performance. - We changed the credentials of the SQL-datasource on the ReportServer to a SQL-user: the test connection was now instantaneous. - But since we need an AD-user for the SSAS-datasource, we tried a totally new AD-user and used its credentials for the datasources: still the same poor perfomance. The next step that comes to mind, would be to completely remove and re-install SSRS, but we'd like to avoid this, if it turns out to not improve the situation at all. Are there any other steps that come to mind, we should/could try before a re-install? Thanks in advance for your help, Toby
SSRS SERVER DOESNT CONNECT TO ORACLE DATABASE
hello guys i did migration of the whole machine (ssis ssas ssrs, databases ..) to another machine everything worked fine for me except the ssrs server wouldnt connect to oracle database. the ssrs report works fine in visual studio and retrieve data from oracle correctly but when i deploy the dashboaed in the server doesnt work. and also i figured out that the server wouldnt connect to any other provider (oracle, odbc and oledb). do you have any idea guys ?Navigate to different report from one SSRS Report
Sent by you: I have a Invoice SSRS report, for that I have format(SSRS Report) A, B and C, I want when user looking at format A then user should be able to switch to other format, here format means other report. although it is working fine in visual studio but when i added that report in CRM, it show this error: Details are not available because the subreport is missing. For help adding the subreport to Microsoft Dynamics 365, contact your Microsoft Dynamics 365 administrator.
