Hi all, I've been trying to look for a manual\tutorial how to install the SCCM reporting services, but without any luck. My lab configuration is as follows: 2 Domain controllers (windows 2008 r2) 1 SQL server (i installed on it the SCCM database) it is not on the sccm server. 1 SCCM server 2 client machines (windows 7, and windows xp). I have to mention that all the server are running windows 2008 r2, and the sql is also 2008 r2. further more, the sccm 2007 r2. I know how to add the reporting point role, and the reporting services point role, but i don't know on which server to add the roles.(i'm a bit confused about that). The sql server which hosts the sccm database does not have IIS on it, so my guess is that the reporting services role should be applaied on the sccm server, right? But...the sccm server does not host the sql databse...it's on a sdiffrent server. One thing i forgot to mention, is that the sql server, and the sccm server are not running with the same user name. but the sccm username (domain admin) have rights to the sccm login (i added the account of the sccm admin to the sql logins, i just thought you'll need to know about that). So, i hope i made my self clear, i thought i;ll add the two roles, and that's it...but it seems to be a bit tricky, and i need your help with this one.

It should be installed on the SQL server (with the Reporting Services component). Take a look here for more information: http://technet.microsoft.com/en-us/library/cc161824.aspxMy Blog: http://www.petervanderwoude.nl/

Hi peter, Thank you for your reply, i will configure now the role reporting and the reporting point role on the sql. What else do i need to configure? do i need to restart any service? restart the sql server?

Nothing special. After that you should be able to copy the default reports to the Reporting Services Point.My Blog: http://www.petervanderwoude.nl/

Hi peter, One last thing, how do i copy the reports to the Reporting services point, i can't see the copy command (when i right click the reports). all i have is export, and when i click it, it starts a wizard that tellss me that i can wexport all the report to a MOF server. what am i missing?

Expand the Reporting Services node, right-click the Role Server and select Copy Reports to Reporting Services.My Blog: http://www.petervanderwoude.nl/

Hi, You may refer to the following articles: How to Copy Configuration Manager Reports to SQL Reporting Services FAQ - SQL Reporting Services Integration with System Center Configuration Manager 2007 R2 Regards, Sabrina This posting is provided "AS IS" with no warranties or guarantees, and confers no rights. |Please remember to click Mark as Answer on the post that helps you, and to click Unmark as Answer if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.