March 30, 2015 at 3:07 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.230ServerServer is listening on [ 'any' <ipv6> 3456].
2015-03-20 19:44:35.230ServerServer is listening on [ 'any' <ipv4> 3456].
2015-03-20 19:44:35.250ServerServer is listening on [ ::1 <ipv6> 1434].
2015-03-20 19:44:35.250ServerServer is listening on [ 147.0.0.1 <ipv4> 1434].
March 30, 2015 at 11:49 pm
Hi There,
Do you have SQL Browser running ? It's needed to direct traffic to not standard ports I.E Not 1433
The fact you can connect when using MSSQL,3456 suggests it's not firewall related
Other thing to try is in SQL Server Config manager go to the protocols for you instance and right click on TCP/IP properties. Wipe out all the Dynamic Ports or TCP Ports in IP1 - 6 so nothing exists in these fields. Then ensure IPALL only specifies TCP Port TCP Dynamic Port should be blank.
Even thou IP1 - 6 are set to not enabled I've seen issues in the past when these fields contain values.
Corinne
March 31, 2015 at 1:21 am
Duplicate post: http://www.sqlservercentral.com/Forums/FindPost1672886.aspx
In SQL Server 2012 you can query a DMV that was absent in 2008 to discover tcp ports:
SELECT *
FROM sys.dm_tcp_listener_states
-- Gianluca Sartori
March 31, 2015 at 3:09 am
If Edward has are read it accounts men are due out the username and I just be contacted on there I tyro respond at one in not so timely matters truth Jan that's probably the best two ways to contact your find out more about either read it or just examine itself great okay.
well thank you very much for joining us tonight and I was very interesting information I’ll definitely be listening to this song on this interview at another time is round two to go through everything on and I courage Iran also watching to check out of them to calm and I get all the Curtis Frank if you have any questions thank .
For more information please contact us at --> > >> > > > http://www.optimalstackfacts.org/garcinia-forte/
March 31, 2015 at 7:32 am
Thanks Guys.
I am able to connect to sql server by using port number as suffix during login.
The SQL Server browser is enabled on one server and not on other
But i am getting the same results.
If i wanted to use both default port and custom port, what happens if i put the values 1433, 3456 in IP all tcp/ip ports?
one of the database wants to connect to 1433 and all others to 3456
what will be effects to other databases. any security issues?
March 31, 2015 at 8:15 am
nagkarjun1 (3/31/2015)
If i wanted to use both default port and custom port, what happens if i put the values 1433, 3456 in IP all tcp/ip ports?
It won't work. You need to create another endpoint.
Here's how to do it: https://msdn.microsoft.com/en-us/library/ms189310.aspx
one of the database wants to connect to 1433 and all others to 3456
what will be effects to other databases. any security issues?
You can grant or revoke connect to any endpoint to any user you find appropriate.
-- Gianluca Sartori
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy