Link to home
Create AccountLog in
Avatar of labdunn
labdunn

asked on

Can't connect to SQL Server on port 1433

I have a fresh install of SQL Server 2008 R2 on a Windows Server 2008 R2 box.  I can connect to the database using the SSMS but I can’t establish a connection from an application I’m trying to install.    For a test I’m using telnet 10.0.0.4 1433 and it never connects.

I have disabled the Windows Firewall.

In SS Configuration Manager I have verified the TCP/IP is enabled in SQL Native Client 10.0 Configuration.  The default port here is 1433.

The SQL Native Client 10.0 Configuration (32bit) also has TCP/IP enabled and set to port 1433.

I also checked in the Configuration Manager > SQL Server Network Configuration > Protocols for databaseinstance.  TCP/IP is enabled here as well.  Here it lists IP1, IP2, IP3, IP4, …  They seem to be settings for IPv6 and IPv4.  The IPv4 setting is Active and Enabled.  The TCP port was originally blank after the installation.  I also tried using 1433 in that field.

I have run netstat –a and see no instance of port 1433.

Thanks for your help.
Avatar of bigbigpig
bigbigpig

In Config Manager - under the TCP/IP properties under IP All, or the specific IP you're binding to, does it say TCP Port 1433?

Have you restarted the SQL Server service for that instance since doing these changes?
ASKER CERTIFIED SOLUTION
Avatar of bigbigpig
bigbigpig

Link to home
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
See answer
Avatar of labdunn

ASKER

The bottom IP All was the ticket.  Thanks!