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
3
votes
2 answers

Configure reporting in TFS 2010

I am trying to configure TFS 2010 reporting and have come accross the following error: Failed to add Domain\Development account to the TfsWarehouseDataReader role on the Tfs_Warehouse relational database I have set up reporting service on the…
MrsNezbit
  • 131
  • 3
3
votes
1 answer

Allow anonymous access to SSRS

How could I allow anonymous access to SSRS so that all user can access the reports without asking for a user name and password?
meloi
  • 31
  • 1
  • 1
  • 3
3
votes
3 answers

Risks involved in setting up Kerberos authentication for WSS Reporting Services

We have an established Intranet based on WSS with two front ends and a database. Currently all authentication is NTLM. We have installed Reporting Services In Integration Mode. RS works as long as the web front end that has RS installed on it…
Mesh
  • 213
  • 3
  • 10
3
votes
1 answer

SSRS report "unable to load client print control"

We're using SQL Server 2008 for a (third-party) web app, and they utilise SSRS for reporting. Recently, so I'm assuming this is related in some way to an MS patch, whenever we click on the "print" icon in a report we get an error popup: Message from…
Cylindric
  • 1,127
  • 5
  • 24
  • 45
3
votes
1 answer

Reporting Services 2008 configuration for basic authentication using username and password

I want to configure Reporting Services 2008 to use a custom defined username and password for access. I read that I must set reporting services to do basic authentication : …
Paul
  • 714
  • 2
  • 6
  • 19
3
votes
2 answers

How to move a SQL Server Reporting Services installation to new server?

We just built a new cluster to replace to stand alone BI servers. Its running Windows 2003 x64 and SQL 2005. One instance is already running in production and we're getting ready to move another server's data onto a named instance of this…
sql_noob
  • 41
  • 1
  • 4
3
votes
3 answers

Error configuring SQL Reporting Services 2005 on Windows 7

I've installed SQL Server 2005 with Reporting Services on Windows 7 Ultimate x64 and when I try to configure it when clicking on "Windows Service Identity" I get this error message: There was an error while switching panels. The most likely cause…
Omu
  • 337
  • 2
  • 6
  • 19
3
votes
2 answers

Sending SSRS reports to distribution groups

We have been using 'distribution groups' to send SSRS reports because they are easier to manage, but the reports are not being delivered when 'Senders inside and outside of my organization' is not checked on the distribution group under 'delivery…
MeMario
  • 65
  • 1
  • 7
2
votes
0 answers

Can I use a gMSA for stored credentials in a SSRS data source?

I have an instance of SQL Server 2016 Reporting Services service running under DOMAIN\reporting$ containing a data source that needs to query a database using the stored credential DOMAIN\database$. Unfortunately when I store the gMSA credential and…
Mike
  • 1,271
  • 5
  • 18
  • 31
2
votes
0 answers

Is it possible to limit SSRS authentication to Kerberos only?

We have an instance of SSRS (SQL Server Reporting Services) which uses Kerberos Constrained Delegation to fetch data for its reports from SQL Server on behalf of its users. For this purpose, SSRS was configured to use …
Cat Mucius
  • 155
  • 1
  • 11
2
votes
0 answers

Bizarre SQL SRS error when trying to access SCCM reporting reports

In case this is an X-Y problem, what I'm trying to do is grab logs from SQL Server Reporting Services to tell me who did a couple horrible things in our SCCM environment - 1) deploying a rather large and complex install package to the All Systems…
HopelessN00b
  • 53,795
  • 33
  • 135
  • 209
2
votes
0 answers

Left with 0 client certificates to choose from when moving SSRS service to TLS 1.2

Environment: Reporting Services running on a SQL Server 2008 R2 SP3 installation on a Windows 2008 server with .Net 4.6.1 installed and .Net 3.5 enabled as feature. IIS, database and reporting service all in the local machine (custom login URL in a…
Ignacio Soler Garcia
  • 169
  • 7
2
votes
1 answer

SQL Failover Cluster Clients not updating DNS

I have a multi-subnet SQL Server 2012 failover cluster running on 2 Windows 2012 R2 nodes. The cluster is located on 192.168.1.10 when on NODE A and 192.168.5.10 when running on NODE B. When I look at DNS on the domain, I see 2 A records:…
edgesrazor
  • 41
  • 1
  • 3
2
votes
0 answers

Constrained Delegation between IIS, SQL Server, SSRS and File System

First of all, not sure which site is best suited for this question be it SO, SF or SU so please feel free to suggest migration! I have a requirement to constrain delegation between several machines to enable identity impersonation between different…
Gareth
  • 735
  • 5
  • 10
2
votes
1 answer

Wildcard Domain with Google Analytics

Each user on our website has their own subdomain (e.g. bob.example.com, elephant.example.com) and they get paid for the traffic that they send to this subdomain. How can I wire up Google Analytics so that I can view statistics (views, countries,…
Mark Gladstone
  • 155
  • 1
  • 2
  • 6
1
2
3
…
16 17