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

2 votes356 views2 answers
Install postgresql
SQL
0 vote446 views1 answer
Delet all record statment sql
SQL
0 vote434 views1 answer
Compress sql file database ubuntu
SQL
0 vote359 views1 answer
How to find table lock and row lock in mysql
SQL
1 vote347 views1 answer
Mysql illegal mix of collations for operation 'join'
SQL
2 votes330 views1 answer
Match in sql server
SQL
0 vote365 views2 answers
Oracle create tablespace autoextend
SQL
10 votes363 views3 answers
Join multiple tables sql
SQL
0 vote350 views1 answer
Drop constraint in ms sql
SQL
5 votes340 views1 answer
Oracle get nls settings
SQL