Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [ssrs]

Microsoft's SQL Server Reporting Services (SSRS), which provide "tools and services to help you create, deploy, and manage reports", usually querying MS SQL Server.

Microsoft's SQL Server Reporting Services (SSRS), which provide "tools and services to help you create, deploy, and manage reports", usually querying MS SQL Server.

242 questions
0
votes
1 answer

reporting services 2005 with sql server 2008

Can you have Reporting services running on a SQL 2005 server connect and retrieve data from a SQL 2008 server, both x64 ?
ixul
0
votes
1 answer

SSRS 2019 - Report Builder TLS 1.2 error

I have 2 SSRS 2019 servers, and I'm using Report Builder 15 to connect to SSAS over an OLAP https connection. The connection works fine and I'll able to successfully build a report and get results using the Query Designer tool in Report Builder. …
MikeP
  • 1
0
votes
0 answers

Sending email from SSRS using office365 mailbox Authentication issue

We have been sending scheduled reports from SSRS through Office365 Exchange. We are logging into a "DoNoReply" account using using SMTP basic auth. Since Microsoft is getting rid of SMTP basic auth soon, can I get SSRS to use a more secure…
Eric Logsdon
  • 39
  • 5
0
votes
1 answer

MSSQL reportserver behind web application firewall

Good Morning everyone! First, please just point me in direction, where can I look into documentation. I should get a consultant, but as a DBA, I want to solve this issue by myself. Issue: Management decision is that report server (RS) website…
JoeSQL
  • 1
  • 1
0
votes
1 answer

2016 - 2019 - Wrong SSRS Instance Processing Report Render Request

I have inherited a very weird anomaly in SSRS. A new SSRS instance was created using 2019 and it appears it is using the same ReportServer DB as previous 2016 instance. This may have been done to avoid porting thousands of reports and associated…
Ross Bush
  • 121
  • 5
0
votes
0 answers

Can't login to SSRS (SQL Server Reporting Services) using SSMS (SQL Server Management Studio)

I'm having an issue logging on to my reporting server via SSMS. I use the same hostname\instance found in the reporting server config GUI at the top. This used to work, but I have made some changes recently to support a new SSL cert and now I can…
Arvo Bowen
  • 795
  • 5
  • 15
  • 33
0
votes
2 answers

Enable anonymous access to report builder in reporting services 2008

I have a 2008 reporting services server installed on windows 2003 server. I am trying to allow anonymous access to the report builder folder so that my users do not have to select the remember password option when they login, if they are wanting to…
Rob White
  • 463
  • 8
  • 16
0
votes
2 answers

Reporting Services 2016: Cannot Edit or Upload RDL (Throws Exception and Memory Dump)

I have an SQL Reporting Services 2016 (13.0.5103.6) Standard native instance which won't let me edit Reports (RDLs) with Report Builder 15.0.19611.0 or upload them via the Reports portal, it throws an exception and creates a memory dump. I can still…
Vjz
  • 1
  • 2
0
votes
1 answer

SSRS 2019 not listening on IPv4 Ports, only iPv6

We installed SSRS 2019 on a Windows Server 2016 without any problems and configured it to use URLs with port 80. Accessing those URLs (Service and Portal) via local browser works fine, but trying to access from another server fails. Investigations…
tmoe
  • 103
  • 2
0
votes
1 answer

Configure SSRS to build reports using asp.net core app

I try to build the simplest report with SSRS via asp.net core application. The asp.net core application has windows authentication, and I would like that any domain identified user could generate a report. I downloaded the latest to day SSRS version…
serge
  • 185
  • 1
  • 12
0
votes
2 answers

Reporting Services authentication

Reporting services on my site always asks for username and password. I want to set it as domain users are never asked for username / password so I'll have a single-sign on. The Reports Application in IIS is set to have Windows Authentication.…
Paul
  • 714
  • 2
  • 6
  • 19
0
votes
2 answers

How do we install custom fonts on SSRS in AWS MS SQL hosted on RDS

We are using the new SSRS option on the AWS RDS, we have to install a custom font for a report that we are working on. I have checked the documentation and we notice that there is only option to enable and disable SSRS on MS-SQL RDS, but there is no…
user129615212
  • 11
  • 2
0
votes
1 answer

Recreate encryption Keys in MS-SQL RDS instance on AWS

We are running Microsoft SQL server Standard edition running on AWS RDS, We had recently upgraded from sqlserver-se version 14.00.3223.3.v1 to version 14.00.3281.6.v1 as per the recommendation. We had recently enabled SSRS on the RDS instance , a…
user129615212
  • 11
  • 2
0
votes
1 answer

SQL Reporting Services email subscription configuration

I'm trying to configure a Microsoft SSRS 2014 server to send out emails. As far as I can tell all the settings are correct in RS Configuration Manager, and I can send an email from the server itself using TELNET commands to our SMTP provider (so I…
Potatan
  • 13
  • 6
0
votes
1 answer

SCCM - No Reports Available In The Reporting Section

I am trying to set up the Reporting feature in the SCCM Console (Version 1910) but I can't get anything to appear under the Reports tab - the text 'No Items Found' is displayed instead. I was able to troubleshoot and eradicate a variety of issues…
slickboy
  • 309
  • 2
  • 4
  • 12
1 2 3
…
16
17