The tag has no wiki summary.

learn more… | top users | synonyms

1
vote
2answers
551 views

How do I give a user permission to install Report Builder from Report Manager? (SQL Server 2008)

By default, users do not see the "Report Builder" button on the Report Manager toolbar in SQL Server 2008 (R1). How do I give the user permission to use the Report Builder?
0
votes
2answers
54 views

How can one use Reporting Services against a log shipped database?

Using MS SQL SERVER 2005. I have log shipped the ReportServer database to the secondary server in Standby/Readonly. I seem to be unable to use Reporting Services on the secondary database because it ...
2
votes
1answer
73 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
526 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
325 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
630 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
366 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
479 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
436 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
28 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
194 views

SQL Server 2012 Reporting Services to export CSV

I have an SQL Server 2012 Reporting Services instance, and by default, it can only export to PDF, Excel and Word. Users require CSV export as well. All I found is that there are different extensions, ...
0
votes
1answer
31 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
411 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
63 views

How to data-mine a huge amount of elements

I store a huge amount of reporting elements in a MySQL database. These elements are stored in a simple way : KindOfEvent;FromCountry;FromGroupOfUser;FromUser;CreationDate All these reporting elements ...
0
votes
1answer
98 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
160 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
56 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 ...
0
votes
1answer
91 views

Can I restore a pre-R2 SSRS 2008 database to an R2 instance?

We have an existing SQL Server Reporting Services installation running on a pre-R2 installation of SQL Server (10.0.4000.0). Both the application tier and data tier are on the same machine. I need to ...
0
votes
1answer
204 views

Can't uninstall Reporting Services on SQL 2005 (SBS 2008)

I am running SBS 2008 and have just installed SQL 2008 alongside SQL 2005. My understanding is that the default instance created in SQL 2005 is not needed and only the SBSMONITORING instance is ...
0
votes
1answer
536 views

Reporting Services 2008 SSRS usage metric reporting

We use web trends to track the usage of our web sites, but web trends is currently not capable of reading the logs produced by SSRS 2008. Has anyone figured out a way to modify the file so that web ...
0
votes
1answer
549 views

Error Configuring Reporting Services on Windows Server 2008 R2

I'm installing a TFS2010 with Reporting Services (SQL Server 2008) but I'm getting an error, below are the details and steps I did: I'm installing with a domain account who is also a local ...
4
votes
0answers
240 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 ...
1
vote
0answers
23 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
106 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
359 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
91 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
906 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
572 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
447 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
101 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
174 views

Install RSClientPrint for Reporting Services 2012 using .bat file and still be able to use 2005

I have a Reporting Services 2005 server that when users accessed it and tried to print reports would get a message asking them to install the print control, which they could not do because of lack of ...
0
votes
0answers
24 views

Reporting Services layout changed

I have a new SQL 2012 Reporting Services installation on Server 2008 R2. I logged into the site using Internet Explorer 8 and it is now appearing like this. Does anyone know what is causing this and ...
0
votes
0answers
144 views

Report Builder 2008 R2 error “the data cache for the report edit session is not valid…”

One of my users has reported this error when using Report Builder 2008 R2 to save a report design back to a SSRS 2012 SP1 server. The data cache for the report edit session is not valid. Rerun the ...
0
votes
0answers
125 views

Sporadic server error 502 bad gateway

This is the error message: "502 - Web server received an invalid response while acting as a gateway or proxy server." I already asked in stackoverflow: ...
0
votes
0answers
157 views

SQL Server Report Builder (1.0 / 2.0 / 3.0) - ensure local settings used for page size, date format, etc?

We host a SaaS application that uses SQL Server Reporting Services 2008 (non-R2) for reporting functionality, and our users use a mixture of Report Builder 1.0 and Report Builder 2.0 for designing ...
0
votes
0answers
271 views

SQL Server Reporting authentication not working

I'm not exactly sure what went wrong but our SQL Server Reporting Services authentication is no longer working correctly. When I try to load the site, it asks for a username and password, and mine ...
0
votes
0answers
1k views

ConfigMgr 2012 Reporting Services Point Installation

Here's my setup: ConfigMgr 2012 RTM Windows Server 2008 R2 SP1 Local SQL 2008 R2 SP2 (default instance) Reporting Services native mode I'm trying to install a ConfigMgr 2012 Reporting Services ...
0
votes
0answers
378 views

Trusted Domain Users Can't Access Reports On SSRS 2008 R2

I have setup SSRS2008 on a server in DOMAIN1. Users and groups from DOMAIN1 currently can access reports as expected and in accordance to their site, folder and report permissions. This was working ...