SQL Server – Fix – Error : 9692 The _MSG protocol transport cannot listen on port because it is in use by another process.

If you face following error the solution of this is very simple.

Error : 9692 The _MSG protocol transport cannot listen on port because it is in use by another process.

Above error comes up with Service Broker. Service Broker is used to send Database Emails. Read more about SQL SERVER – Introduction to Service Broker.

Solution/Fix/WorkAround:

Option 1:

Run netstat -aon on command prompt and determine what program is using the port described in the error. Once figured out disable the application which is using that port.

Option 2:

Alternatively, the port on which Service Broker is running can be changed. See SQL SERVER – Change the Port of Service Broker Configuration.

Reference : Pinal Dave (http://blog.SQLAuthority.com)

About these ads

One thought on “SQL Server – Fix – Error : 9692 The _MSG protocol transport cannot listen on port because it is in use by another process.

  1. Pingback: SQL SERVER - Change the Port of Service Broker Configuration Journey to SQL Authority with Pinal Dave

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s