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

1 vote147 views2 answers
Postgresql remote connect
SQL
0 vote176 views5 answers
How to make trigger in phpmyadmin
SQL
8 votes161 views1 answer
Database backup in mysql server recovery
SQL
0 vote165 views1 answer
Set Mamp mysql globally
SQL
18 votes136 views3 answers
Mysql current date
SQL
0 vote145 views1 answer
Rename constraint postgresql
SQL
0 vote145 views1 answer
Migration graphql
SQL
-1 vote145 views1 answer
Concat two columns in sql server
SQL
1 vote146 views1 answer
Postgresql escape single quote
SQL
1 vote156 views2 answers
Drop table with constraints
SQL