Get Sql Server 2012 Port and connection details
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
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
(sql server instance name will vary)
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
July 23, 2015
·
Adi ·
No Comments
Tags: Default sql server port, Sql Server Network Configuration, sql server port · Posted in: General, Sharepoint 2010, SharePoint 2013, SQL
Leave a Reply