We help IT Professionals succeed at work.

SQL 2005 forced to listen on non-standard port now doesn't allow telnet connections.

dgarner58
dgarner58 asked
on
301 Views
Last Modified: 2012-05-08
I have a server that is running MS SQL 2000 and MS SQL 2005. The 2000 server has been there a long time and has multiple applications talking to it over the default 1433 port. The SQL 2005 install is using an instance <servname\instancename> which by default uses dynamic ports. I have forced the instance to use port 2433 instead of the dynamic - however i cannot telnet to this instance using port 2433. There is no firewall in place and just to test i also set everything back to dynamic - restarted SQL Server 2005 and tried to telnet using the dynamic port that it acquires - still no telnet. I had read that SQL 2000 and 2005 could live together in harmony on the same box. Is this not the case????
Comment
Watch Question

Raja Jegan RSQL Server DBA & Architect, EE Solution Guide
CERTIFIED EXPERT
Awarded 2009
Distinguished Expert 2019

Commented:
Just set the TCP Dynamic Ports to Blank instead of 0(Zero) to make it listen on the static port 2433 assigned in your SQL Server Configuration Manager.

Author

Commented:
yes, i did that...the server was actually configured to listen on ALL so in the IPALL settings i removed the 0 and put 2433 in as the static port. This seemed to take according to the error log. I even went so far as to change the default port for clients in the Configuration Manager.

Does it help or hurt that the browser server is running?

Also - i should note, the reason that this is important (the non-standard port) is because we are allowing inbound connections through our firewall over port 2433. If i can't telnet over port 2433 to the server on the LAN however, i don't see how anyone on the other side of the firewall would have any more luck.

Author

Commented:
okay i think i figured this out...

it didn't occur to me that doing: telnet hostname/instancename port wouldn't work. if i telnet hostname port it works fine.

so telnet hostname 1433 gets me sql 2000
and
telnet hostname 2433 gets me sql 2005

Hopefully that is how it's supposed to work...because it seemingly does...

Commented:
From the SQL Server Configuration Manager
Expand SQL Server 2005 Network Configuration, right click TCP/IP and than configure TCP Port value for the IP All.

you have to restart your SQL Service to apply the changes.
     
img01.jpg

Author

Commented:
yes, i did that.
what i ultimately did was this...

i turned off listen on all and enabled the ip's i wanted specifically. i blanked out the dynamic box and put 2433 in the TCP Port box.

i then tried my telnet and it failed, but i believe it was because i was putting the instancename in the telnet test. when i leave the instancename out...it works.
Raja Jegan RSQL Server DBA & Architect, EE Solution Guide
CERTIFIED EXPERT
Awarded 2009
Distinguished Expert 2019

Commented:
I think you confused the IP settings for both the instances...
For your 2000 Instance, it should be listening on 1433 only for IP1, IP2 and IPAll.
For your 2005 Instance, it should be listening on 2433 only for IP1, IP2 and IPAll.

Kindly Check in your SQL Server configuration manager and you would have separate properties for both instance..
Setting these values and restarting your SQL Server services should help
SQL Server DBA & Architect, EE Solution Guide
CERTIFIED EXPERT
Awarded 2009
Distinguished Expert 2019
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION

Gain unlimited access to on-demand training courses with an Experts Exchange subscription.

Get Access
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Empower Your Career
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.