An error occurred in a SQL Server Service Broker/Database Mirroring transport connection endpoint (9642) – How to Resolve

Hi friends, in this article, we will be discussing about how to troubleshoot the following error message: “Event ID: 9642. An error occurred in a SQL Server Service Broker/Database Mirroring transport connection endpoint.“.

 

About the Service Broker/Database Mirroring transport connection endpoint error

We can see from the error message, that it refers to a Service Broker/Database Mirroring endpoint connection error. To this end, the first that comes in mind, is that this is something that might have to do with Service Broker or Database Mirroring (i.e. Always On Availability Groups replication) in SQL Server.

However, note that, the specific error message talks about an error in establishing a connection to a specific endpoint. This of course, does not necessarily mean that there’s something wrong with the configuration of Service Broker or Availability Groups replication on the SQL Server instance, but it might be something else.

 

How to Troubleshoot the Error

The first thing to do, towards troubleshooting the error, is to first make sure that indeed the configuration of Service Broker or Availability Groups deployments (if applicable) is OK without any issues.

If the above health check is successful, then a possible scenario for getting these error messages, is that a network/vulnerability scanner is attempting to connect to the ports that are defined in a Service Broker or Database Mirroring (i.e. Availability Groups) configuration on the SQL Server instance. Since these connection requests are not valid network traffic, this causes errors to be generated regarding these endpoints.

To this end, in such case, you should contact the Information Security Team, to confirm that the errors, are indeed generated due to a vulnerability scanning activity that tries to connect to the specific endpoints.

 

Extra Knowledge Tip – Finding Info about the Endpoints

In order to check if and which endpoints you have configured in your SQL Server instance, you can run the following T-SQL statements.

 

Retrieving Service Broker Endpoint Info

You can easily retrieve Service Broker Endpoint info with the below T-SQL statement:

SELECT * FROM sys.database_mirroring_endpoints;
GO

 

Retrieving Database Mirroring Endpoint Info

You can retrieve Database Mirroring Endpoint info with the below T-SQL statement:

SELECT * FROM sys.database_mirroring_endpoints;
GO

 

Retrieving TCP Endpoint Info

You can retrieve TCP Endpoint info with the below T-SQL statement:

SELECT * FROM sys.tcp_endpoints;
GO

 

 

 


Strengthen your SQL Server Administration Skills – Enroll to our Online Course!

Check our online course on Udemy titled “Essential SQL Server Administration Tips
(special limited-time discount included in link).

Via the course, you will learn essential hands-on SQL Server Administration tips on SQL Server maintenance, security, performance, integration, error handling and more. Many live demonstrations and downloadable resources included!

Essential SQL Server Administration Tips - Online Course with Live Demonstrations and Hands-on Guides
(Lifetime Access/ Live Demos / Downloadable Resources and more!)

Enroll Now with Discount!


 

Featured Online Courses:

 

Read Also:

 

Subscribe to our newsletter and stay up to date!

Subscribe to our YouTube channel (SQLNetHub TV)

Easily generate snippets with Snippets Generator!

Secure your databases using DBA Security Advisor!

Generate dynamic T-SQL scripts with Dynamic SQL Generator!

Check our latest software releases!

Check our eBooks!

 

Rate this article: 1 Star2 Stars3 Stars4 Stars5 Stars (1 votes, average: 5.00 out of 5)

Loading...

Reference: SQLNetHub.com (https://www.sqlnethub.com)

© SQLNetHub