The tag has no wiki summary.

learn more… | top users | synonyms

0
votes
0answers
42 views

Cannot login to Reporting Services through SSMS and Reporting Services Configuration manager

I am trying to connect to reporting services through ssms. I am getting a following error: "A connection to the computer cannot be established. Access is denied" I have system administrator/system ...
0
votes
0answers
36 views

Weird issue in RDL on SSRS 2008

I'm the admin for our project's SQL Server 2008, with SSRS Standard Edition. We've encountered 2 issues with one recurring which we suspect it's a bug but we can't find any information on it. These ...
0
votes
0answers
70 views

SMTP on Windows Server 2008

Okay, i know that the built in SMTP server role inside Server 2008 is a little beleaguered; however, using resources here (stackex) and from msft I've worked through the issues I've been able to ...
1
vote
1answer
49 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
68 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
1answer
599 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
135 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
139 views

Separate Database For SQL Server Reports

I have researched this on here (and other sites) quite a bit. I feel like I am missing something simple. So please direct me to another posting or help answer my question. Basically, we have out ...
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 ...
1
vote
1answer
239 views

SSRS Errors “Use Local”, even though I am

I am at a loss. I posted this on SO, but think this is probably a better place. I have searched high and low and don't know what to do. I am running SQL Server Web Edition on Server 2008, which only ...
2
votes
1answer
555 views

Failed Account Logon Events

We have a server running SQL 2008 R1. We have a web server in the DMZ that connects through the firewall to the SQL server and executes SQL Reporting Services reports using a domain user account. On ...
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
1answer
155 views

Using Integration Services to push out changes to cubes

Since our SQL server is Standard edition and cannot do proactive caching, I was wondering if Integration Services can detect changes in a database/table, so it can then process the cube automatically? ...
0
votes
1answer
99 views

Proactive caching can only be deployed to a server running Enterpise or Developer

When deploying cubes and setting Automatic MOLAP to show changes I noticed the message: Proactive caching can only be deployed to a server running Microsoft SQL Server Enterpise Edition or Developer ...
0
votes
2answers
1k 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 ...
0
votes
0answers
701 views

Failure sending mail

we upgraded our exchange server from 2007 to 2010, and have to change our exchange URL in reporting services from "X" to "Y" but we cannot send mail now due to following error : Failure sending ...
1
vote
2answers
3k views

SQL2008. What is URL for SSRS webservice?

I have working SSRS but am trying to access it from C# code using SSRS webservice. From what I know it should be something like http://server/Reports/ReportExecution2005.asmx for SQL2005 if install ...
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
126 views

Issue in configuration of SSRS

Windows Server 2003 R2 with SQL Server 2008 R2: During installation accidentally I selected "instance for Sharepoint server". Now I want to install the SSRS, in fact I installed it, by adding features ...
0
votes
1answer
2k views

Reporting Services 2008 R2 export to PDF embedded fonts not shown

I'm trying to export a report to PDF with a custom font. I have installed a font on the server that hosts Reporting Services 2008 R2, restarted the SSRS service, and sucessfully seen it using the web ...
0
votes
1answer
243 views

SSRS 2008 R2 with SQL Server 2008 (non R2) ReportServer databases

We are moving to a scale out deployment of SSRS 2008 Enterprise with reporting services running on 2 front ends connecting to the "ReportServer" and "ReportServerTempDB" databases on a separate SQL ...
0
votes
1answer
737 views

Automating an SSRS 2008 R2 Report Snapshots and run report with most recent data

I would like to automate a report snapshot, but there is only an option to take a snapshot in the Report History Tab. All the resources I've found suggest I need to go to processing options and select ...
0
votes
1answer
336 views

Best solution for High Availability and SSRS on SQL Server 2008 R2?

I have 2 Physical Servers with SQL Server 2008 R2. – SQL Server 1(Active) & SQL Server 2 (Passive) Web Application is developed using .Net 4.0 Framework. I want to know the best solution to have ...
0
votes
1answer
484 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, ...
1
vote
1answer
190 views

SSRS error reporting and monitoring

We have a SSRS 2008 server running and doing daily reports for us. Sometimes these reports will fail. The reasons for this kind of failure isn't so much of importance, as the fact that I haven't been ...
0
votes
0answers
90 views

What configs are needed to make the NT challenge presented by SSRS 2008 go away?

I have a full MS BI stack (SSRS, SSAS, SSIS, SQL Server - all 2008, Developer edition) running on Windows XP Pro (work requires this OS). If a user is in the administrators group local to the ...
0
votes
1answer
1k views

Report Builder 3.0 unable to access SharePoint Foundation 2010 Report Server

I am having a terrrible time getting this to work. I have configured the SharePoint site and the SQL Servers involved to use Kerberos. That has been confirmed working. I then configured the ...
2
votes
2answers
3k views

SSRS 2008: Unable to restore encrytption key

I have migrated SQL server 2005 database to sql server 2008 using side by side upgrade. I have copied Reportserver and reportservertempdb database across and configured SQl server Reporting services ...
1
vote
1answer
309 views

Does SQL Server 2008 R2 Web edition support CSV and XML export?

Does SSRS in SQL Server 2008 R2 Web edition support CSV and XML export? This info is not included in Microsoft's feature matrix. Thanks, Adrian
1
vote
0answers
562 views

Using Powershell to set user permissions in Reporting Services

Apologies if this appears to be a gimme-teh-codez question, but i'm asking this because i'm a n00b when it comes to Powershell. How do i use Powershell to add a particular domain user or group to a ...
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 ...
3
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 ...
1
vote
2answers
555 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?
2
votes
1answer
765 views

How to show the “Home” folder for SSRS 2008 in SQL Management Studio

I just installed SSRS 2008 on a development server and when I connect to it with SQL Management Studio I do not have all of the items in Object Explorer that I had with our SSRS 2005 installation. For ...
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
100 views

Newbie SSRS install - logon question

I installed SQL Server Express 2008 with Advanced Services on a 64 bit Windows Server 2008 Standalone. I am setting up the Reporting Services with Reporting Services Config. Manager. As far as I can ...