Error installing SQL Reporting Builder 3.0 in ConfigMgr. 2012

It has happen to me before, and it will happen again. I ran my ConfigMgr. 2012 administrator console without starting it as Administrator. When trying to edit a report I got the error message: Report Builder 2.0  is not installed as a click-once application on report server The error message is kind of funny, as [...]

Category: Config Mgr. Inventory and Reporting, Configuration Manager, SQL Reporting services, Tips and tricks  |  Comment

Timeout Expired on Report Server

One question I often get from System Center folks is about the SQL Reporting Services and report timeout. Unfortunately Microsoft have an default value on many report dataset which is to low for an production environment. The easy solution would be to edit the RSReportServer.Config XML file, I mean – in this file we have [...]

Category: Config Mgr. SP2, Configuration Manager, Home, SQL Reporting services  |  1 Comment

SQL Reporting Services and antivirus settings

Just installed and configured SQL Reporting Services 2008 with ConfigMgr. 2007 R2 SP2 this morning. Everything went smoothly except for one minor detail; I got an error in my mail subscription: Failure sending mail: The message could not be sent to the SMTP server. The transport error code was 0x800ccc15. The server response was not [...]

Category: Config Mgr. Inventory and Reporting, SQL Reporting services, Troubleshooting  |  1 Comment

Creating a basic Config mgr. report with SQL reporting services

Converting the Configuration manager ASP reports to SRS reports (SQL Reporting Services) is a really easy task. Once you want to modify or create new the reports you need to a little more work. I create reports using these applications. SQL Server Report Builder 1.0 SQL Server Report Builder 2.0 (requires SQL Server 2008) Business [...]

Category: Config Mgr. Inventory and Reporting, SQL Reporting services  |  1 Comment

Configuring SQL Reportings Services mail subscriptions with Configuration Manager

In this post I’ll describe how you configure mail subscriptions with Configuration Manager 2007 R2. I assume that SQL Reporting Services is installed and configured on a remote database. I also assume that the Reporting Services Site system is configured in the Configuration Manager Administrator console. Prerequisites SQL Reporting Services requirements Execution account. Windows user [...]

Category: Config Mgr. Inventory and Reporting, SQL Reporting services  |  2 Comments