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)

0
votes
3answers
682 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
148 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
389 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
598 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
990 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
220 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
851 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 ...
0
votes
2answers
352 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
88 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
562 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
58 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
440 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
107 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
4k 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
2answers
5k 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
5k 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
549 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
313 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
677 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
153 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
666 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
574 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
850 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
136 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
662 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
242 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
689 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
4k 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 : ...
0
votes
2answers
369 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
412 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
3k 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
194 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
628 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
6k 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. ...
1
vote
2answers
1k views

Query Execution Failed in Reporting Services reports

I have some reporting services reports that talk to Analysis Services and at times they fail with the following error: An error occurred during client rendering. An error has occurred during report ...
0
votes
1answer
464 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
273 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 ...
1
vote
1answer
2k views

SQL Server 2008 Express + Reporting Services on Windows 7

I'm trying to install SQL Server Express 2008 and Reporting Services on a x64 Windows 7 Machine for development purposes. I've installed SQL Server 2008 Express with the Microsoft Web Platform ...
1
vote
1answer
1k views

Sharepoint and SSRS Native Integration - Not seeing web parts after cabinet file install

I followed the steps here to set up Sharepoint integration with reporting services (SSRS) using native mode. (i.e., get a report explorer and viewer web parts) However after adding the cabinet file ...
1
vote
1answer
1k views

How to Integrate Sharepoint with Reporting Services in Native Mode?

I'm trying to do something like this but with native mode (less integration). All of the directions I can find tell you how to set up Sharepoint integrated mode but I need to find out what the steps ...