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

All replies

• 

  

  0

  Sign in to vote

  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
• 

  

  0

  Sign in to vote

  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
• 

  

  0

  Sign in to vote

  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.

  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
• 

  

  0

  Sign in to vote

  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
• 

  

  0

  Sign in to vote

  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
• 

  

  0

  Sign in to vote

  ports are open but still reporting services server instance" blank " if tips?
  

  Saturday, May 7, 2016 11:07 PM
• 

  

  0

  Sign in to vote

  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
• 

  

  0

  Sign in to vote

  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
• 

  

  0

  Sign in to vote

  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
• 

  

  0

  Sign in to vote

  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