1
vote
1answer
13 views

SSRS Failing with error on App_global.asax

Our SSRS server has started failing. The Logs are currently showing the following error: System.BadImageFormatException: Could not load file or assembly 'file:///C:\Program Files\Microsoft SQL ...
0
votes
1answer
211 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
198 views

SQL Server 2012 Reporting Services need to repair

I had SQL 2012 installed with SSRS. Then I was playing with IIS and deleted (I think) ReportServer aliases and webs Now I need to work with SSRS but can't figure out how to return it back. Service is ...
0
votes
0answers
25 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 ...
3
votes
1answer
379 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 ...
1
vote
0answers
96 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 ...
0
votes
0answers
59 views

Azure SQL Reporting Services - cost and options

At the moment, it costs $119 per month to use Azure SQL Reporting services. We want to make the move to Azure SQL Reporting/SSRS as our reporting capabilities are expected to grow quite dramatically ...
1
vote
1answer
596 views

SQL 2008 Reporting Service SSL certificate chain not trusted

I got a SQL Server 2008 Standard Edition installed on a Server 2008 R2, OS and SQL Server got newest Service Packs and updates installed. The SQL Server is up and running but I cant connect to the ...
0
votes
1answer
45 views

SQL Server with one ethernet output and Webserver with another ethernet output

Scenario: I have one server which is virtualizated using VMWare ESXi. Specs: Windows Server 2008 R2 SQL Server Standard 2012 IIS 7.5 Hosting a MVC and a Webform application (using Reporting ...
-1
votes
1answer
941 views

Licensing SQL Server 2012 Reporting Services w/ SharePoint 2010 [duplicate]

Possible Duplicate: Can you help me with my software licensing issue? Here's my situation: I have 1 VM that is running SharePoint 2010 SP1. I have a different physical server that is ...
2
votes
1answer
334 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
1answer
219 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 ...
0
votes
1answer
307 views

No Reporting Server connect option in SQL Server Management Studio 2008 Express

I'm trying to connect to our SSRS reporting server, but in my local SSMS, the Connect drop-down on Object Explorer only lists Database Engine and SQL Server Compact. I only installed SSMS this week, ...
3
votes
1answer
4k 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" ...
1
vote
2answers
554 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?
1
vote
1answer
975 views

Sharepoint and SSRS Native Integration - Not seeing web parts after cabinet file install

I followed the steps here to set up Sharepoint integration with reporting services (SSRS) using native mode. (i.e., get a report explorer and viewer web parts) However after adding the cabinet file ...
0
votes
1answer
922 views

Why does my Microsoft SQL Server Reporting Services 2005 Report Server's Report Manager tell me “Login failed for user” (rsRPCError) after Windows Update to SP2?

I updated an existing SQL Server 2005 Reporting Services instance to SP2 via Windows Update. Now when I hit my Report Manager, I get the message “Login failed for user 'Report Server (Sandbox)'. ...
0
votes
1answer
561 views

SQL 2008 Reporting Remote Datasource Windows Authentication

I am trying to use Windows Authentication on a SQL Server 2008 Report Server that connects to a 'remote' SQL Server 2008 Enterprise server. If I store the login credentials with the datasource ...
1
vote
2answers
522 views

SSRS 2008 Encryption Key reset after server reboot

I have a development XP (SP2) SQL 2008 box being actively used by developers. When this computer is restarted, the SSRS encryption keys become deactivated and the only way to get SSRS working again is ...
4
votes
4answers
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 ...
1
vote
1answer
4k views

Sql Server Reporting Services stops working after changing service Logon account

Using Sql Server 2008. I am attempting to install Team Foundation Server as a dual server setup (due to one server being the DC.) Part of the installation requirements is that Sql Server Reporting ...
1
vote
2answers
279 views

sql mail and ssrs

Is it possible to attach a report from SSRS as PDF and send using sql mail? the server is MSSQL 2000.
0
votes
1answer
228 views

Any issues with a SSRS 2008 front-end going to a SQL 2005 cluster back-end

We want to install SQL Server Reporting Services 2008 on Server "A" which is not clustered. We want to use Server B to host the Reporting Services databases. Server B is a SQL 2005 cluster in ...
3
votes
2answers
2k 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 ...