Reporting Services Role Missing
Just installed SCCM 2007 w SP2 and R3 on a brand new site. It's a 2 server configuration with a dedicated SQL Server 2008 R2 (SRS installed) and a SCCM server. Both OS's are running W2K8 R2 Std. When going to configure roles on either of the servers, I do not have the option to select SQL Reporting Services Pont. The regular Reporting Services role is available, but not SQL Reporting Services. Anyone have any idea's?
October 18th, 2010 3:55am
Have you met all of the pre-requisites for the reporting services role? http://technet.microsoft.com/en-us/library/cc431447.aspx From what I understand you add the reporting services role (There isn't a dedicated SQL reporting services role) (http://technet.microsoft.com/en-us/library/cc161824.aspx) You then need to configure the reporting services role to use and SQL reporting services installation (http://technet.microsoft.com/en-us/library/cc512026.aspx) Then copy the default SCCM reports to the SQL reporting services if you want the default reports to run using SQL reporting services (http://technet.microsoft.com/en-us/library/cc161979.aspx)
October 18th, 2010 5:17am
Are you doing this on the console of site server itself or from a remote console? If a remote console, you must also install R3 (or R2) on the the remote console.Jason | http://myitforum.com/cs2/blogs/jsandys | http://blogs.catapultsystems.com/jsandys/default.aspx | Twitter @JasonSandys
October 18th, 2010 4:25pm
Please check ConfigMgrSetup.log, ComponentSetup.log and ConfigMgrPrereq.log, these files should be found in the root of C drive. Please confirm if we have “HKLM\SOFTWARE\Microsoft\SMS\R3” registry created, we should also have Sub Key called Registration If possible, you can try to uninstall R3 and install it againPlease 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.
October 19th, 2010 11:34am
Guys...I re-installed and this time i installed IIS on the SQL server. Also just installed R2 and skipped R3 for now and I can now see Reporting Services Point role available! I now have issues with SSRS not starting, but will start a new thread on that. Thanks
October 19th, 2010 9:39pm