Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [ssrs]

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.

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.

244 questions
0
votes
1 answer

Can't uninstall Reporting Services on SQL 2005 (SBS 2008)

I am running SBS 2008 and have just installed SQL 2008 alongside SQL 2005. My understanding is that the default instance created in SQL 2005 is not needed and only the SBSMONITORING instance is needed. I have removed the default instance (as i want…
mwillmott
  • 242
  • 2
  • 8
0
votes
4 answers

Reinstall Reporting Services 2005

We are having problems with our reporting services portion of SQL server 2005. Can someone provide some guidance for reinstalling reporting services?
Ronnie Overby
  • 681
  • 2
  • 12
  • 24
0
votes
1 answer

Unable to connect to the Report Server

Win/7 Professional SQL Server 2008 R2 Express Reporting Services Configuration Manager When I launch it, shows correct Server Name, but report server instance is blank. When I press FIND I get: "Unable to connect to the Report Server " This is my…
pghcpa
  • 111
  • 6
0
votes
1 answer

Install Reporting Services 2K8R2 on W2K8R2 Cluster Nodes

First I'm aware that Reporting Services is not Cluster aware, But I would like to install it on my each node of my 2 node Cluster on the default instance. I've got the following error installing Rule Check Result Rule "Existing clustered…
Gabriel Guimarães
  • 405
  • 5
  • 18
0
votes
1 answer

Report Server: login failed to master database

I noticed from the SQL Server log that every time server restarts (I'm using SQL Server 2008 developer edition) I get an error message into log: Login failed for user 'machine\sqlaccount'. Reason: Failed to open the explicitly specified database.…
hjk
  • 17
  • 2
  • 5
0
votes
1 answer

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 "Render this report from a snapshot". But I…
Mr Shoubs
  • 363
  • 2
  • 9
  • 32
0
votes
1 answer

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?
Shiraz Bhaiji
  • 2,229
  • 9
  • 34
  • 47
0
votes
1 answer

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, but as soon as I enter a date in the US formt…
ProfK
  • 493
  • 5
  • 9
  • 28
0
votes
2 answers

Sharepoint Reporting Services on Intranet Farm

We have a Intranet Farm with two load balanced front end servers and a separate database, Report server is installed on box 1, so enysys data extenstions can access the sharepoint DOM. IIS-BOX 1 + Report Server IIS_BOX 2 SQL Server The problem is RS…
Mesh
  • 213
  • 3
  • 10
0
votes
3 answers

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 and no mather what I put there it fails with 401.1…
Gabriel Guimarães
  • 405
  • 5
  • 18
0
votes
6 answers

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

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 Linux platform. Please keep in mind that we need the…
NetConstructor.com
  • 133
  • 1
  • 6
0
votes
1 answer

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, so do I need any additional installs or what?
ProfK
  • 493
  • 5
  • 9
  • 28
0
votes
2 answers

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 the logged in user's client accounts. I store the…
senloe
  • 111
  • 1
  • 6
0
votes
2 answers

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 policy I did not allow it permission to start the…
One Monkey
  • 179
  • 1
  • 11
0
votes
3 answers

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 complains about the ReportServer database being…
SeanDav
  • 161
  • 1
  • 3
1 2 3
…
16 17