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 vote135 views1 answer
Greater than or equal to symbol in postgres
SQL
0 vote143 views1 answer
How to find database collation in postgres
SQL
0 vote136 views1 answer
Low level operator in dbms
SQL
0 vote142 views1 answer
Python mysql show databases
SQL
0 vote146 views1 answer
Sql '=' cannot be applied to date varchar(10) athena
SQL
22 votes144 views6 answers
Create sql table
SQL
0 vote140 views1 answer
Datagrip go to line
SQL
1 vote134 views1 answer
Mysql get latest duplicate rows
SQL
3 votes181 views1 answer
Sql several or
SQL
0 vote128 views1 answer
Python mysql query where
SQL