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

3 votes179 views1 answer
Alembic.util.exc.CommandError: Target database is not up to date.
SQL
7 votes176 views3 answers
Foreign key oracle
SQL
1 vote317 views1 answer
Athena query timestamp greater than
SQL
8 votes168 views1 answer
Oracle find text in functions
SQL
31 votes173 views1 answer
Postgresql add column with constraint
SQL
0 vote176 views1 answer
Configure: error: Cannot find libpq-fe.h. Please specify correct PostgreSQL installation path
SQL
0 vote170 views1 answer
Denormalise SQL command
SQL
0 vote179 views1 answer
Port 5432 is already in use Usually this means that there is already a PostgreSQL server running on your Mac. If you want to run multiple servers simultaneously, use different ports.
SQL
0 vote174 views1 answer
Sql server check whether column has same equal values
SQL
0 vote185 views1 answer
Postgres change the name of schema
SQL