3

Why can I connect to SQL port 1433 locally, but not remotely?

view full story
linux-howto

http://serverfault.com – I have a pair of EC2 servers, one IIS, one SQL 2008. This morning, the web app started complaining that the SQL server "doesn't exist". Upon investigation, I found SQL doesn't appear to be accepting connections on port 1433. From the web server, I have tried connecting various ports via telnet (80, 445, 3389) all without issue. However "telnet [SQL IP] 1433" fails. I have verified SQL is listening on 1433: C:\>netstat -a |findstr 1433 TCP 0.0.0.0:1433 ip-0A30XXX2:0 LISTENING TCP [::]:1433 ip-0A30XXX2:0 LISTENING The really weird part i (HowTos)

grtyyu's picture
Submitted by grtyyu on 07/30/2012 – Made popular on 07/30/2012

Stories similar to Why can I connect to SQL port 1433 locally, but not remotely?

I wonder how to connect remote_db server from localhost.

I have remote database remote_db. The remote db has configured to accept incoming connection from middle_server.

I can ssh middle_server. I also can remote_db from middle_server on port 1433.

I know there exists ssh tunneling where I can connect remote_db using middle_server.

I found about a dozen questions like this, read them all, but still can't find the problem.

I have a dedicated server running SQL Server 2008 R2 express.

I have Windows 2008 box and would like to set port forward rule in Windows Firewall for MSSQL Server.

I'm running Microsoft SQL Express 2008 on a Windows 2012 Server box. Got everything work, and I even manage to connect with the firewall down. But I dont really want the firewall turned off at all times so what port do I need to open up?

I've allready have the two inbound rules with TCP port 1433 and 1434 but I still seem to be missing something?

I have sql server express 2012 installed on windows 2008, locally everything works just fine i can connect via tcpip and named pipes. Remotely i can connect with ssms only using named pipes.

I have tried disabling the firewall on both sides to eliminate blocking traffic.

amazon EC2 windows RDP timeout 40 weeks 2 days ago

i've created a brand new Windows 2008 R2 EC2 instance with the following security group:

21 0.0.0.0/0 Delete 80 (HTTP) 0.0.0.0/0 Delete 1024 - 1048 0.0.0.0/0 Delete 1433 (MS SQL) 0.0.0.0/0 Delete 3389 (RDP) 0.0.0.0/0 Delete

nonetheless, i am unable to connect to it with remote desktop.

i get a timeout. i tried with telnet - same results.

i saw some amazon documentation

SCCM cannot connect to SQL 50 weeks 3 days ago

I'm trying to install SCCM on my machine, but for some reason, I get this error:

I think I've tried everything listed in the tutorials...

I restarted my SQL-service My account is a sysadmin I'm not using Dynamic ports I've changed the default port to 1433 (the default one) I've enables named pipes

But still no result... Any more ideas?

Here is my log:

In our development environment, we have numerous named instances of SQL Server 2008 running. I have recently added a new one it doesn't work as expected.

I'm tired of searching with no result i don't know where the problem come from , i'm trying to connect my android app with the local SQl server 2008, now i get unable to get information from sql server.