Solved

Port 1433 not Listening

Posted on 2013-12-26
3
2,462 Views
Last Modified: 2013-12-26
A new server just implemented (Server 2012 std).   AD role migrated from old server and have all user accounts, passwords, data.

New install of SQL 2012 and configured correctly by SQL application vendor.  

We cannot get the server to listen on Port 1433.  Server does listen on numerous other ports and can telnet to other ports.   SQL can connect on the server via the SA login.

We have tested or done the following:
Added rules for Port 1433 in the server firewall
Added Port 1433 to SQL settings
Rules for port added to router
No issues with IIS
No other applications, antivirus or other firewall on the server

At this point we still cannot listen on the server for Port 1433 nor telnet.   At this point we are at a lose for options.
0
Comment
Question by:rtfcomputing1
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 22

Expert Comment

by:Patrick Bogers
ID: 39740219
Hi

Rule out by elimination:
Run    netstat -anb -p tcp     is port 1433 listening? If not SQL is probably not configured well, how did you add port 1433 to SQL server?
Is listening? Is it listening for SQL server?

Is listening?
Temporarelly disable the firewall, can you connect? The firewall rules arent well configured.

Cant connect from the outside? Change is port forwarding isnt correctly installed.
Can you connect with SSMS from within that network?
0
 
LVL 14

Accepted Solution

by:
comfortjeanius earned 500 total points
ID: 39740232
Are your configuration for the SQL Server Configuration Manager are correct?

If not you can double check from this link Configure a Server to Listen on a Specific TCP Port (SQL Server Configuration Manager) and How to enable remote connection.
0
 

Author Closing Comment

by:rtfcomputing1
ID: 39740290
We did have TCP/IP turned on.  However for whatever reason as the article stated Dynamic Ports were set to 0.   Once I configured each protocol to listen specifically for 1433 we were able to telnet and have the application talk to SQL properly from the workstation.  

MSDN article # 177440
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Log files are useful in diagnosing and repairing problems.  This is a list of common log files and their standard locations that I've compiled.   While this is not exhaustive, it is a pretty good list that I've found to be useful.  I may update it f…
When you upgrade from Windows 8 to 8.1 or to Windows 10 or if you are like me you are on the Insider Program you may find yourself with many 450MB recovery partitions.  With a traditional disk that may not be a problem but with relatively smaller SS…
This video Micro Tutorial explains how to clone a hard drive using a commercial software product for Windows systems called Casper from Future Systems Solutions (FSS). Cloning makes an exact, complete copy of one hard disk drive (HDD) onto another d…
Windows 8 comes with a dramatically different user interface known as Metro. Notably missing from the new interface is a Start button and Start Menu. Many users do not like it, much preferring the interface of earlier versions — Windows 7, Windows X…

749 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question