Microsoft's SQL Server Reporting Services (SSRS), which provide "tools and services to help you create, deploy, and manage reports", usually querying MS SQL Server.

learn more… | top users | synonyms (1)

1
vote
1answer
148 views

When integrating SQL Server Reporting Services with SharePoint, does SharePoint have to be installed on the database server that hosts SSRS?

I am configuring SSRS (2008 R2) in SharePoint integrated mode to work with a SharePoint (2010) site that is on another server, do I also have to install SharePoint on the database server that is ...
1
vote
0answers
609 views

Problems with Apache Mod_Proxy and Microsoft's ReportViewer's Reserved.ReportViewerWebControl.axd

I've configured an Apache httpd server (v2.2) as a reverse proxy (with SSL) to a Microsoft IIS website running an ASP.NET application with SQL Server Report Services. The proxy mostly works but ...
0
votes
1answer
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
1answer
901 views

SQL Server Report Builder from Citrix

We would like to allow users accessing the system via citrix to create their own reports using SQL Server Report Builder. Has anyone tried this? Did it work or were there any problems?
0
votes
1answer
831 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
155 views

SQL Server 2008 Reporting Services on Windows 2003

Will SQL Server 2008 Reporting services work if it is install on Windows 2003? Anyone have any experience with this?
0
votes
3answers
780 views

SSRS 2005 inaccessible after install

Hi I've just installed Full SQL 2005, however after I've configured Reporting Services I can't seem to access it. When I go to http://localhost/reports I get this prompt for a username and password ...
1
vote
1answer
153 views

configure the reporting services and/or IIS to give access permission

how to configure the reporting services and/or IIS to give access permission: Reporting Services
0
votes
6answers
426 views

Which open source monitor application for Linux is the best and simplest to use [duplicate]

Possible Duplicate: What tool do you use to monitor your servers? I am currious to know from the community which monitoring applications are the best and simplest to install and use for the ...
0
votes
1answer
817 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, ...
0
votes
1answer
2k views

SQL Server reporting services administrative access

I have a server which has SQL server reporting services installed within it and I need to give permission to a user to administer reporting services/have the content manager role. I however I did not ...
0
votes
2answers
226 views

Automatically set up user's subscription in SSRS

I have a very simple report in SSRS that is just a table with three columns, an object name, client account, and expiration date. In my report, I include a filter by UserID to limit the data to just ...
1
vote
1answer
1k views

Finding what the report subscription error is in SSRS

I've created a simple report in SSRS, and then tried my hand out with a data driven subscription. I can verify that the subscription runs on the 'My Subscriptions' page, but under status it says there ...
0
votes
2answers
414 views

How do I configure my Reporting Services User correctly?

I set up a user on our staging server for the reporting services to use for its required tasks. Or at least I thought I did. I made a couple of grave errors: I did not exempt it from the password ...
1
vote
1answer
101 views

Can't add reporting service component for MS SQL Server 2005

Can't add reporting service component for MS SQL Server 2005 I want to reinstall sql server 2005, all components are disabled when i uninstall sql server 2005. It was bad than before now.
1
vote
2answers
738 views

How do I update the SSRS password configuration using a powershell script

I have about 60-70 machines that may or may not have SSRS. The password just expired for the service accounts that it runs under. Is there a way to script the update password for SSRS?
0
votes
3answers
64 views

How can one use Reporting Services against a log shipped database?

Using MS SQL SERVER 2005. I have log shipped the ReportServer database to the secondary server in Standby/Readonly. I seem to be unable to use Reporting Services on the secondary database because it ...
1
vote
1answer
450 views

Report Server integration mode in SharePoint 2010 farm

