March 30, 2015 at 2:57 pm
Hi SQL Guys, need some help on understanding the ports.
On one of the production SQL servers i found ports
IP1 - IP6 as 1433 active and not enabled and IP all as 3456
All dynamic ports are disabled.
but i am able to connect to SQL Server without using any extension MSSQL;3456
How is this possible?
if we are using the different port then we must connect to 3456 right during the login.
Also when i am using this command
USE master
GO
xp_readerrorlog 0, 1, N'Server is listening on'
GO
2015-03-20 19:44:35.230 Server Server is listening on [ 'any' <ipv6> 3456].
2015-03-20 19:44:35.230 Server Server is listening on [ 'any' <ipv4> 3456].
2015-03-20 19:44:35.250 Server Server is listening on [ ::1 <ipv6> 1434].
2015-03-20 19:44:35.250 Server Server is listening on [ 147.0.0.1 <ipv4> 1434].
March 31, 2015 at 1:19 am
IPAll sets the port for all IP addresses.
Another method to discover TCP ports is by using netstat:
netstat -abno
You should have some rows returned for sqlservr.exe: note down the PID and look it up in the services applet or configuration manager to correlate it to a specific instance of SQL Server.
In your case, it looks like the instance is running on ports 3456 and 1434. The SQLServer Browser service might be running and redirecting you on the correct port (which is strange, since the browser service is not queried for the default port). Try to see if disabling the browser changes the behavior.
-- Gianluca Sartori
March 31, 2015 at 7:26 am
thanks Guys. On one of the server browser is running and on the other server it is not.
I am getting the same results on both the servers.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply