ConfigMgr 2012 SMS SRS REPORTING POINT Component Failure

Ran into an interesting issue in the ConfigMgr 2012 lab today.  When I went into Monitoring and expanded the Reporting node, there weren’t any reports listed as available. I hadn’t yet gone into the Reporting since building the lab, so this was the first I was aware that something was wrong. I checked the System Status and sure enough the Reporting...

Read More»

#2 SSRS Reporting – Style based approach (Part 3 – Reporting DB delivered)

This is the 3rd part in a series designed to help you build a style-based SQL Reporting Services (SRS) reporting system using a DB, an .RDL template and SRS (similar to CSS or cascading stylesheet like functionality) Other articles in this series: PART 1 PART 2 In this post, I’ll actually deliver the following: A “style” database called BDNA_Reporting This...

Read More»

SQL Server 2008 R2 RTM Support Ending Soon

If you haven’t installed SQL Server 2008 R2 SP1 make plans to do so ASAP. Support, including security updates, won’t be available after July 10th for Enterprise or Standard versions! Check the link for more details: http://support.microsoft.com/lifecycle/search/?sort=PN&alpha=SQL              

Read More»

#2 SSRS Reporting – Style based approach (Part 2 – The ingredients and concept)

In my previous post, I started a series where I’ll walk through creating a (for lack of a better term) “style based” SQL Reporting Services (SSRS) template, not unlike CSS but working within the limitations of SSRS 2008/2012.  This post will serve as the next installment of that series where I’ll begin to lay out all the parts needed to...

Read More»

#2 SSRS Reporting – Style based approach

If you’re like me, you’ve had a love/hate relationship with SQL reporting services (SSRS).  On one hand, it has the potential for way more functionality than what the legacy ASP reports had, on the other hand you can’t use cascading stylesheets (CSS) to set the look/feel and there aren’t dynamic-width columns.  The lack of stylesheets was especially troubling to me because...

Read More»

System Center 2012 Configuration Manager Database Requirements

Posted in CM2012ConfigMgrSCCMSQLSQL 2008 R2

Recently had some trouble getting SQL configured for a RC2 lab, a few of the requirements have been updated.  Below are the various requirements for correctly installing SQL for ConfigMgr 2012 RC2. Make sure to review the supported configurations on the TechNet site. SQL Server Versions SQL Server 2008 SP2 with CU7 (Standard or Enterprise) [...]

Read More»