Sql server port number

Sql server check port number

USE master
GO
xp_readerrorlog 0, 1, N'Server is listening on' 
GO

#LogDate	ProcessInfo	Text
#...		Server		Server is listening on [ ::1 <ipv6> 1434].
#2..		Server		Server is listening on [ 127.0.0.1 <ipv4> 1434].

Sql server port number

By default SQL Server listens on TCP port number 1433, but for named instances the TCP port is dynamically configured. There are several options available to get the listening port for a SQL Server named instance.

Source: popdock.com

Similar codes

0 vote187 views1 answer
Mariadb list tables
SQL
18 votes221 views3 answers
Mysql number format
SQL
-1 vote221 views1 answer
Search all database tables for a value sqlserver
SQL
23 votes223 views6 answers
How to create table in sql
SQL
1 vote200 views1 answer
Sequence item 6 expected str instance bytes found mysql workbench
SQL
3 votes225 views1 answer
Postgresql today - 1 year
SQL
1 vote215 views1 answer
Error code 1055
SQL
0 vote230 views1 answer
Copy column from one table to another without column duplicate postgres
SQL
0 vote234 views1 answer
Mysql select random rows large table
SQL
0 vote208 views1 answer
Mysql query single row
SQL