大网数据广告活动
数据库与应用安全

Modifying the NETMON parser port for SQL Server

· 52CE 我爱测

This article explains how to change the port of the NETMON parser for SQL Server.

This article provides instructions to change the NETMON parser port in order to recognize servers that are running Microsoft SQL Server on your network but don't use default port 1433.

You should make this change only one time. This change assumes that the SQL Server-based computers have statically allocated ports (recommended) and that you aren't adding new servers to the network. In this process, you should also add Always-On Listener port numbers if they're different than the instance port numbers.

You must configure the NETMON parser to recognize these ports. To configure the parser, follow these steps:

  1. Copy C:\programdata\microsoft\Network Monitor 3\NPL\NetworkMonitor Parsers\Base\tcp.npl to a folder (for example, c:\temp).

  2. Rename the original file to tcp.npl.old.

  3. In Notepad, open c:\temp\tcp.npl, and then search on "1433" in the file.

  4. Make sure that you set the Open dialog box to show All Files (.).

  5. Add the following additional port numbers:

    case 1433: // original SQL entry case 6020: // additional SQL entry case 6021: // additional SQL entry

  6. Save the file, and copy the port numbers to the following folder:

    C:\programdata\microsoft\Network Monitor 3\NPL\NetworkMonitor Parsers\Base

  7. Run NETMON by using administrative access to rebuild the parser.

    You can also edit the file if you run your editor by using administrative access or give your user account explicit permissions to the Network Monitor 3 folder and let the permissions be inherited by the subfolders and files.

  8. In Windows Explorer, turn on File name extensions to make sure that the file isn't accidentally saved as tcp.npl.txt.

More information

Source: Microsoft Learn / IT Pro troubleshooting by Microsoft and contributors. Documentation licensed CC BY 4.0. Code samples are covered by the MIT License. Converted from Markdown, with links normalized and embedded media omitted.

资料来源与适用范围

资料来源
Microsoft Learn / IT Pro troubleshooting
适用范围
See source applicability · Source date 05/20/2024
内容语言
中文;命令、路径和错误标识保留技术原文
本地收录日期
2026-11-15
授权说明
CC BY 4.0 (documentation), MIT (code samples)

正文与所需资源由本站本地存储。查看来源及更新记录 ↗

请按适用版本和实际日志确认原因;本站没有对每一种系统或设备逐项执行文中的操作。