Get Sql Server 2012 Port and connection details

Get Sql Server 2012 Port and connection details
2 votes, 5.00 avg. rating (96% score)

Introduction

This article covers how to get the port Sql Server is connected to and its connection details

 USE master GO XP_READERRORLOG 0, 1, N'Server is listening' GO 


image

So, 1035 is the port the sql server 2012 is listening to

The same thing can be viewed from Network configuration

Go To

Sql Server Configuration Manger> “SQL Server Network Configuration”-> Protocol for “SQLServerInstance”-> right click “TCP/IP” > properties


image

(sql server instance name will vary)


image

Its a good practice to give different port. The default port is 1433.

We can also check in eventlogs

Run > eventvwr

Under Application> Filter current log with the word ‘Server is listening on’

It will then show the events with port number


image

July 23, 2015 · Adi · No Comments
Tags: , ,  · Posted in: General, Sharepoint 2010, SharePoint 2013, SQL

Leave a Reply

What is 14 + 4 ?
Please leave these two fields as-is:
IMPORTANT! To be able to proceed, you need to solve the following simple math (so we know that you are a human) :-)