locked
Reporting Services not found on named instance RRS feed

  • Question

  • We are running SCCM 2012 CU1. The database is running on a separate server as a named instance of SQL 2008 R2 (with latest SP/CU), and Reporting Services are installed. On the same server there is also a default instance of SQL 2012 (also with Reporting Services installed).

    Now, when I try to install a SCCM Reporting Point, it doesn't find any Reporting Services instance. I tried to install it on the site server and on the SQL server, with the site server's account as well with other accounts (that are all local administrators on the SQL server and in the SQL instance).

    I also tried to run the SQL server and Reporting Services under the "Local System" account as announced, but it didnt help.

    Friday, August 31, 2012 4:29 AM

Answers

  • Fixed in SP1 :)
    • Marked as answer by svhelden Monday, January 28, 2013 9:21 AM
    Monday, January 28, 2013 9:21 AM

All replies

  • This usually happens if Reporting Services in SQL was installed later and not when SQL was installed.

    If you install DB and RS together it configures it for you. If you only install DB first and then install RS later, you cannot configure it during install.

    Therefore, you have to go into SQL Reporting Configuration Manager. Configure the Reporting URL and the Website URL. Before that create the database. You will find some blog on how to configure those if you have not done that before.

    Most Important: If the above assumption is true and SSRS was installed later. Make sure that SQL Sp1 CU6 is applied. Then try reinstalling the RS Point in CM12.


    Regards, Vik Singh "If this thread answered your question, please click on "Mark as Answer"

    Friday, August 31, 2012 12:21 PM
  • Thanks, but I installed Reporting Services right with SQL, and also applied SP1 and CU7 to both.

    Order was:

    1) install SQL 2012 with Reporting Services (default instance)

    2) install SQL 2008 R2 with Reporting Services (named instance)

    3) install SQL 2008 R2 SP1 to all components

    4) install SQL 2008 R2 SP1 CU7 to all components

    5) install SCCM 2012 on site server

    6) install SCCM 2012 CU1 on site server

    7) try to add Reporting Point

    Friday, August 31, 2012 3:56 PM
  • Can you browse the reports folder using the browser. Should be http:// or <a href="https:///reports">https://<servername>/reports or reportserver.?

    Check the SQL Reporting Server Configuration Manager.. Do you see the DB etc?


    Regards, Vik Singh "If this thread answered your question, please click on "Mark as Answer"

    Sunday, September 2, 2012 6:55 AM
  • I can access

    http://servername/Reports

    http://servername/Reports_Systemcenter

    http://servername/ReportServer

    http://servername/ReportServer_Systemcenter

    The Reporting Services configuration looks ok to me.

    Tuesday, September 4, 2012 9:33 AM
  • I’m not sure this is the issue or not, but SQL 2012 is not supported by CM12 (yet), Because you install SQL 2012, it might be cause you issues with SSRS. BTW SQL 2012 work fine for CM12 (not supported yet) but not for SSRS. Yo might have to wait until CM12 SP1 (RTM) is released before this get fixed.


    http://www.enhansoft.com/

    • Marked as answer by svhelden Thursday, September 6, 2012 5:09 AM
    • Unmarked as answer by svhelden Thursday, September 6, 2012 5:09 AM
    Wednesday, September 5, 2012 12:06 PM
  • Well, I don't want to use SQL 2012; it simply is installed on the same machine. The instance I want to use is running SQL 2008 R2 SP1 CU7.

    But let's hope that SP1 fixes it anyway - it shouldn't be too far away. I might upgrade the SCCM instance to SQL 2012 then too.

    Thursday, September 6, 2012 5:10 AM
  • Fixed in SP1 :)
    • Marked as answer by svhelden Monday, January 28, 2013 9:21 AM
    Monday, January 28, 2013 9:21 AM