SCCM 2007 R2 – SQL Reporting services, Named instances and greyed out config option

May 16, 2009 at 10:52 am in ConfigMgr 2007, ConfigMgr 2007 R2, Known Issue, Reporting, SCCM 2007, SCCM 2007 R2, SQL Reporting services, SRS by Kenny Buntinx [MVP]

Hi All,

 

ConfigMgr 2007 R2 introduced a new feature for reporting. SQL reporting services based reporting instead of the original web based reports was added as a new feature. This makes sure that all system center products now use a consistent reporting product. Although both reporting methods can be used in conjunction with each other in the current release, as previously mentioned on this blog, this will not be the case in Sccm v.Next.

In this respect it makes sense to learn the ropes on this SRS technology now, one of the issues I have seen reporting, and which I ran into myself, is a greyed out admin ui interface if you try to start using the ConfigMGr 2007 R2 reporting services feature. After reporting the issue, the ConfigMgr team figured out what the issue was and they updated question 6 on their SRS faq:

http://blogs.technet.com/configmgrteam/archive/2009/05/14/faq-sql-reporting-services-integration-with-system-center-configuration-manager-2007-r2.aspx

For those of you who already have installed SRS, and want to use it in a named instance, you should be able to add another SRS default instance to the same box, and this should clear up the greyed out configuration options in the admin ui when you try to use the “copy reports to reporting services” wizard, or when you try to configure the properties of your ConfigMgr reporting services point in reports \ reporting services

Enjoy.

“Everyone is an expert at something”
Kim Oppalfens – Sms Expert for lack of any other expertise
Windows Server System MVP – SMS

http://www.scug.be/blogs/sccm/default.aspx

http://www.linkedin.com/in/kimoppalfens


 

Tweet about this on TwitterShare on FacebookShare on Google+Share on LinkedInPin on Pinterest