this is a question for your ips software. they can tell you what the ips sw is doing and set up exclusions.
don't forget you av sw too.
https://www.recastsoftware.com/resources/configuration-manager-2012-and-anti-virus-software-exclusions-for-site-servers/
SCCM - IPS enabled network
HI All,
We are facing some issues while running the report in SCCM. We have latest SCCM CB version, when we run any report from console or directly in the SQL reporting server. It takes 25 to 30 mins to process, we found Intrusion prevention service policy is causing this issue.
When we disable it, it reduce the generating time to 5 to 10 mins. Does anyone faced this issue, what needs to be allowed in IPS to process quicker report
Appreciate your response
4 answers
Sort by: Most helpful
-
Garth 5,801 Reputation points
2022-11-30T11:18:50.757+00:00 -
Garth 5,801 Reputation points
2022-11-30T12:10:27.96+00:00 btw i should also add that 5-10 minutes for most enviroments is a long time. i would check your Sql health to see if there is anything that can be done such as enabling ola's script. https://www.recastsoftware.com/resources/installation-guide-to-ola-hallengrens-sql-server-maintenance-solution/
-
Limitless Technology 43,966 Reputation points
2022-12-02T12:49:27.293+00:00 Hello there,
You need to maintain your SQL DB regularly, like rebuilding indexes, etc. There is a good chance the reason for this is a defragmented underlying SQL Server database. Therefore you should rebuild the indexes which can be done in various ways and with different tools.
SQL Server Reporting Services uses the Reporting services point account to retrieve the data for Configuration Manager reports from the site database. Make sure all the necessary services are running and not being tackled by malware services.
The below thread discusses the same issue and you can try out some troubleshooting steps from this and see if that helps you to sort the Issue. https://social.technet.microsoft.com/Forums/en-US/c12eb3b3-4292-48ab-a52c-59e605686753/sccm-report-takes-forever-to-load?forum=configmanagergeneral
-------------------------------------------------------------------------------------------------------------------------
--If the reply is helpful, please Upvote and Accept it as an answer–
-
karthik palani 1,016 Reputation points
2022-12-04T09:04:43.33+00:00 Thanks all,
Weird, we saw network traffic to internet from SQL server to Internet via 443. Not sure why it is trying to communicate outside the domain
After enabling the internet the reports are fast and normal now. Any insights on this please
Any specific URL i need to open for SQL services