search
HomeCommon ProblemHow to check the port number of sqlserver

SQL Server port number viewing method

Direct query:

SELECT name AS 'Port Name', physical_network_address AS 'Port Number'
FROM sys.dm_exec_connections
WHERE session_id = @@SPID

Use PowerShell:

Get-Service "MSSQL$<instance name>" | Select Name, CurrentState, Port

Using SQL Server Management Studio (SSMS):

  1. Open SSMS and connect to the SQL Server instance.
  2. In Object Explorer, expand "Server Name" > "Connections".
  3. Right-click "TCP/IP" and select "Properties".
  4. On the "IP Address" tab, find the "TCP Port" field.

Other methods:

  • Use netstat command:
<code>netstat -ano | findstr "<process id>"</process></code>
  • View SQL Server Configuration Manager:
  1. Open SQL Server Configuration Manager.
  2. Expand "SQL Server Network Configuration" > "Protocols for".
  3. Find the protocol you want to view the port number for, then right-click and select "Properties".

The above is the detailed content of How to check the port number of sqlserver. For more information, please follow other related articles on the PHP Chinese website!

Statement
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

Hot AI Tools

Undresser.AI Undress

Undresser.AI Undress

AI-powered app for creating realistic nude photos

AI Clothes Remover

AI Clothes Remover

Online AI tool for removing clothes from photos.

Undress AI Tool

Undress AI Tool

Undress images for free

Clothoff.io

Clothoff.io

AI clothes remover

AI Hentai Generator

AI Hentai Generator

Generate AI Hentai for free.

Hot Article

R.E.P.O. Energy Crystals Explained and What They Do (Yellow Crystal)
3 weeks agoBy尊渡假赌尊渡假赌尊渡假赌
R.E.P.O. Best Graphic Settings
3 weeks agoBy尊渡假赌尊渡假赌尊渡假赌
R.E.P.O. How to Fix Audio if You Can't Hear Anyone
3 weeks agoBy尊渡假赌尊渡假赌尊渡假赌
WWE 2K25: How To Unlock Everything In MyRise
4 weeks agoBy尊渡假赌尊渡假赌尊渡假赌

Hot Tools

PhpStorm Mac version

PhpStorm Mac version

The latest (2018.2.1) professional PHP integrated development tool

MantisBT

MantisBT

Mantis is an easy-to-deploy web-based defect tracking tool designed to aid in product defect tracking. It requires PHP, MySQL and a web server. Check out our demo and hosting services.

WebStorm Mac version

WebStorm Mac version

Useful JavaScript development tools

Notepad++7.3.1

Notepad++7.3.1

Easy-to-use and free code editor

MinGW - Minimalist GNU for Windows

MinGW - Minimalist GNU for Windows

This project is in the process of being migrated to osdn.net/projects/mingw, you can continue to follow us there. MinGW: A native Windows port of the GNU Compiler Collection (GCC), freely distributable import libraries and header files for building native Windows applications; includes extensions to the MSVC runtime to support C99 functionality. All MinGW software can run on 64-bit Windows platforms.