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.

learn more… | top users | synonyms (1)

2
votes
1answer
565 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 ...
2
votes
1answer
621 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
1answer
709 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
1answer
486 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 ...
2
votes
1answer
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 ...
1
vote
1answer
1k 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 ...
1
vote
1answer
811 views

One Way Replication of Oracle 11g to MSSQL 2008R2

We're in the midst of a major LOB system change which will use Oracle 11g, but we need to maintain a LARGE number of existing reports in SSRS. What is a good method to automate a one-way, read-only ...
1
vote
1answer
831 views

Asterisk Call Center Report - Inbound and Outbound Calls

We currently use Asterisk to run our call center which handles incoming calls (both direct dial to extension and queues) as well as a bunch of outbound calls. Up until now, we've used a custom report ...
1
vote
1answer
449 views

Report Server integration mode in SharePoint 2010 farm

I have a SharePoint 2010 farm that consists of four servers - two WFE servers and two app servers. The WFE servers are the only servers that serve requests to the portal (which is behind a load ...
0
votes
1answer
10 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 ...
0
votes
1answer
6 views

SSRS 2012 ODBC Driver 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 ...
0
votes
1answer
196 views

SSRS Report fails with conversion error but runs fine in ssms?

I have an issue with a report that was written before my time (I warn you it's got a lot of code and the error makes no sense). Basically its a stored procedure that creates a table variable and then ...
0
votes
1answer
198 views

SQL Reporting service unable to start after restoring on new hardware

I have a SQL server that the hardware is failing. As a solution we restored the image of the server on a multicore (more less new) server. The problem is that SQL 2000 cannot be started if number of ...
0
votes
1answer
1k views

Configuring external SMTP server on Azure VM - messages staying in queue

I have an external SMTP provider: auth.smtp.1and1.co.uk I am trying to send SQL Server Reporting Services emails via this on an Windows 2012 Azure VM. It is configured sufficiently correctly for ...
0
votes
1answer
66 views

Very extremely weird IIS\Reporting Services permission issue

Server 2012 Standard Reporting Services 2012 I have 2 URLs for my Reporting Services: http://MACHINE-NAME/reportserver https://domain.com/reportserver When using the local url locally everything ...
0
votes
1answer
231 views

Default error page in SSRS 2008

We are using SSRS 2008. Is there a way to show a default error page if there is an error in the Reporting Services? If so how do I go about doing this? Currently getting the following error..... ...
0
votes
1answer
951 views

TFS2012 - Reporting Services Permissions?

I'm currently working through an upgrade of TFS2010 to TFS2012. In our old configuration, TFS, Sharepoint, and Reporting Services were on the same server, with the rest of the DBs on a separate SQL ...
0
votes
1answer
190 views

SQL Server Reporting Services 2008 Subscription is sent to incorrect email address

When using a data driven subscription to return a list of recipients the emails sent out are addressed to username@mail.domain.com instead of username@domain.com. The query in the data driven ...
0
votes
1answer
47 views

Report Server pointing to another Reporting Server

I am trying to configure a public facing Reporting Server, which is actually talking to a private Reporting Server backend. I have established the connections between the two of them, but I cannot ...
0
votes
1answer
171 views

How to configure Reporting server on SQL Server 2008, Windows 7

I want to configure reporting server on sql server 2008.I m using Windows 7 Operating System . I configure reporting manager using Reporting Services Configuration Manager and provide Service ...
0
votes
1answer
212 views

Multiple Reporting Services databases in one instance?

Is it possible to have multiple Reporting Services databases in one MSSQL instance? I have a MSSQL 2008 R2 with RS set to SharePoint Integrated Mode. This RS is in use and can't be changed. I do ...
0
votes
1answer
60 views

Does SQL Server 2008R2 Express come with the reporting services?

I can't find any reference anywhere to it. If so, how do I enable it and access it? The only application that I could find that was related was the Reporting Services Configuration Manager. If ...
5
votes
0answers
1k 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 ...
2
votes
0answers
81 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 ...
1
vote
0answers
12 views

How do I stop SSRS from sending any missed reports when starting the service?

We fired up a test SSRS service that hasn't run for a couple of months. It appears that it has decided to send all reports where it has missed the schedule (so any report that didn't send since it was ...
1
vote
0answers
158 views

SSRS Returning 401 Unauthorised Error when calling web service

We have two web servers that call the SSRS service to query the reports held there. Both servers are set up identically but while one works the other returns a 401 unauthorised exception when trying ...
1
vote
0answers
351 views

Can SharePoint 2013 and Microsoft Dynamics GP 2013 run on the same server?

We have a new Windows 2012 server with SQL Server 2012 and Microsoft Dynamics GP 2013 running on it. I have been asked to install SharePoint 2013 on this server also. I know GP 2013 now uses SSRS for ...
1
vote
0answers
306 views

SSRS reachable by FQDN on local computer, but not from a different computer

I am having trouble getting my SSRS server to successfully cohabitate with IIS, after having to move the server to a different subnet. I have 2 static IPs for that server: .242 is defined explicitly ...
1
vote
0answers
31 views

Can I run sharepoint 2007 native report viewer in synchonous mode?

We are hosting a SharePoint MOSS 2007 environment and installed and use the Native Report Viewer with SSRS 2005. All works fine from the LAN, but from internet, the report viewer displayes a page not ...
1
vote
0answers
135 views

Problems with SSRS and IIS

I'm really not sure where this question would be best asked, so I'm posting this here in an IIS-specific forum, and also over in SQL Server Central for an SSRS-specific audience. The problem that I'm ...
1
vote
0answers
767 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 ...
1
vote
0answers
383 views

Issue with Reporting Services - rsreportserver.config is denied

Error message is 'd:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer\RSReportServer.config' is denied.' I open SSRS configuration and I do see the service as started and ...
1
vote
0answers
128 views

Deploying reports to report server

I posted this question on stackoverflow, but I think it would be better here. I configured SSRS 2008 on a remote server running under Network Service. I can access the report manager from my local ...
1
vote
0answers
918 views

Disable Cache in SSRS 2008 R2

This is a problem that occurs for our IE 8 users (does not happen on IE 9). When rendering a reporting services report IE 8 caches the report so if the data is changed and the user re-runs the report ...
1
vote
0answers
127 views

Login prompt when deploy from visual studio 2008

I have a old project of Sql Server Reports. When I try to deploy Sql Reporting Services from visual studio 2008, vs prompt to a user I don't know. I have access to reporting services configuration ...
1
vote
0answers
124 views

Sharepoint Reports on Mac

When trying to view Sharepoint Reports, Mac users get the error "An unexpected error occurred while connecting to the report server. Verify that the report server is available and configured for ...
1
vote
0answers
1k views

reporting services 2008 R2 shows UAC for printing ActiveX after .NET 4.0 installation

Installed the latest updates on the server. Now every time I try to print from a reporting service website the UAC opens.. I already tried to reduce security within IE9 to the minimum, but with no ...
1
vote
0answers
833 views

TFS Reporting Services Configuration Error - The RPC Server is Unavailable

I'm trying to configure Team Foundation Reporting but without any success. The App Tier and the Data Tier are in separate servers. I guess it's not a port/firewall problem, because I opened port ...
1
vote
0answers
600 views

Problems with Apache Mod_Proxy and Microsoft's ReportViewer's Reserved.ReportViewerWebControl.axd

I've configured an Apache httpd server (v2.2) as a reverse proxy (with SSL) to a Microsoft IIS website running an ASP.NET application with SQL Server Report Services. The proxy mostly works but ...
1
vote
0answers
115 views

SQL Reporting Server Authentication Issue

I have one web server & one DB server (running SQL SERVER 2008). Both the servers are in different domains. The web server is allowed to communicate(the communication takes place internally ...
0
votes
0answers
12 views

How can I change SSRS Service account without losing custom reports?

I have to change the service account for SQL Server Reporting Services (SSRS). However, when I change the service account to a new service account, I lose all the custom reports that were created ...
0
votes
0answers
84 views

Install “Microsoft Report Viewer” on Windows Server 2012 R2

I am attempting to install Microsoft Report Viewer (2015) on a web server. The web server is a Windows Server 2012 R2 (x64) instance. The web server will be running a .NET application that uses the ...
0
votes
0answers
30 views

NTLM Authentication fails on SSRS 2008 R2 across trusted domains

I've got 2 domains that are fully trusted. SSRS is on domain1 and my users are on domain2. Can reach SSRS from D2 without an issue, and use my D1 credentials to authenticate. In SSRS\Reports I ...
0
votes
0answers
14 views

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 ...
0
votes
0answers
40 views

SQL Report Server Subscription PDF Corrupted

I have a SQL Report Server 2012 with subscriptions that emails PDF reports to external users. The report runs once a week, and is about 100 pages long. However, the PDF the users get in their emails ...
0
votes
0answers
73 views

Error on opening SSRS System Setting in SharePoint 2013

I configured SSRS for SharePoint. After creating a Service Application when I opened it and tried to access System Setting or Manage Jobs then I am getting error- Application error when access ...
0
votes
0answers
53 views

Is it possible to redirect a virtual directory to another server but on the same domain?

I have huge problems with IE P3P policy and reporting services. The problem is, our web application runs on the domain https://www.companyname.com more exactly on in the virtual directory ...
0
votes
0answers
40 views

MDX run slower in SSRS than in Management Studio

I have an mdx dataset for a SSRS 2012 report. Running MDX in Management Studio takes 1 sec, but in report it takes 1 minute. This is a critical report and the user want it as fast as possible. I have ...
0
votes
0answers
24 views

RSConfig utility not honoring instance parameter

Background: We are setting up a laptop image for new developers that contains SQL Server Express 2014 with Reporting Services. As a post imaging step, I tried using rsconfig to update the ...
0
votes
0answers
179 views

SSRS 2012 Native Through Apache Proxy

I am trying to find a solution for getting MS SQL Reporting Services working through an Apache proxy. I have been at this about a week now and narrowed down what I can and cannot do quite a bit. I ...