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.
246
questions
0
votes
1
answer
127
views
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 ...
2
votes
1
answer
779
views
Change to RS 2008R2 configuration stopped IIS site receiving traffic through load balancer (and its still not working after backing it out)
Background
We are testing a pair of Windows 2008 R2 (IIS 7.5) web servers in conjunction with a hardware load balancer (external device) that splits port 80 traffic coming into a Virtual IP between ...
2
votes
1
answer
822
views
SQL Server Reporting Services subscription creation silently fails. No error message is displayed, but the subscription does not get created
I'm trying to set up a subscription for a SSRS report. I have deployed the report to the server and I can view the report in a web browser with no problems. I have tried to reproduce this issue on ...
1
vote
0
answers
152
views
Sharepoint Reports on Mac
When trying to view Sharepoint Reports, Mac users get the error "An unexpected error occurred while connecting to the report server. Verify that the report server is available and configured for ...
0
votes
1
answer
1k
views
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 ...
1
vote
1
answer
2k
views
One Way Replication of Oracle 11g to MSSQL 2008R2
We're in the midst of a major LOB system change which will use Oracle 11g, but we need to maintain a LARGE number of existing reports in SSRS.
What is a good method to automate a one-way, read-only ...
0
votes
1
answer
223
views
How to configure Reporting server on SQL Server 2008, Windows 7
I want to configure reporting server on sql server 2008.I m using Windows 7
Operating System . I configure reporting manager using Reporting Services Configuration Manager and provide Service ...
0
votes
1
answer
285
views
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 ...
3
votes
1
answer
12k
views
Allow anonymous access to SSRS
How could I allow anonymous access to SSRS so that all user can access the reports without asking for a user name and password?
2
votes
1
answer
2k
views
How to uninstall SQL 2008R2 Reporting Services via the command line?
I am running SSRS 2008R2 x64 on a Windows Server Core 2008 R2 instance. I need to fully uninstall the SSRS instance leaving the DB's in tact. I know this is normally done through the Programs and ...
2
votes
2
answers
680
views
reporting servcies 0x7 KDC_ERR_S_PRINCIPAL_UNKNOWN only on server
I have Reporting Services configured on Windows Server 2008 R2. The reporting services is running under domain account and so its AppPool. I am accessing the site through a custom domain.
The ...
0
votes
1
answer
55
views
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 ...
2
votes
2
answers
1k
views
Sharepoint Reports do not work in Firefox
Using SSRS in integrated mode, Reports can be viewed in IE but not in Firefox, Chrome, Safari, etc. They get "An unexpected error occurred while connecting to the report server. Verify that the ...
0
votes
1
answer
67
views
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 ...
1
vote
1
answer
166
views
SQL Reporting services for Microsoft SBS 2003 not working
I have a clean install of MS SBS 2003 Premium. I installed MSSQL 2000 with SP4. Now I am trying to install CRM 3.0 that requires SQL Reporting Services - but it says its not there.
When I go to Add/...
0
votes
1
answer
408
views
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 ...
0
votes
1
answer
548
views
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. (...
0
votes
2
answers
4k
views
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 ...
1
vote
2
answers
6k
views
Accessing SQL Server Reporting Services by Non-Admin Accounts
When accessing SQL Reporting Services Report Manager through Great Plains 2010, we're getting the following:
An error has occurred during report processing. (rsProcessingAborted) Get Online Help
...
0
votes
1
answer
1k
views
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 ...
1
vote
2
answers
2k
views
Asterisk Call Center Report - Inbound and Outbound Calls
We currently use Asterisk to run our call center which handles incoming calls (both direct dial to extension and queues) as well as a bunch of outbound calls. Up until now, we've used a custom report ...
1
vote
0
answers
2k
views
reporting services 2008 R2 shows UAC for printing ActiveX after .NET 4.0 installation
Installed the latest updates on the server.
Now every time I try to print from a reporting service website the UAC opens..
I already tried to reduce security within IE9 to the minimum, but with no ...
1
vote
1
answer
669
views
Report Server w/ SQL 2008 R2 Express - Can't login to Manager URL
I just installed Report Servicing addon (Advanced Services) to a local SQL Express 2008 R2 server. I have the configuration tool and setup the proper URLs but when I connect to them I get permissions ...
0
votes
1
answer
108
views
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 ...
0
votes
2
answers
93
views
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 ...
0
votes
3
answers
2k
views
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.
...
0
votes
1
answer
365
views
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....
0
votes
1
answer
400
views
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:
"...
0
votes
1
answer
1k
views
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 ...
1
vote
1
answer
6k
views
Reporting Services 2008 R2 export to PDF embedded fonts not shown
I'm trying to export a report to PDF with a custom font.
I have installed a font on the server that hosts Reporting Services 2008 R2, restarted the SSRS service, and sucessfully seen it using the web ...
0
votes
1
answer
3k
views
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: ...
1
vote
1
answer
152
views
When integrating SQL Server Reporting Services with SharePoint, does SharePoint have to be installed on the database server that hosts SSRS?
I am configuring SSRS (2008 R2) in SharePoint integrated mode to work with a SharePoint (2010) site that is on another server, do I also have to install SharePoint on the database server that is ...
1
vote
0
answers
944
views
Problems with Apache Mod_Proxy and Microsoft's ReportViewer's Reserved.ReportViewerWebControl.axd
I've configured an Apache httpd server (v2.2) as a reverse proxy (with SSL) to a Microsoft IIS website running an ASP.NET application with SQL Server Report Services.
The proxy mostly works but ...
0
votes
1
answer
1k
views
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 ...
0
votes
1
answer
2k
views
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?
0
votes
1
answer
1k
views
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, ...
1
vote
1
answer
162
views
SQL Server 2008 Reporting Services on Windows 2003
Will SQL Server 2008 Reporting services work if it is install on Windows 2003?
Anyone have any experience with this?
0
votes
3
answers
938
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
1
answer
201
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
6
answers
581
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 Linux ...
0
votes
1
answer
1k
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, ...
1
vote
1
answer
12k
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
2
answers
255
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
1
answer
9k
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 there ...
1
vote
1
answer
310
views
Windows 7 UAC approved / unapproved list
Problem: Not able to print reports in CRM because of UAC block.
Notes: A user with local admin clicked no to the UAC prompt to install the Report Viewer in CRM while printing a report.
The prompt was ...
0
votes
2
answers
536
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
1
answer
113
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
2
answers
3k
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
3
answers
88
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
1
answer
469
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 ...