Last night I installed sp3 and cu1 on a 64 bit SQL 2005 failover cluster. Everything went well. Reporting services is installed on the primary node. It now cannot connect to Oracle. The initial errors seemed to be related to this: http://support.microsoft.com/default.aspx?scid=KB;en-us;870668 I granted network service access, but that didn’t change anything. I then made it like development (which is working fine, unfortunately), which meant adding authenticated users to the bin and adminnetwork folders. This [...]

We are having problems with our reporting services portion of SQL server 2005. Can someone provide some guidance for reinstalling reporting services? Have you tried just removing the virtual directories from IIS and running the report configuration wizard again? This is what I have done when our installation went wonky and not only was it quick and painless, it resolved the problem too! NOTE: We had a security issue where no client could view the [...]

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 SP2 to give me the option in SSRS of SharePoint integrated mode. I also installed the SSRS Add-In for SharePoint. Then in SSRS I chose to create a new database so that I could tell [...]

We have a box whit SQL Server 2005 and another with Microsoft Office SharePoint Services 2007. If we install SQL Server Reporting Services in the MOSS box, in Sharepoint Integrated Mode, does it require another license, or it only counts the Database Server (in the SQL box)? Yes it does. A better option is to install another instance of reporting server on your existing sql server and integrate that instance Check more discussion of this [...]

I’d like to determine an optimal setup for SQL Server Reporting Services to use as the integrated reporting tool for SaaS web-based applications. All reports are pre-defined, so users pick a report and enter some parameters in a web-based front end. Parameters are then passed to the report, which pulls the data, formats the results, and returns a PDF or Excel file to the web application. While we have existing SQL Servers supporting our web [...]

I am trying to create a new Project and I get the following Error: Error Insufficient Permissions to create a new SQL Server Report Services at mytfserverDefaultCollection. Explanation The permissions granted your user name and ID on the SQL Server Reporting Services at mytfserverDefaultCollection do not allow you create a new project. You must be granted specific permissions by the server administrator. User Action Contact the Administrator for the SQL Server Reporting Services at mytfserverDefaultCollection [...]

Is there any good solution to make Mozilla Firefox display well and work alright with SQL Reporting Serives web application, I am tired of bugs and stacks produced by IE and theri last versions. The most annoying thing is size of displayed report in Mozilla is very small and printing control is disabled, I know that is i connection with ActiveX controls that cames with reporting services but I still hoping that maybe I can [...]

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 or cluster-prepared instance” failed. The instance selected for installation is already installed and clustered on computer SQL-1. To continue, select a different instance to cluster. OK Is there a way to install it [...]