Blitz Result: Endpoints Configured
When SQL Server 2005’s new Database Mirroring and Service Broker features came out, lots of people played around with them initially. These features used endpoints: network ports that SQL Server listened to.
There’s nothing wrong with endpoints, but they increase SQL Server’s surface area, or hackability. The more openings we leave for hackers or viruses, the more risk we’ve got. If we’re not actively using anything that requires endpoints, we should remove them.
This part of our SQL Server sp_Blitz script checks to see if there’s any non-system endpoints.
To Fix the Problem
If you’re not using Database Mirroring, Service Broker, or connecting to the SQL Server via SOAP or HTTP, delete the endpoints.