SQL Server: Get database port

#windows #tutorial #database

The default port of SQL Server is 1433. But I can be different in some installations.

In order to get the port the SQL Server is listening, we can execute the following query:

xp_readerrorlog 0, 1, N'Server is listening on'

2024-11-14 03:10:12.140 spid22s Server is listening on [ 'any' <ipv6> 57510].
2024-11-14 03:10:12.140 spid22s Server is listening on [ 'any' <ipv4> 57510].
2024-11-14 03:10:12.140 Server  Server is listening on [ ::1 <ipv6> 57511].
2024-11-14 03:10:12.140 Server  Server is listening on [ 127.0.0.1 <ipv4> 57511].
2024-11-14 03:10:12.150 spid22s Server is listening on [ ::1 <ipv6> 63454].
2024-11-14 03:10:12.150 spid22s Server is listening on [ 127.0.0.1 <ipv4> 63454].

As we can see, the query is showing the server is listening to port 57510 from any IP address.