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 vote183 views1 answer
Stop mysql server mac
SQL
4 votes236 views1 answer
Rename stored procedure in sql server
SQL
0 vote207 views1 answer
Sql server separar numeros por comas miles
SQL
1 vote285 views1 answer
How to fetch data in between startfromdate to starenddate in sql
SQL
0 vote222 views1 answer
Client does not support authentication protocol requested by server sqlyog
SQL
0 vote217 views1 answer
How to define a non primary composite key in sql
SQL
10 votes211 views2 answers
Rtrim sql
SQL
13 votes201 views2 answers
Get tables in database sql
SQL
1 vote196 views1 answer
Sql trigger before delete
SQL
0 vote216 views2 answers
Starts and end with vowel sql
SQL