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

2 votes201 views2 answers
Sqlalchemy filter or
SQL
0 vote215 views1 answer
Mysql grant grant option
SQL
0 vote213 views1 answer
How to list function in psql
SQL
0 vote218 views2 answers
Mysql insert into multiple tables
SQL
-1 vote195 views1 answer
Search all database tables for a value sqlserver
SQL
4 votes204 views1 answer
Oracle show errors
SQL
0 vote204 views1 answer
Sql remove last 2 digit
SQL
1 vote214 views1 answer
Change default maximum runtime mariadb from phpmyadmin
SQL
0 vote234 views1 answer
Datagrip go to line
SQL
1 vote213 views1 answer
Convert epoch to date in sql server
SQL