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.

244 questions
0
votes
0 answers

Configure SSRS remotely - A connection to the computer cannot be established

I just installed the newest SQL Server Reporting Services 2017 using this instructions: https://docs.microsoft.com/en-us/sql/reporting-services/install-windows/install-reporting-services?view=sql-server-2017 I have a Windows Server with SQL Server…
gbdavid
  • 101
  • 1
  • 4
0
votes
1 answer

SSRS saved data source prompting for credentials

I have a shared data source in SSRS (SQL 2016) that has Windows credentials saved. I can click on that data source, test connection, and it works fine. However, when I attempt to use that data source in a new report it prompts me for credentials…
Ryan B
  • 3
  • 2
0
votes
1 answer

Unable to get SSRS 2016 to send subscription emails

I'm having an issue with sending reports via email on SSRS 2016 So basically I have a VM on the Azure platform configured as an SQL server. SQL01 (Windows 2012 Server) + SQL SERVER 2008 R2 + SQL SERVER 2016 (+ SSRS) The 2008 instance holds the data…
henda79
  • 151
  • 2
0
votes
1 answer

SSRS Subscription fails, Server Response 4.4.1

I have an SSRS server that processes many subscriptions on a daily basis. I have just become aware of this, so I don't know if it is a new or an old problem, but only one subscription has been failing on a daily basis. The error is: Failure…
JamesTheDev
  • 111
  • 4
0
votes
1 answer

Why does my Microsoft SQL Server Reporting Services 2005 Report Server's Report Manager tell me "Login failed for user" (rsRPCError) after Windows Update to SP2?

I updated an existing SQL Server 2005 Reporting Services instance to SP2 via Windows Update. Now when I hit my Report Manager, I get the message “Login failed for user 'Report Server (Sandbox)'. (rsRPCError)”. “Report Server (Sandbox)” is a SQL…
Woody Zenfell III
0
votes
1 answer

Reporting services with mozilla firefox

Is there any good solution to make Mozilla Firefox display well and work alright with SQL Reporting Serives web application, I am tired of bugs and stacks produced by IE and theri last versions. The most annoying thing is size of displayed report…
adopilot
  • 1,521
  • 6
  • 25
  • 41
0
votes
1 answer

How do I grant Auth to an Application Pool to a seperate server

I have a WebServer running IIS, and hosting a number of Webservices. I have a new requirement to allow a WebService (Currently running as AppPoolIdentity) to connect to SSRS on a seperate server. Right now, if I log onto the webserver and browse to…
Matt
  • 123
  • 5
0
votes
1 answer

Unable to login to stand alone SSRS 2012 from domain joined computers

We have a non-domain joined SQL 2012 server running in Azure supporting several web sites, earlier this week an issue popped up where domain joined computers could not log in. There were no updates or changes applied to the server, no login errors,…
Matt Bear
  • 874
  • 3
  • 12
  • 28
0
votes
1 answer

Which Reporting Services instance is using this ReportServer database?

I have a SQL server - call it A - which I need to decommission. One of the databases on it is ReportServer, so (presumably) there is somewhere a Reporting Services instance which is storing its report definitions etc in here. Can I tell which one…
aucuparia
  • 125
  • 1
  • 6
0
votes
1 answer

SQL Reporting Services 2016 - "Content Manager" predefined role not listed

When assigning system roles to users, I only see "System Administrator" and "System User". I need to add a user with "Content Manager" as a role but do not see this option. SQL Reporting Services 2016 on Windows Server 2016.
Shawn Gradwell
  • 188
  • 1
  • 3
  • 10
0
votes
1 answer

SQL 2008 Reporting Remote Datasource Windows Authentication

I am trying to use Windows Authentication on a SQL Server 2008 Report Server that connects to a 'remote' SQL Server 2008 Enterprise server. If I store the login credentials with the datasource everything works fine. The reports limit what…
jgardner04
  • 298
  • 2
  • 10
0
votes
1 answer

SSRS 2012 ODBC Driver architecture mismatch on remote computer, works locally

I have an SSRS 2012 server (Windows 2012) with Ingres ODBC drivers installed, ODBC entries have been configured in the 32 bit (SysWOW64) ODBC manager. Reports ran locally on the server run without a problem and are speedy. When I run the reports…
dansh
  • 11
  • 5
0
votes
0 answers

Adding a default front page to Reporting Services 2014

I have installed SSRS 2014 on a server, and it works fine. But when a client connects to the server on HTTP/HTTPS, they get a 404 unless they add /Reports to the url. Is there some way I can add a landing page to SSRS, or do I need to send the user…
Morten Nilsen
  • 318
  • 5
  • 15
0
votes
1 answer

Configuring Reporting Services SQL Server 2005 in a failover cluster Windows Server 2003

I have the following scenario: Two machines, say NODE1 and NODE2, have Windows Server 2003 installed in a failover cluster, say CLUSTER. On this cluster SQL Server 2005 was installed successfully, say the virtual server is DATABASE. Then, SSRS 2005…
Vinko Vrsalovic
  • 1,523
  • 2
  • 15
  • 20
0
votes
1 answer

SQL Server- reporting services failed to open in IE after patching

I have SQL 2005 server - 32 bit standard edition. The server has SSAS,SSIS,SSRS and database services. I patched the server to 9.00.4220. We are having problems with reporting services. It starts fine and connects to database (as from activity…
Manjot
  • 333
  • 1
  • 3
  • 17
1 2 3
…
16 17