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 vote125 views1 answer
Get last updated row sql server
SQL
0 vote111 views2 answers
Postgres default user
SQL
4 votes124 views1 answer
Group by mysql and concatenate string
SQL
0 vote140 views2 answers
Plpgsql
SQL
0 vote142 views1 answer
Create table with timestamp mysql youtube
SQL
1 vote117 views1 answer
How to select all attributes from a row if there is a certain string in it MySQL
SQL
20 votes117 views3 answers
SQL query rename table
SQL
0 vote126 views1 answer
Sql declare variable single line
SQL
15 votes121 views2 answers
How to drop database name in postgresql
SQL
5 votes279 views2 answers
How to ascending order in sql
SQL