The tag has no wiki summary.

learn more… | top users | synonyms

0
votes
1answer
146 views

Sharepoint and SSRS report trust relationship ssl/tls secure channel remote certificate is invalid

I have no experience with sharepoint at all. but this is what I observed. I intermittently getting this error message on my sharepoint. could not establish trust relationship for the ssl/tls secure ...
1
vote
1answer
29 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 ...
1
vote
0answers
88 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 ...
0
votes
2answers
389 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
399 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 ...
2
votes
1answer
78 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 ...
0
votes
0answers
32 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
634 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 ...
0
votes
1answer
526 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
0answers
80 views

SRSS Client Print Module must be downloaded every use

I am currently having an issue with SQL Server Reporting Services. Everytime a user clicks the print button for the report, the user must install the ActiveX client print module. The issue is that our ...
1
vote
0answers
135 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
1answer
84 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..... ...
1
vote
1answer
745 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 ...
2
votes
1answer
194 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 ...
0
votes
1answer
48 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
vote
2answers
3k 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
1answer
568 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
votes
1answer
2k 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 ...
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 ...
1
vote
2answers
346 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
1answer
371 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, ...
1
vote
0answers
310 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
100 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
1answer
785 views

How do I diagnose my poorly-performing SQL Reporting Services 2005?

I have a Windows Server 2008 R2 server running MS SQL Server 2005 and SSRS. The server has 48 cores and 128GiB of memory. The IIS worker processes and reportingservicesservice.exe never get over ...
1
vote
0answers
654 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 ...
2
votes
1answer
369 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
0answers
93 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
1answer
245 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 ...
2
votes
2answers
598 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 ...
0
votes
1answer
300 views

How can I get Visual Studio to deploy to SSRS named with CNAME instead of A record?

We have SSRS (SQL Server Report Service) running on an Amazon EC2 instance. It had been named report.foo.com using an A record. Recently we changed it to a CNAME referencing the EC2 public DNS name. ...
0
votes
2answers
2k views

Adding, removing or editing permissions of a user in SSRS 2008 is throwing error “”Response is not well-formed XML

I am totally stumped by a really stubborn problem: When I try to take any action (add, remove, edit) in the Security tab of a report's Properties page on SSRS 2008 UI I get a generic error. All it ...
1
vote
2answers
2k views

Accessing SQL Server Reporting Services by Non-Admin Accounts

When accessing SQL Reporting Services Report Manager through Great Plains 2010, we're getting the following: An error has occurred during report processing. (rsProcessingAborted) Get Online Help ...
1
vote
0answers
966 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
503 views

Date parameter format problem

On a report parameter of data type DateTime, when I select a date using the date picker, it uses my local format (dd/mm/yyyy), but then I get an error that the value is not valid for the data type, ...
0
votes
1answer
372 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
1answer
244 views

MSSSQL: SSRS, SSAS, SSIS edition

How can I know which edition of SSRS, SSAS and SSIS service is installed on a server? Finding database edition is easy but how to find edition for other SQL services? Any help please? Thanks in ...
0
votes
1answer
590 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
492 views

SSRS report font problem on deployed reports

I have created several reports for my SQL Server Reporting Services 2008 SP2 server, using Visual Studio 2008 on my machine. The reports objects all use Arial as their font, in various sizes and ...
1
vote
3answers
1k views

How to make SSRS 2005 run fast in general?

Are there any general rules/tips which we can use to run Sql Server Reporting Services 2005 reports faster? I have been tuning the Tsql behind the reports but does there exist any SSRS specific ...
0
votes
1answer
914 views

How do I automate the deployment of an SSRS 2008R2 server?

I’m trying to write an automated deployment script for SSRS, and I can’t seem to find any information on how to automate the process of configuring the server after a Files-Only installation. I have ...
1
vote
2answers
634 views

Transaction log shipping SQL Server 2005 to 2008

I have a reporting setup with SSRS on our SQL Server 2005 database. Because SQL Server 2008 is not supported by the main program which populates our database we are stuck with 2005 on our production ...
0
votes
1answer
2k views

Configure SSRS 2008 on Windows Server 2008 R2 - Blank Page

I think I have everything set up for reporting services to work. But when I go to the report manager URL it just says "home" at the top, and there are no options to click properties,etc. The page is ...
4
votes
4answers
3k 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 ...
0
votes
1answer
2k 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 ...
0
votes
1answer
188 views

A different interface for the Sql Server Reporting Service?

I have a SQL Server 2005 SQL Reporting Services implementation. It seems that the only way to actually access the reports is for the users to use Internet Explorer. The web page uses an ActiveX ...
1
vote
2answers
573 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
1answer
357 views

SSRS 2008 Resuming from Sleep

Does anyone know a way to prevent SSRS 2008 from sleeping, after not being used for a while (not sure of the time-out) it takes quite a while to wake up, which is causing a timeout issue?
0
votes
1answer
434 views

SSRS/Sharepoint - Reports made in Report Builder not being list in Sharepoint Web Part

I followed the steps here to integrate reporting services with sharepoint in native mode. I made a page in Sharepoint with the report explorer web part and everything is working. The issue is when I ...
1
vote
2answers
231 views

Configure SQL server reportign service to send email

I'm configuring SQL server 2005 reporting server to send emails outside the domain. I have followed the steps outlined at MS but have a question: How can I supply a domain user to connect to the ...