Comments on: How to Re-install SQL Reporting Services for SCCM https://www.prajwaldesai.com/how-to-re-install-sql-reporting-services-for-sccm/ SCCM | ConfigMgr | Intune | Windows 11 | Azure Thu, 06 May 2021 13:47:30 +0000 hourly 1 https://wordpress.org/?v=6.4.1 By: Elton de Carvalho Costa https://www.prajwaldesai.com/how-to-re-install-sql-reporting-services-for-sccm/#comment-24019 https://www.prajwaldesai.com/?p=14136#comment-24019 HI after update reporting services have a error SMS_DATABASE_NOTIFICATION_MONITOR ID 600

Failed to obtain a SQL Server connection. SQL Server is not running or all connections have been used.

]]> By: Anson https://www.prajwaldesai.com/how-to-re-install-sql-reporting-services-for-sccm/#comment-16198 https://www.prajwaldesai.com/?p=14136#comment-16198 After re-installed Reporting service point on SQL server 2016 SP2 , the following error exist in srsrp.log:
(!) InitializeSrsWhenNeeded error = The specified module could not be found. SMS_SRS_REPORTING_POINT

]]> By: balasubramanian murugesan https://www.prajwaldesai.com/how-to-re-install-sql-reporting-services-for-sccm/#comment-13286 https://www.prajwaldesai.com/?p=14136#comment-13286 Have configured SSRS and checked web portal URL in SQL Server.
Further configured Reporting service Point in SCCM CB 1902 successfully. But unable to see Reporting service Point site system role under SQL site server in SCCM console after installing and logs are also not available in SCCM Primary Site Server.

Any idea pls suggest where any thing is missed?

]]> By: Tyler https://www.prajwaldesai.com/how-to-re-install-sql-reporting-services-for-sccm/#comment-13075 https://www.prajwaldesai.com/?p=14136#comment-13075 Hey man this guide saved my butt today. Only thing I had to do was unreserve the URLs via command prompt in order to configure my Web Service URL and my Report Manager URL.

netsh http show urlacl
to get the URLs I needed to unreserved, followed by:
netsh http delete urlacl URL=EXACTURLHERE
to delete the ones I needed to delete.

]]> By: Andrew https://www.prajwaldesai.com/how-to-re-install-sql-reporting-services-for-sccm/#comment-12146 https://www.prajwaldesai.com/?p=14136#comment-12146 Hi, Thanks for the excellent guide. Is it best to install the reporting services role on the SQL Server or on your primary server if you are a 0-2000 endpoint organization and have a remote SQL box?

]]> By: Rizvi https://www.prajwaldesai.com/how-to-re-install-sql-reporting-services-for-sccm/#comment-12135 https://www.prajwaldesai.com/?p=14136#comment-12135 Hi everyone
We need to upgrade sccm to 1806 but prerequisite have failed informing that the reporting server, which is on separate box, has 2008 r2 O/S. I was wondering if I can remove the reporting services point role then upgrade sccm to 1806 then upgrade o/s of reporting point server and finally reinstall rsp. Will this work? Do I need to be aware of anything? Please help

]]> By: Daniel Brooks https://www.prajwaldesai.com/how-to-re-install-sql-reporting-services-for-sccm/#comment-12051 https://www.prajwaldesai.com/?p=14136#comment-12051 Hello.

I went through your steps but when I go to create a new report server database it says that the reporting server database already exists.

Any chance you would know how to resolve this?

]]> By: Felipe Bautista https://www.prajwaldesai.com/how-to-re-install-sql-reporting-services-for-sccm/#comment-8314 https://www.prajwaldesai.com/?p=14136#comment-8314 Hi,
perform the described procedure, and install the reports module for SCCM but do not load the reports.
Load the web portal of reports but blank, and in the same SQL server does not show reports, and show messsage

Message ID 1016

Site Component Manager failed to install this component on this site system.

Solution: Review the previous status messages to determine the exact reason for the failure. Site Component Manager will automatically retry the installation in 60 minutes. To force Site Component Manager to immediately retry the installation, stop and restart Site Component Manager using the Configuration Manager Service Manager.

]]>