The tag has no wiki summary.

learn more… | top users | synonyms

2
votes
1answer
713 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 ...
0
votes
2answers
280 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, ...
3
votes
1answer
1k 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 : ...
0
votes
1answer
73 views

Clustered instance - kerberos double hop woes

We've recently migrated our virtualised SQL databases to a bare metal solution in an active/active cluster. Everything is working great except SQL Reports. Ok, so a rundown of our setup here as it ...
0
votes
1answer
40 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
50 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 ...
0
votes
2answers
3k views

Enable anonymous access to report builder in reporting services 2008

I have a 2008 reporting services server installed on windows 2003 server. I am trying to allow anonymous access to the report builder folder so that my users do not have to select the remember ...
0
votes
0answers
386 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 ...
1
vote
2answers
1k views

Query Execution Failed in Reporting Services reports

I have some reporting services reports that talk to Analysis Services and at times they fail with the following error: An error occurred during client rendering. An error has occurred during report ...
0
votes
1answer
136 views

Change SMTP server for SBS 2011 Self Monitoring Reports

SBS 2011 sends daily/weekly/instant reports from the account SBSMonAcct@. It uses localhost as the SMTP transport as being SBS Exchange is usually installed. I want to use an external SMTP server. ...
0
votes
1answer
469 views

SQL Server Reporting Services Report Builder not starting as RemoteApp

A bunch of Users has been given access to a SQL Server 2008 R2 reporting services instance. Due to a policy the users only may access the services through a Remote Desktop instance. We have handed out ...
0
votes
0answers
26 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 ...
1
vote
3answers
819 views

Could SQL Server 2008 replication be used with NLB to allow unlimited scaling of reporting servers?

We are currently using transactional replication in SQL Server 2008 to keep a secondary reporting server synchronized with a primary database server. This has been working weel and keeps some of the ...
4
votes
0answers
264 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 ...
0
votes
0answers
180 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 ...
2
votes
1answer
348 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 ...
0
votes
1answer
35 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 ...
1
vote
2answers
2k 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 ...
1
vote
3answers
9k 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. ...
0
votes
1answer
224 views

SQL Error When Running My “Find All Unused Packages” in SCCM 2007 Report Console

SQL Error When Running My "Find All Unused Packages" in SCCM 2007 Report Console Asked by: the_ratzenator I am trying to run an SCCM 2007 Report to find all unused Pacakges in my environment and I ...
2
votes
4answers
4k 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 ...
1
vote
0answers
24 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 ...
0
votes
1answer
449 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
596 views

Configuring SQL Report Server to work with Team Foundation Server using Internet URLs

Currently we have SQL 2012 with Reporting Services, Team Foundation Server 2012 and SharePoint Server 2013 on our single Windows Server 2012 machine. We are a small company and we have some developers ...
1
vote
1answer
445 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 ...
0
votes
4answers
62 views

Automated email reports [closed]

I have a VPS with a high loaded website. Are there any automated solutions to send me an email or SMS if my site is not working correctly (for example, web server does not respond or DDoS)?
1
vote
0answers
456 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
108 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
407 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
1answer
74 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 ...
1
vote
0answers
96 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 ...
0
votes
2answers
220 views

Reporting Services 2008 & 2012 side by side

I have installed Sql Server 2008 & 2012 side by side on the same machine, and that's includes the reporting service for each. Both are instances are named instances: MSSQLSERVER2008 and ...
0
votes
1answer
111 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
0answers
297 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 ...
1
vote
3answers
209 views

Logs reporting in a human way

I'm currently working on our IT System to improve it a little bit. I've install set and run a rsyslogd on our servers (Physicals and virtuals), all of them now sending their logs into a database. ...
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
411 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 ...
0
votes
2answers
6k views

Get login prompt for SQL reporting services deployment

Get login prompt for SQL reporting services deployment. I really just want to deploy a report. I have -set my Web Service URL to be "ReportServer" -I have tried several different service accounts. ...
0
votes
1answer
75 views

Can Reporting Services 2008 be installed on an existing web farm?

I have a question regarding whether Reporting Services can be installed on an existing web farm, at least the front end portion. The situation is that we have a limited number of servers available to ...
0
votes
1answer
817 views

Cannot get to configure Kerberos for Reporting Services

Context I am trying to configure Kerberos in the domain for double-hop authentication. So here are the machines and their respective roles: client01: Windows 7 as client dc01: Windows Server 2008 ...
1
vote
1answer
1k views

Reporting Services: Cannot connect to Oracle using Integrated Security

Context I have an Oracle 11g database instance and a SQL Server 2012 instance installed on 2 different servers in the same domain. The Oracle database is configured to accept connection with ...
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
2answers
467 views

Upgrade MS Sql Report Server 08 for Dundas charts

We have ms sql server 2008, however the new dundas charts are not available on the report server. How do I upgrade the report server so it gets the new dundas charts as well. Dundas charts are a part ...
0
votes
1answer
104 views

Cannot resolve cluster resources on EC2?

I have created this cluster on Amazon's EC2 service. I can connect to the sql instance from the first node (there is only one node in the cluster at this time) using the cluster name, so I know that ...
2
votes
1answer
538 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 ...
1
vote
0answers
925 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 ...
0
votes
1answer
175 views

SQL Server reporting services shutting down without log info

Using SQL Server 2008 Reporting services. Finding that the service is shutdown without anything in the windows event log or in SQL Server events. I see the log entry for the service starting when I ...
2
votes
2answers
12k 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 ...
0
votes
1answer
166 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 ...
1
vote
2answers
5k views

rsAccessDenied - SQL server 2008 reporting services

I am running SQL server 2008 developer edition on windows vista home premium. I created a reporting services project that was built successfully in BIDS. When I try to deploy it it gives the following ...