Questions tagged [ssrs]
For questions specific to SQL Server Reporting Services.
18
questions
0
votes
1
answer
2k
views
Reporting Service web service endpoint - Could not connect to server: https://site/ReportService2005.asmx
I'm assigned to update reports for SSRS that a coworker designed years ago who has retired.
I review the instruction he left. He created a cmd that uses rs.exe to deploy the reports.
I perform the cmd ...
- 143
0
votes
0
answers
2k
views
Reporting services configuration manager cannot find Report Server instance (SQL server 2008 R2 standard)
I have SSRS and SQL server 2008 running on same server. However sometime I found Reporting services configuration manager cannot find Report Server instance and it is affecting reports.
The only way ...
0
votes
0
answers
510
views
SSRS Error :Could not find stored procedure 'IsSegmentedChunk'
Open SSRS Reports we receive this error (sometimes)
(When opening reports or developing reports)
An error occurred within the report server database. This may be due to a connection failure, timeout ...
1
vote
0
answers
343
views
Culture error when loading subscriptions, SSRS 2016
When attempting to load subscriptions in Sql Reporting Services 2016 users are receiving this error:
Microsoft.ReportingServices.Portal.WebHost!reportserverwebapp!5f!05/31/2019-16:15:48::
e ...
- 11
1
vote
0
answers
51
views
SSRS in SharePoint integrated mode: subscriptions failing
We have a SSRS integrated inside a SharePoint farm. Recently we changed owner of all subscriptions to a different one (a technical account, 'ABC\XYZ'). The subscriptions target either a SharePoint ...
- 11
0
votes
1
answer
243
views
Why is Text Parameter not accepting new value only when default value is blank or NULL?
I have a group of users who need to amend address details pulled in a report before it is printed out. We do not want these amendments to be saved or recorded on CRM.
I have worked out that using ...
1
vote
0
answers
568
views
AZURE_KEY_VAULT provider in SSRS
I've recently set up Always Encryption on an on-prem SQL Server db with the column master key in Azure Key Vault. If I SELECT from the table in SSMS with 'Column Encryption Setting=Enabled' I can read ...
- 11
0
votes
1
answer
16
views
Is it possible to extract some data for users to amend and then use the amended data in the report?
I am using SSRS 2008 r2. I have a group of users that need to amend address details before they are printed from a report in CRM onto a pre-printed form. However we do not want to save these ...
0
votes
1
answer
289
views
Issues with getting .NET 4.7.2 for Visual studio 15.9.11 (professional)
Aim; connect SSRS files to a azure DB with MFA. According to this doc https://docs.microsoft.com/en-us/sql/ssdt/azure-active-directory?view=azuresqldb-current, I should be able to do this with the ...
- 103
0
votes
1
answer
251
views
After installing SQL Server Studio 2017 with Integration and Reporting services, in the Integration Services Catalogs- Create New Catalog shows error
SQL SERVER Management Studio 2017 - The error says "The catalog backup file 'C:\SQL\SHARED\X64\140\DTS\Binn\SSISDBBackup.bak" could not be accessed.
Is this error fixing requires "Integration ...
3
votes
0
answers
583
views
Could not load file or assembly in SSRS 2017
I have Visual Studio 2017 Enterprise installed on Windows 10. In a separate from SSRS solution I created a Visual Basic project named "CustomFunctionsVB". In this project I created a class library "...
- 31
0
votes
1
answer
1k
views
In Power BI Report Server, web service URL is working, web portal URL is not
I had to reinstall Power BI Report Server. I reconnected to the underlying Reportserver database. Since I didn't have a backup of the encryption key, I deleted encrypted content.
At this point if I ...
- 1
-1
votes
1
answer
193
views
What does this error mean and what do I need to do to fix it?
Could not connect to the report server http://utmvti0176/Reports/browse/ASPIREv5Test. Verify that the TargetServerURL is valid and that you have the correct permissions to connect to the report server....
- 1
1
vote
1
answer
811
views
Check Status of All SQL Services
I wanted to List all the SQL Services including Reporting Services.
Wmic service where (PathName like '%Binn\%sql%') get caption, name, startmode, state, PathName, ProcessId
This one will give all ...
- 11
1
vote
1
answer
985
views
SSRS Generating Large Log Files, Filling Drive
I've installed SSRS (v14.0.6681.5121) and configured it with my SQL Server 2017 instance. I noticed that my drive was filling up very quickly and tracked it down to this SSRS log as well as a 200MB ....
- 111
1
vote
2
answers
4k
views
How do I enable both PowerShell Remoting and SPN for SQL Server Reporting?
I have tried this question on Stack Exchange - Database Administrators (https://dba.stackexchange.com/q/129286/51925), but I don't get any responses, so I'll try here.
I'm struggling with remoting ...
1
vote
1
answer
605
views
Sorting in SSRS 2008
I am trying to sort a column from largest value to smallest in SSRS 2008. These values are derived from an expression, not an actual data field. So I am wondering if there is a way to sort this ...
- 43
1
vote
1
answer
3k
views
How to edit SSRS 2008R2 Reports in Visual Studio 2012?
I'm a report writer who's been able to edit/update reports in Visual Studio 2008 (we use SSRS2008R2). I've just installed Visual Studio 2012 and when I go to convert my reports project it's not ...
- 193