SQL Server – Check The Port Configured in SQL Server

  By ,

Use the script below to find the tcp port number that the SQL Server is listening on.

SELECT local_tcp_port
FROM   sys.dm_exec_connections
WHERE  session_id = @@SPID
GO

 

Knowledge worth sharing...Share on linkedin
Linkedin
Share on facebook
Facebook
Share on google
Google
Share on twitter
Twitter

Related posts:

  1. SQL SERVER – Database Instant File Initialization
  2. SQL Server – Check if “Enforce Password Policy” is On Using TSQL
  3. SQL Server – Script to Check Plan Cache Bloat
  4. SQL Server – Check Database Mirroring Status
Tagged  , , , , , , , , , , , , .
Bookmark the permalink.

Leave a Reply

Leave a Reply

Your email address will not be published. Required fields are marked *