Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [ssrs-2008]

32 questions
1
vote
1 answer

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 service running. I need to configure a fully…
NoCarrier
  • 319
  • 2
  • 6
  • 12
1
vote
2 answers

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?
ScottStonehouse
  • 979
  • 4
  • 16
  • 25
0
votes
1 answer

Newbie SSRS install - logon question

I installed SQL Server Express 2008 with Advanced Services on a 64 bit Windows Server 2008 Standalone. I am setting up the Reporting Services with Reporting Services Config. Manager. As far as I can tell, all goes well during installation. When I…
user8160
  • 329
  • 5
  • 13
0
votes
1 answer

Cannot login to Reporting Services through SSMS and Reporting Services Configuration manager

I am trying to connect to reporting services through ssms. I am getting a following error: "A connection to the computer cannot be established. Access is denied" I have system administrator/system user privileges in report manager. I am also part of…
mamontyonok
  • 1
  • 1
0
votes
0 answers

SMTP on Windows Server 2008

Okay, i know that the built in SMTP server role inside Server 2008 is a little beleaguered; however, using resources here (stackex) and from msft I've worked through the issues I've been able to identify (SMTP wasnt generating logs, error message…
zentechinc
  • 101
0
votes
1 answer

Separate Database For SQL Server Reports

I have researched this on here (and other sites) quite a bit. I feel like I am missing something simple. So please direct me to another posting or help answer my question. Basically, we have out grown our current database server. The main issue is…
M1ke901
  • 1
  • 1
0
votes
1 answer

Proactive caching can only be deployed to a server running Enterpise or Developer

When deploying cubes and setting Automatic MOLAP to show changes I noticed the message: Proactive caching can only be deployed to a server running Microsoft SQL Server Enterpise Edition or Developer Edition. (I noticed changes are not showing up in…
David
  • 439
  • 1
  • 5
  • 17
0
votes
2 answers

Adding, removing or editing permissions of a user in SSRS 2008 is throwing error ""Response is not well-formed XML

I am totally stumped by a really stubborn problem: When I try to take any action (add, remove, edit) in the Security tab of a report's Properties page on SSRS 2008 UI I get a generic error. All it says is this: Response is not well-formed…
crosswalk
  • 11
  • 1
  • 3
0
votes
1 answer

Can I restore a pre-R2 SSRS 2008 database to an R2 instance?

We have an existing SQL Server Reporting Services installation running on a pre-R2 installation of SQL Server (10.0.4000.0). Both the application tier and data tier are on the same machine. I need to move this installation over to another server…
Jesse
  • 151
  • 4
0
votes
1 answer

Issue in configuration of SSRS

Windows Server 2003 R2 with SQL Server 2008 R2: During installation accidentally I selected "instance for Sharepoint server". Now I want to install the SSRS, in fact I installed it, by adding features from the DVD. Now from reporting services…
Lalit
  • 109
  • 1
0
votes
1 answer

SSRS 2008 R2 with SQL Server 2008 (non R2) ReportServer databases

We are moving to a scale out deployment of SSRS 2008 Enterprise with reporting services running on 2 front ends connecting to the "ReportServer" and "ReportServerTempDB" databases on a separate SQL Server 2008 cluster. Can you run Reporting Services…
SQL3D
  • 670
  • 1
  • 6
  • 11
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

Best solution for High Availability and SSRS on SQL Server 2008 R2?

I have 2 Physical Servers with SQL Server 2008 R2. – SQL Server 1(Active) & SQL Server 2 (Passive) Web Application is developed using .Net 4.0 Framework. I want to know the best solution to have high availability and also have SSRS for…
Chandra
  • 1
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
  • 483
  • 5
  • 9
  • 28
0
votes
1 answer

Report Builder 3.0 unable to access SharePoint Foundation 2010 Report Server

I am having a terrrible time getting this to work. I have configured the SharePoint site and the SQL Servers involved to use Kerberos. That has been confirmed working. I then configured the SharePoint site's Reporting Services integration (trusted…
Robert Kaucher
  • 477
  • 1
  • 3
  • 18
1
2
3