locked
Hi please assist me i am not getting reporting services server instance RRS feed

  • Question

  • Hi please assist me i am not getting reporting services server instance scenario i installed SQL on Remote Server and using domain account (svc-sccmreporting) having rights to sql server or sysadmin permission

    Saturday, May 7, 2016 3:26 PM

Answers

  • Thanks so it is not possible to install SCCM reporting service role on another machine? apart from SQL server?

    You have to install the reporting services point role on the server that has SQL Server Reporting Services installed and configured. Did you install and configure SSRS?

    next report service account should have sql sysadmin rights or permission?

    https://technet.microsoft.com/en-us/library/gg712698.aspx#BKMK_InstallReportingServicesPoint

    Reporting Services Point Account:

    ...

    Configuration Manager automatically grants the specified user access to the site database.

    ...

    The account that runs Reporting Services must belong to the domain local security group Windows Authorization Access Group, and have the Read tokenGroupsGlobalAndUniversal permission set to Allow.

    The specified Windows user account and password are encrypted and stored in the Reporting Services database. Reporting Services retrieves the data for reports from the site database by using this account and password.

    System_CAPS_security Security Note

    The account that you specify must have Log on Locally permissions on the computer hosting the Reporting Services database.



    https://ccmcache.wordpress.com/ | @kevmjohnston

    • Marked as answer by Frank Dong Tuesday, June 7, 2016 12:35 AM
    Saturday, May 7, 2016 8:20 PM
  • Thanks so we need to install SSRS on reporting server not on Sql server I am right again how to install and configure SSRS?  I mean recently I have load Sql and SSRS on same server but after SSRS I am unable open url like HTTP://SSRS SERVER/reports so I am complete setps for installation of SSRS again if settings in Sql configuration reporting service etc

    Ghost, this is a SQL problem not a CM12 problem. Until you fix the SQL problem don't even look at CM12.

    Garth Jones

    Blog: http://www.enhansoft.com/blog Old Blog: http://smsug.ca/blogs/garth_jones/default.aspx

    Twitter: @GarthMJ Book: System Center Configuration Manager Reporting Unleased

    • Marked as answer by Frank Dong Tuesday, June 7, 2016 12:35 AM
    Saturday, May 14, 2016 5:39 PM

All replies

  • If you query a search engine for

    "reporting services server instance" blank

    There are a lot of results on TechNet and various blogs. Here's an example:

    https://sccmentor.com/2014/02/06/reporting-services-point-server-instance-blank/

    What all have you tried so far? Anything?


    https://ccmcache.wordpress.com/ | @kevmjohnston

    Saturday, May 7, 2016 4:37 PM
  • Thanks so it is not possible to install SCCM reporting service role on another machine? apart from SQL server? next report service account should have sql sysadmin rights or permission?
    Saturday, May 7, 2016 4:49 PM
  • Thanks so it is not possible to install SCCM reporting service role on another machine? apart from SQL server?

    You have to install the reporting services point role on the server that has SQL Server Reporting Services installed and configured. Did you install and configure SSRS?

    next report service account should have sql sysadmin rights or permission?

    https://technet.microsoft.com/en-us/library/gg712698.aspx#BKMK_InstallReportingServicesPoint

    Reporting Services Point Account:

    ...

    Configuration Manager automatically grants the specified user access to the site database.

    ...

    The account that runs Reporting Services must belong to the domain local security group Windows Authorization Access Group, and have the Read tokenGroupsGlobalAndUniversal permission set to Allow.

    The specified Windows user account and password are encrypted and stored in the Reporting Services database. Reporting Services retrieves the data for reports from the site database by using this account and password.

    System_CAPS_security Security Note

    The account that you specify must have Log on Locally permissions on the computer hosting the Reporting Services database.



    https://ccmcache.wordpress.com/ | @kevmjohnston

    • Marked as answer by Frank Dong Tuesday, June 7, 2016 12:35 AM
    Saturday, May 7, 2016 8:20 PM
  • Thanks so we need install Sql Report services separately on report server. now scenario is i have SQL remote server with SSRS so need to install again SSRS separately on report server again need to install sccm reporting services?
    Saturday, May 7, 2016 8:45 PM
  • You can have the reporting point on a remote server. You need to allow access via port 1433 on the SQL box

    Saturday, May 7, 2016 10:59 PM
  • ports are open but still reporting services server instance" blank " if tips?
    Saturday, May 7, 2016 11:07 PM
  • SSRS has to be on the server that you want to use for the reporting services point role. It's really no more complicated than that.

    https://ccmcache.wordpress.com/ | @kevmjohnston

    Saturday, May 7, 2016 11:49 PM
  • So have you installed SQL Server Reporting Services and created the SQL Server Reporting Services server DB using the report services configuration manager?

    https://blogs.technet.microsoft.com/configurationmgr/2014/07/23/a-step-by-step-example-of-configuring-a-reporting-services-point-for-https-in-system-center-2012-configuration-manager/

    Once that is done you should have no issue seeing the instance in that wizard.

    Sunday, May 8, 2016 4:02 AM
  • Thanks so we need to install SSRS on reporting server not on Sql server I am right again how to install and configure SSRS?  I mean recently I have load Sql and SSRS on same server but after SSRS I am unable open url like HTTP://SSRS SERVER/reports so I am complete setps for installation of SSRS again if settings in Sql configuration reporting service etc
    Saturday, May 14, 2016 5:32 PM
  • Thanks so we need to install SSRS on reporting server not on Sql server I am right again how to install and configure SSRS?  I mean recently I have load Sql and SSRS on same server but after SSRS I am unable open url like HTTP://SSRS SERVER/reports so I am complete setps for installation of SSRS again if settings in Sql configuration reporting service etc

    Ghost, this is a SQL problem not a CM12 problem. Until you fix the SQL problem don't even look at CM12.

    Garth Jones

    Blog: http://www.enhansoft.com/blog Old Blog: http://smsug.ca/blogs/garth_jones/default.aspx

    Twitter: @GarthMJ Book: System Center Configuration Manager Reporting Unleased

    • Marked as answer by Frank Dong Tuesday, June 7, 2016 12:35 AM
    Saturday, May 14, 2016 5:39 PM