I have a SharePoint 2010 farm that consists of four servers - two WFE servers and two app servers. The WFE servers are the only servers that serve requests to the portal (which is behind a load ...
1
vote
0answers
115 views

SQL Reporting Server Authentication Issue

I have one web server & one DB server (running SQL SERVER 2008). Both the servers are in different domains. The web server is allowed to communicate(the communication takes place internally ...
2
votes
2answers
5k 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 ...
1
vote
2answers
7k views

What would cause a 500 Internal Server Error when accessing the Report Manager url in SQL Server Reporting Services 2008 R2?

I'm very new to Reporting Services and I'm not even sure what to ask. I was given a server where it was installed. I can run the Reporting Services Configuration Manager and connect. However when I ...
3
votes
1answer
6k 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
1k views

Setting database option COMPATIBILITY_LEVEL to 100 for database ReportServerTempDB

The error log on my sql server throws this warning every 5 seconds 'Setting database option COMPATIBILITY_LEVEL to 100 for database ReportServerTempDB.' From what I can tell this may be due to my ...
1
vote
2answers
678 views

Windows Service Log On Tab

I installed a product that said to set the "Log On" user (in the Log On tab in the Service Properties option) as the network user. The service would not start. I then changed the "Log On" user to ...
1
vote
1answer
401 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
2k views

SSRS Subscription Fails

Our SSRS server is not executing a subscription correctly. (Only subscription we have btw) We created a subscription to export a report as an excel file to the file system. Tried running the job ...
0
votes
1answer
781 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
1k views

Configuration Error: Could not load Authentication extension

I messed up my SSRS2008 Express' configuration I'm afraid. I tried to enable anonymous access, using different methods I found on the net, so users would be able to just open the (non-IE) browser ...
0
votes
1answer
190 views

MS Reporting Services

We are setting up a two MS 2008 servers to handle our web application. On server A, we are running MS SQL 2008 Web Edition with our database. On server B, we are running IIS, MS SQL 2008 Web Edition ...
0
votes
1answer
721 views

Error Configuring Reporting Services on Windows Server 2008 R2

I'm installing a TFS2010 with Reporting Services (SQL Server 2008) but I'm getting an error, below are the details and steps I did: I'm installing with a domain account who is also a local ...
0
votes
1answer
705 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
1k 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
3answers
864 views

Could SQL Server 2008 replication be used with NLB to allow unlimited scaling of reporting servers?

We are currently using transactional replication in SQL Server 2008 to keep a secondary reporting server synchronized with a primary database server. This has been working weel and keeps some of the ...
0
votes
1answer
151 views

SQL Distributed Reporting Services Setup

I am setting up two servers; one iis 7 and one sql 2008. I need to use reporting services. What is the best way to set up reporting services so that my iis box can serve the reports. I'm sure this ...
0
votes
3answers
756 views

Migrate reports from MS Access to OOo Base

I'm currently looking at upgrading our office machines from Office XP to Office 2010. For most users the standard edition is fine but just a few of us use Access. There are only a couple of standalone ...
1
vote
3answers
250 views

Open source report framework [closed]

I'm looking for a open source report framework for statistics. A more detailed explanation is: We have a number of tests running on different servers collecting data (for example, login time) every ...
1
vote
2answers
720 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 ...
1
vote
1answer
1k views

Accessing resources on localhost using domain credentials

I'm trying to set up Team Foundation Server 2010, Sharepoint Server 2010 and Report Server 2008R2. I apologize for how long my question/problem is but I'm really lost on where to even look so am being ...
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 ...
5
votes
4answers
5k 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 ...
3
votes
1answer
1k views

Reporting Services 2008 configuration for basic authentication using username and password

I want to configure Reporting Services 2008 to use a custom defined username and password for access. I read that I must set reporting services to do basic authentication : <AuthenticationTypes&...
0
votes
2answers
371 views

How do I change the Web Service Account for SQL Server Reporting Services?

I am trying to configure a Report Server on SQL Server 2005 and need to change the ASP.NET Web Service Account. Can anyone point me in the right direction of how to do this. Thanks Andy
0
votes
2answers
439 views

Why is awstats reporting my static IP instead of Domain Name?

In AWStats under: "Links from an external page (other web sites except search engines)" it has generated a list of pages that had linked to my page. I see pages like: Bing, YouTube, HotFrog, etc.. ...
0
votes
1answer
4k 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
1k views

Authentication problem: can't bypass the login prompt when browsing to the SQL Reporing Services website

I'm having a hard time configuring Reporting services on one of our servers. I'm not uninitiated in the domain of IIS7 but I cannot get rid of the login prompt when I'm surfing to the Reporting ...
0
votes
1answer
204 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
671 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?
3
votes
3answers
7k views

Error configuring SQL Reporting Services 2005 on Windows 7

I've installed SQL Server 2005 with Reporting Services on Windows 7 Ultimate x64 and when I try to configure it when clicking on "Windows Service Identity" I get this error message: There was an ...
0
votes
1answer
2k views

Reporting Services 2008 Service Account error

I saved over the encryption key backup file when changing from one account to another. Now I can't see reports, change accounts, or use any of the Encryption key tools in the configuration manager. ...