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
1answer
480 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
620 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
213 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
718 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
329 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
84 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
497 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
2answers
57 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
439 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
105 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
4k 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
478 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
284 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
1k 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
641 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
137 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
643 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
532 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
845 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
118 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
596 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
238 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
672 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
1answer
366 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
398 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
191 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
610 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
1k 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
448 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
250 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 ...
0
votes
1answer
149 views

Is it possible to integrate a Reporting Server (SQL Express 2008 w Advanced Services) in WSS 3 at all?

Can I set up the Reporting Server of the Express Edition in some way to work integrated in my sharepoint services site? I have the reporting-server Add-in on the sharepoint machine and see the itmes ...
2
votes
4answers
4k views

Is it possible to mirror the SQL Reporting Services databases?

Is it possible to mirror the SQL Server (2005 or 2008) Reporting Services databases (ReportServer, ReportServerTemp)? I have a web site that uses a database that is already mirrored, and it also ...
1
vote
1answer
171 views

How to deploy SQL Server 2005 Reporting Services on a network without a domain server?

I have a small Windows network (~30 machines) and I need to deploy SQL Server 2005 Reporting Services. Because I use SQL Server Standard Edition and not Enterprise, I am forced to use Windows ...