Questions tagged [ssrs-2008]
The ssrs-2008 tag has no usage guidance.
32
questions
5
votes
4
answers
6k
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 ...
4
votes
2
answers
5k
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 ...
3
votes
2
answers
13k
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 ...
3
votes
1
answer
4k
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
4
answers
11k
views
SSRS 2008: Unable to restore encryption 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 ...
2
votes
1
answer
766
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 ...
2
votes
1
answer
1k
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 ...
2
votes
1
answer
1k
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 ...
2
votes
1
answer
1k
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 ...
1
vote
1
answer
5k
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
1
answer
184
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? ...
1
vote
1
answer
6k
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 ...
1
vote
1
answer
3k
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 ...
1
vote
1
answer
920
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 ...
1
vote
1
answer
434
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 ...
1
vote
1
answer
409
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
2
answers
860
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
1
answer
126
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
2
answers
4k
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
1
answer
460
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
1
answer
281
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
1
answer
1k
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
1
answer
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 ...
0
votes
2
answers
498
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
1
answer
2k
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
0
answers
334
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 ...
0
votes
1
answer
1k
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 ...
0
votes
1
answer
108
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
1
answer
406
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
1
answer
1k
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
1
answer
2k
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 ...
0
votes
1
answer
116
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 ...