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 vote322 views1 answer
Composit key in sql
SQL
1 vote319 views1 answer
Local sql server
SQL
1 vote348 views1 answer
Best sql course
SQL
0 vote321 views1 answer
Sql not exists
SQL
12 votes329 views1 answer
Psql drop column
SQL
0 vote298 views1 answer
Postgres delete where id in
SQL
-2 votes322 views3 answers
Oracle tablespace usage
SQL
0 vote322 views1 answer
Get number of tables in database sql
SQL
5 votes309 views3 answers
Truncate function in sql oracle
SQL
0 vote354 views1 answer
Postgre query date
SQL