tmiller_hockey Posted May 2, 2012 Report post Posted May 2, 2012 Following along in the documentation, I get to where I want to install the Reporting Services Point Role. Figure no big deal. In walking through the steps of role setup everything is great until I go to dropdown the selection for the Reporting Server Instance. It does not see the reporting server instance. In looking at the SQL server, I don't see reporting services listed in the Start Menu and I selected Reporting Services on the original install. I've even gone back into SQL setup to look and SQL setup shows it is installed. Anyone have an idea? Quote Share this post Link to post Share on other sites More sharing options...
willisj318 Posted May 3, 2012 Report post Posted May 3, 2012 What is your setup ?is sql installed on the same box as sccm or a seperate server? Reporting services would be under the Configuration Tools folder. Quote Share this post Link to post Share on other sites More sharing options...
tmiller_hockey Posted May 3, 2012 Report post Posted May 3, 2012 My apologies, I forgot to look at it under there. Quote Share this post Link to post Share on other sites More sharing options...
horirim Posted May 9, 2012 Report post Posted May 9, 2012 I´ve the same Problem... Can´t choose an Reporting Instance when I want to install the Reporting Role. My SQL (SCCM)Database is on a remote server with installed Reporting Services. The Reporting Server is configured and works. The SCCM Service users have access to the database and reporting services. But I can´t choose an Instance in the setup (exactly like shown on the picture) So what´s wrong??? Quote Share this post Link to post Share on other sites More sharing options...
willisj318 Posted May 9, 2012 Report post Posted May 9, 2012 You can only install the reporting role on a server with SRS installed. In your instance you can A. Install RSR on the CCM Server or B. Install the reporting role on the SQL Server. Quote Share this post Link to post Share on other sites More sharing options...
horirim Posted May 10, 2012 Report post Posted May 10, 2012 thanks for your answer! serverA is my sccm-server and serverB is my sql-server on serverB is an extra instance for sccm with reporting services installed. the sccm-database is also on this instance. i tried to install the reporting role on the SQL-server. first without configured reporting services on the sql and then with configured reporting services on the server. but i can´t choose the reporting instance on the reporting-siterole-wizard. i don´t understand why... the access-rights to the srs are also ok Quote Share this post Link to post Share on other sites More sharing options...
mike crowley Posted May 10, 2012 Report post Posted May 10, 2012 You need to install SSRS *AND* configure it. See here: http://sccm.haas.se/?p=65 Quote Share this post Link to post Share on other sites More sharing options...
horirim Posted May 12, 2012 Report post Posted May 12, 2012 thanks for your replies! now i´ve found the problem: the reporting server was a 2012 sql. i knew that its not supported but the sccm database works on a 2012 sql. But it looks like, sccm 2012 cannot find the reporting role on the sql 2012. Quote Share this post Link to post Share on other sites More sharing options...
murphy81 Posted May 15, 2012 Report post Posted May 15, 2012 Hi Horirim, So did you have to reinstall SQL using 2008 to resolve this? I'm having the same problem. Quote Share this post Link to post Share on other sites More sharing options...
Raymond Posted May 31, 2012 Report post Posted May 31, 2012 Guys, i solved this by configuring SQL server reporting services on Start > All Programmes> Microsoft SQL Server 2008 R2 > Configuration Tools > Reporting Services Configuration Manage Raymond Quote Share this post Link to post Share on other sites More sharing options...
gvlaarho Posted June 12, 2012 Report post Posted June 12, 2012 Hello all, I have the same problem: SQL server enterprise on remote server; new named instance created for SCCM2012. All works like a charm but the reporting service point: the reporting services server instance is always empty. All checked and correctely configured also the SSRS; I can connect the report web site without any problem from everywhere. is it the same problem than with SCCM 2007. Please help Quote Share this post Link to post Share on other sites More sharing options...
horirim Posted June 19, 2012 Report post Posted June 19, 2012 sorry for my late answer... in sql 2012 the reporting services didn´t work. i reinstalled the database on a sql 2008 R2 / default instance. after that, i configured the reporting services (programs -> sql 2008 R2 / configuration tools / reporting services configuration manager) -> that worked! one thing that i read in a other thread was, that there are problems with reporting services of the operations manager and configuration manager on the same server. Quote Share this post Link to post Share on other sites More sharing options...
gugi Posted September 14, 2012 Report post Posted September 14, 2012 You must install SCCM SP1 , and then it will work on SQL 2012. Best regards Quote Share this post Link to post Share on other sites More sharing options...
vuvany Posted January 24, 2013 Report post Posted January 24, 2013 Someone please help! After I intalled the reporting roll, why I cannot create report in the Config Manager console? I did the following and got the error. 1. Run Config Manager Console => Monitoring => Reporting => Reports ... Right clicked on report and selected "Create Report" and got this error """"The underlying connection was closed: An unexpected error occurred on a send.""" How can i resolve this issue? Thanks for any reply. Quote Share this post Link to post Share on other sites More sharing options...
Oneone Posted February 4, 2013 Report post Posted February 4, 2013 check out my posts here, http://www.windows-noob.com/forums/index.php?/topic/4550-using-sccm-2012-rc-in-a-lab-part-11-adding-the-reporting-services-point-role/page-4 Quote Share this post Link to post Share on other sites More sharing options...
Yas Posted March 26, 2013 Report post Posted March 26, 2013 Hi am having same issue, has anybody troubleshoot the matter? Quote Share this post Link to post Share on other sites More sharing options...
Yas Posted March 26, 2013 Report post Posted March 26, 2013 I have my sccm 2012 sp1 server on a physical host and my Sql server is on a vm (SQL Server 2012 SP1 + cu2). When configuring Reporting service point am having same issue as per above picture. please help. Quote Share this post Link to post Share on other sites More sharing options...
willisj318 Posted March 26, 2013 Report post Posted March 26, 2013 In my experiences I had to make sure you went through SRS and configured it for use with SCCM. Once I did this, the instance showed up. Quote Share this post Link to post Share on other sites More sharing options...
tconners Posted June 6, 2013 Report post Posted June 6, 2013 I am having the same issue. SQL 2012 sp1 with SSRS fully configured and operational. Has anyone gotten past this without having to install SQL2008r2??? Quote Share this post Link to post Share on other sites More sharing options...
tconners Posted June 6, 2013 Report post Posted June 6, 2013 Well I installed SQL 2008R2 sp1 CU6 and still have the same issue as the screenshot above ARRRRRRGGGGGG!!!!! Quote Share this post Link to post Share on other sites More sharing options...
Rocket Man Posted June 6, 2013 Report post Posted June 6, 2013 SSRS on CM2012 SP1 works fine on SQL 2012 CU3, thats with SQL and SCCM hosted on the same server. I also see that SQL 2012 SP1 is also now a supported configuration as of Feb 2013. link Quote Share this post Link to post Share on other sites More sharing options...
GarthMJ Posted June 7, 2013 Report post Posted June 7, 2013 Well I installed SQL 2008R2 sp1 CU6 and still have the same issue as the screenshot above ARRRRRRGGGGGG!!!!! I have only see that happen when SSRS is missing CU or SP. It should work otherwise.. I would re-apply the CUs to your SSRS server. Quote Share this post Link to post Share on other sites More sharing options...
tconners Posted June 8, 2013 Report post Posted June 8, 2013 "I have only see that happen when SSRS is missing CU or SP. It should work otherwise.." I am up to CU4 with SQL2012 and am hitting the same error. 1) SQL instance is at: Microsoft SQL Server 2012 (SP1) - 11.0.3368.0 (X64) May 22 2013 17:10:44 Copyright © Microsoft Corporation Enterprise Edition (64-bit) on Windows NT 6.2 <X64> (Build 9200: ) (Hypervisor) 2) SCCM is SP1 3) SQL is on a separate system than SCCM 4) SCCM and SSRS reside on the same system. Any suggestions?????? Quote Share this post Link to post Share on other sites More sharing options...
tconners Posted June 8, 2013 Report post Posted June 8, 2013 Got it! It was the fact I was trying to install the Reporting role on the SCCM box instead of the SQL box. DOUHHH! Quote Share this post Link to post Share on other sites More sharing options...
Atomic12 Posted April 27, 2015 Report post Posted April 27, 2015 Just a little explanation for the post above, I read it but did not understand it So if you are running SQL on a DIFFERENT machine than your SCCM server, then you have to choose that machine running SQL inside of your SCCM console. We are all used to installing roles on our SCCM server but this time you have to choose your SQL box and then everything works just fine. 2 Quote Share this post Link to post Share on other sites More sharing options...