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 vote367 views1 answer
How to add unique key constraint in mysql
SQL
0 vote349 views1 answer
Search In the Data using ObjectName
SQL
1 vote335 views2 answers
Mysql update table from another table
SQL
2 votes355 views1 answer
Date conversion in mysql column
SQL
1 vote365 views4 answers
Alter schema sql
SQL
12 votes370 views4 answers
How to take database dump in postgresql
SQL
1 vote383 views5 answers
Postgresql difference between two dates in days
SQL
0 vote361 views1 answer
Oracle free up space in tablespace
SQL
16 votes343 views1 answer
CTE statement sql server
SQL
0 vote369 views1 answer
Change magento database url usimg musql
SQL