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 vote273 views1 answer
SQL Cut part string
SQL
0 vote270 views1 answer
How we can perform acid Operations in sql with examples
SQL
3 votes263 views1 answer
Define REGEXP?
SQL
0 vote242 views1 answer
How to update random rows in sql
SQL
0 vote270 views1 answer
Automated psql csv export script on windows
SQL
0 vote203 views1 answer
Sqlalchemy existing database
SQL
0 vote262 views1 answer
Str_to_date sql server
SQL
2 votes241 views3 answers
How to get second highest salary in each department in sql
SQL
18 votes273 views3 answers
Get the list of all tables in sql server
SQL
1 vote252 views1 answer
Full sql mode
SQL