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

Cannot resolve cluster resources on EC2?

I have created this cluster on Amazon's EC2 service. I can connect to the sql instance from the first node (there is only one node in the cluster at this time) using the cluster name, so I know that much works. I have another server in another…
JohnThePro
  • 2,595
  • 14
  • 23
0
votes
1 answer

SQL Server reporting services shutting down without log info

Using SQL Server 2008 Reporting services. Finding that the service is shutdown without anything in the windows event log or in SQL Server events. I see the log entry for the service starting when I manually start it, but nothing for the shutdown…
Christoph
  • 103
  • 2
0
votes
1 answer

SSRS - SQL Agent Job Report Queuing

So we have a small number of SQL Server 2005 Servers running a lot of SSRS reports, which is running into issues where the servers cannot keep up with the total number of reports, that users are scheduling on shared schedules, running at once. Has…
uzbones
  • 215
  • 1
  • 3
0
votes
1 answer

Multiple Reporting Services databases in one instance?

Is it possible to have multiple Reporting Services databases in one MSSQL instance? I have a MSSQL 2008 R2 with RS set to SharePoint Integrated Mode. This RS is in use and can't be changed. I do however need a RS in native mode for the TFS…
Tedd Hansen
  • 674
  • 5
  • 8
  • 17
0
votes
1 answer

Move From Reporting Services 2005 to 2008

I have 2 servers: SQL Server 2005 w/ Reporting Services Configured SQL Server 2008 I need to move the reporting services stuff from 2005 to 2008 so we can decommission the 2005 machine. Can someone give me all the necessary steps to get things…
Ronnie Overby
  • 681
  • 2
  • 12
  • 24
0
votes
2 answers

Reporting Services WMI Provider error 8000000A

I recently installed SQL Server Express 2005 with all available options. When I run Start->Programs->SQL Server 2005->Reporting Services Configuration I get an error immediatley: "An unknown error has occurred in the WMI Provider. Error Code…
Bryan Ward
  • 425
  • 1
  • 5
  • 10
0
votes
1 answer

Does SQL Server 2008R2 Express come with the reporting services?

I can't find any reference anywhere to it. If so, how do I enable it and access it? The only application that I could find that was related was the Reporting Services Configuration Manager. If Express does come with it, how do I activate and use it?…
Sam
  • 171
  • 2
  • 8
0
votes
3 answers

Configuring MOSS and Reporting Services on a Domain Controller

I'm working on a pretty standard MOSS virtual development environment. I have MOSS, sql 2005 and the machine is also the Domain Controller. I'm now doing some work with Reporting Services (SSRS) and integrating it with MOSS. I therefore installed…
Kieran
  • 141
  • 5
0
votes
1 answer

SSRS Data Driven Subscription empty destination folder

I have a SSRS Data Driven Subscription, the reports are save to a folder, I use the Overwrite Write Mode, however there are old reports that aren't generated anymore that lingers on the folder, I would like to clear the destination folder before…
Gabriel Guimarães
  • 405
  • 5
  • 18
0
votes
1 answer

How can I get Visual Studio to deploy to SSRS named with CNAME instead of A record?

We have SSRS (SQL Server Report Service) running on an Amazon EC2 instance. It had been named report.foo.com using an A record. Recently we changed it to a CNAME referencing the EC2 public DNS name. (Why: This way, report.foo.com resolves to the EC2…
Greg Hendershott
  • 816
  • 1
  • 8
  • 12
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

reporting services Unable to connect to the remote server

I've got reporting services and sql server 2005 installed on a windows server 2003 enterprise sp2 server. Reporting services was working just fine until yesterday it started saying "Error- Unable to connect to the remote server". I'm really not…
Thirster42
  • 354
  • 1
  • 2
  • 14
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
2 answers

SQL 2008. Help to pick right replication model

The database is end of day data storage with some reporting. We fill db with data for a particulate date every day. Time to time users' reports block import processes (run from C# apps and then with sprocs processing data on the SQL side). So my…
Boppity Bop
  • 752
  • 3
  • 11
  • 34
0
votes
3 answers

MSSQL Reporting Services report subscription won't forward to email outside of domain

MSSQL Reporting Services 2000 on Windows Server 2003 MS Exchange 2007 on Windows Server 2007 I have a report subscription that I need to deliver to a user with an email address outside the domain. I have set up the following for both the user and…
Judah Sali
  • 53
  • 7
1 2 3
…
16 17