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.
249
questions
25
votes
4
answers
247k
views
Install SQL CLR types & Report Viewer 2012 on Sql 2008 server
I'm in the process of installing a client's ASP.net site on a Windows Server 2003 box running Sql 2008.
The site uses Report Viewer 2012, but when I attempted to install it on the server, I got the ...
18
votes
4
answers
88k
views
Security Risk? Microsoft-HTTPAPI/2.0
Whilst security vetting our machines, I found that one host was exposing a Microsoft-HTTPAPI/2.0 service over port 80 to the internet.
I'm not familiar with this, but after googling around, I found ...
10
votes
2
answers
5k
views
SQL Server Reporting Services (SSRS) IP Handling on Multi-Instance Servers
Tl;Dr
I have a SQL Server instance (SQLSERVER01-i01) with a dedicated IP address and port (162.xxx.xxx.51:1433) on a multi-instance SQL Server (each SQL Server instance on the Windows Server has its ...
5
votes
7
answers
25k
views
Kerberos Configuration Manager for SQL Server error "unable to access user principal information from the system"
When I launch the Kerberos Configuration Manager for SQL Server and try to connect to the local machine it's on, I am getting the error "Kerberos Configuration Manager for SQL Server error "unable to ...
5
votes
4
answers
6k
views
Windows Server 2008 R2 - How do I change IIS Settings?
I think I've looked through all the menus and control panel and I can't find anything to configure IIS.
I feel like IIS is already installed because SQL Server Reporting services has a webpage ...
5
votes
1
answer
9k
views
Can I share one SPN between two service accounts?
I am running IIS and SQL Reporting Server on the same server. IIS runs as d\acct1 and SSRS is running as d\acct2.
Initially, I registered an SPN HTTP/server.d.com for both d\acct1 and d\acct2 and ...
5
votes
1
answer
4k
views
Why do I get prompted for "Data Source Credentials" when editing a SSRS report for SCCM?
When attempting to add a dataset in Report Builder I am prompted to "Enter Data Source Credentials."
Choosing "Use the current Windows user" fails, and I don't have the password for the specified ...
5
votes
1
answer
923
views
Sharepoint / SSRS subscriptions intermittently not emailing
I am running MOSS with SQL Server 2005 Reporting Services in integrated mode. There are a number of reports that are generated and then output emailed through SharePoint's subscriptions. Sporadically ...
5
votes
0
answers
2k
views
SCCM Reporting - "Report Builder click-once application does not exist on the report server"
I (and my manager) would like to be able to create custom reports in SCCM 2012 SP1 through the Configuration Manager Administrative Console from the comfort of our workstations. Unfortunately, if you ...
5
votes
1
answer
2k
views
SSRS 2008 R2 domain user assigned for role but cannot access
I have SSRS 2008 R2 installed on my server and need to deploy report from Business Intelligence Studio at another computer which is in the same domain and under domain user (non-administrator).
First ...
4
votes
3
answers
40k
views
Can't connect to SSRS Report Manager: Insufficient access
I'm trying to access the report manager, which in my case is located at http://localhost/Reports. When I try to go there I get the following error:
User 'ComputerName\UserName' does not have ...
4
votes
3
answers
3k
views
Domain User Access to SQL Server Reporting Services 2005 on IIS7
What are the required steps to properly allow domain users access to reports via the Reporting Services web site?
I've tried to give domain users access both through the site itself and through ...
4
votes
4
answers
1k
views
Optimal SQL Server Reporting Services setup
I'd like to determine an optimal setup for SQL Server Reporting Services to use as the integrated reporting tool for SaaS web-based applications. All reports are pre-defined, so users pick a report ...
3
votes
1
answer
12k
views
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?
3
votes
1
answer
8k
views
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" ...
3
votes
3
answers
2k
views
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 ...
3
votes
2
answers
1k
views
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 ...
3
votes
2
answers
19k
views
Reporting Services Error 401: Unauthorized
I am trying to setup reporting services on a SQL server 2008 and get this error message when I try to connect to the http://localhost/reports
The request failed with HTTP status 401: Unauthorized.
I ...
3
votes
1
answer
4k
views
SQL Server Report Services Not Configuring
This is kind of Frustrating as I know I am doing everything right, however SQL Server Reporting Services are not configured:
To Configure I did these following steps
Opened Reporting Services ...
3
votes
1
answer
2k
views
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 :
<AuthenticationTypes&...
3
votes
2
answers
3k
views
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 ...
3
votes
2
answers
770
views
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 ...
2
votes
4
answers
11k
views
SSRS 2008: Unable to restore encryption key
I have migrated SQL server 2005 database to sql server 2008 using side by side upgrade. I have copied Reportserver and reportservertempdb database across and configured SQl server Reporting services ...
2
votes
4
answers
8k
views
Is it possible to mirror the SQL Reporting Services databases?
Is it possible to mirror the SQL Server (2005 or 2008) Reporting Services databases (ReportServer, ReportServerTemp)? I have a web site that uses a database that is already mirrored, and it also ...
2
votes
1
answer
4k
views
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 ...
2
votes
2
answers
8k
views
Which Service Account should I use in SSRS?
I'm a newbie in SSRS, so my experiences are limited in this topic. In the SQL Server Configuration Manager, there are several options to set the Service Account. I have the option to either use a ...
2
votes
2
answers
14k
views
Reporting Services 2008: Virtual directories not visible in IIS7
I'm having some problems with Reporting Services on Windows Server 2008 Standard.
I've installed server 2008 as a standalone webserver (with roles/features of an web application server). On top of ...
2
votes
1
answer
10k
views
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 ...
2
votes
1
answer
779
views
What is the difference between the Verbose and Normal setting for ExecutionLogLevel in SSRS 2012?
I cannot find any real documentation on the ExecutionLogLevel setting in SSRS 2012 (which is expected to be the same as it was in SSRS 2008). What changes when you set the setting to "Verbose"? Do you ...
2
votes
3
answers
8k
views
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 ...
2
votes
2
answers
3k
views
Can Microsoft SQL Server Reporting Services connect to an LDAP server other then Active Directory
Can MS SSRS use an LDAP server other then AD for authentication?
Is this an easy configuration or is it digging ones self into a hole?
2
votes
1
answer
1k
views
How can ReportManager use a different port externally than from behind the firewall?
I'm on SSRS 2012 in Native mode. The configuration doesn't seem to have changed much from SSRS 2008, which I upgraded from, so the issue applies to both versions (however, if there's a solution, it ...
2
votes
3
answers
3k
views
Error running Report in SQL Server Reporting Services (SQL Server 2005)
I get an error message " An error has occurred during report processing. Query execution failed for dataset [sprocs name]" when running SSRS report.
The stored procedures for this report can be ...
2
votes
1
answer
2k
views
How to uninstall SQL 2008R2 Reporting Services via the command line?
I am running SSRS 2008R2 x64 on a Windows Server Core 2008 R2 instance. I need to fully uninstall the SSRS instance leaving the DB's in tact. I know this is normally done through the Programs and ...
2
votes
2
answers
691
views
reporting servcies 0x7 KDC_ERR_S_PRINCIPAL_UNKNOWN only on server
I have Reporting Services configured on Windows Server 2008 R2. The reporting services is running under domain account and so its AppPool. I am accessing the site through a custom domain.
The ...
2
votes
2
answers
1k
views
Sharepoint Reports do not work in Firefox
Using SSRS in integrated mode, Reports can be viewed in IE but not in Firefox, Chrome, Safari, etc. They get "An unexpected error occurred while connecting to the report server. Verify that the ...
2
votes
1
answer
1k
views
How to Integrate Sharepoint with Reporting Services in Native Mode?
I'm trying to do something like this but with native mode (less integration).
All of the directions I can find tell you how to set up Sharepoint integrated mode but I need to find out what the steps ...
2
votes
0
answers
2k
views
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$. ...
2
votes
0
answers
332
views
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 ...
2
votes
0
answers
253
views
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 ...
2
votes
0
answers
836
views
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 ...
2
votes
0
answers
816
views
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 ...
2
votes
0
answers
1k
views
SQL Reporting Services Report Manager cannot be accessed by IP on the local computer
I have set up SQL Express 2012 with Advanced Services on a test machine. The requirements are that ReportServer should run on a dedicated IP address and port. So I went to Reporting Services ...
2
votes
1
answer
752
views
Cannot log in to SSRS 2012 using any account
I have installed SQL Sever 2012 along with Reporting Services.
I have configured Reporting Services using the Reporting Services Configuration Manager. It seems like the service is running properly, ...
2
votes
1
answer
779
views
Change to RS 2008R2 configuration stopped IIS site receiving traffic through load balancer (and its still not working after backing it out)
Background
We are testing a pair of Windows 2008 R2 (IIS 7.5) web servers in conjunction with a hardware load balancer (external device) that splits port 80 traffic coming into a Virtual IP between ...
2
votes
1
answer
863
views
SQL Server Reporting Services subscription creation silently fails. No error message is displayed, but the subscription does not get created
I'm trying to set up a subscription for a SSRS report. I have deployed the report to the server and I can view the report in a web browser with no problems. I have tried to reproduce this issue on ...
1
vote
1
answer
5k
views
Can't find IIS manager on SQL Reporting Services 2008 machine to setup FQDN
I've got a machine that I inherited that runs SSRS 2008. I can't seem to find IIS anywhere on this machine, yet it's serving up content over port 80. I look under services and there is no WWW ...
1
vote
2
answers
20k
views
What would cause a 500 Internal Server Error when accessing the Report Manager url in SQL Server Reporting Services 2008 R2?
I'm very new to Reporting Services and I'm not even sure what to ask.
I was given a server where it was installed. I can run the Reporting Services Configuration Manager and connect. However when I ...
1
vote
2
answers
2k
views
Windows Service Log On Tab
I installed a product that said to set the "Log On" user (in the Log On tab in the Service Properties option) as the network user.
The service would not start. I then changed the "Log On" user to ...
1
vote
3
answers
274
views
Open source report framework [closed]
I'm looking for a open source report framework for statistics.
A more detailed explanation is: We have a number of tests running on different servers collecting data (for example, login time) every ...