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

11 votes334 views1 answer
Ddl view
SQL
0 vote326 views1 answer
Https://livesql.oracle.com/apex/livesql/s/l8fedwph53gt5gigbacwvu6m0
SQL
2 votes313 views1 answer
Laravel sql String
SQL
0 vote318 views1 answer
Plpgsql raise notice
SQL
0 vote320 views1 answer
PSQL use LIKE with timestamps
SQL
0 vote316 views2 answers
Postgres having
SQL
-1 vote330 views3 answers
MySQL shutdown unexpectedly
SQL
5 votes333 views1 answer
Oracle nls session
SQL
0 vote323 views1 answer
Oracle list partitions
SQL
0 vote340 views1 answer
Pl/pgsql declare variable
SQL