Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [ssrs-2008]

32 questions
5
votes
4 answers

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 running and a virtual directory.
Greg_the_Ant
  • 489
  • 7
  • 25
4
votes
1 answer

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 specific reporting role in SSRS2008 (say the…
slugster
  • 203
  • 1
  • 7
  • 12
3
votes
1 answer

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 Configuration Manager Click Connect Clicked Web Services…
Andres Adhi
  • 41
  • 1
  • 4
3
votes
2 answers

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 was with default values. How do you test if your…
Boppity Bop
  • 722
  • 3
  • 11
  • 29
2
votes
1 answer

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 get more data in the same amount of rows? Do you…
Granger
  • 1,150
  • 2
  • 10
  • 26
2
votes
1 answer

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 may or may not apply to both). I am in a situation…
Granger
  • 1,150
  • 2
  • 10
  • 26
2
votes
1 answer

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 the SQL server, the event log has been auditing…
DCNYAM
  • 1,039
  • 7
  • 14
2
votes
1 answer

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 frontend, exported it to Excel, however on PDF…
Gabriel Guimarães
  • 425
  • 5
  • 18
2
votes
4 answers

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 2008 to use this new database. I am not able to…
Manjot
  • 333
  • 3
  • 17
2
votes
1 answer

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 example, we are missing the "Home" folder which…
kd7iwp
  • 151
  • 7
1
vote
1 answer

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 SSRS via Webinterface, every time i will get this…
hub
  • 342
  • 1
  • 4
  • 15
1
vote
1 answer

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 supports local databases. I am trying to connect…
Corey Coogan
  • 111
  • 2
1
vote
1 answer

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? Or is this wishful thinking?
David
  • 439
  • 1
  • 5
  • 17
1
vote
1 answer

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 able to find any way to get informed if there are…
Grubsnik
  • 123
  • 4
1
vote
1 answer

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
Adrian Grigore
  • 1,074
  • 3
  • 21
  • 33
1
2 3