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 vote253 views1 answer
Postgres first_value in gropby
SQL
0 vote253 views1 answer
Get db connection detail from sql developer profile
SQL
0 vote264 views1 answer
Postgres meta command to show all rows in table
SQL
1 vote283 views2 answers
Duplicate key value violates unique constraint "django_admin_log_pkey"
SQL
0 vote247 views2 answers
Mysql disable foreign key checks
SQL
0 vote253 views1 answer
Ignore case in string sql
SQL
4 votes269 views1 answer
Oracle error line
SQL
0 vote251 views1 answer
FIND AVERAGE SALARY EARNER IN SQL
SQL
1 vote254 views1 answer
Sql server 2016 reseed identity
SQL
0 vote251 views1 answer
Create new schema mysql
SQL