Ping a Specific Port

Question

Androme

Asked: 2010-09-29 23:33:27 +0800 CST2010-09-29 23:33:27 +0800 CST 2010-09-29 23:33:27 +0800 CST

Remote MS SQL 2008 connections

772

Hello i am having problems setting my MS SQL server up so i can connect to it remotely. I have enabled remote access in the SQL Server itself, and enabled TCP connections in the config manager. And i have added an allow on port 1433 in the windows firewall! But when i try to connect nothing. I then tried to disable the firewall complete, and suddenly i was able to connect, so the problem must be in the firewall. But what else then adding an allow on port 1433 in the inbound section must i set up before the firewall will allow remote access to my ms sql server?

        C:\Windows\system32>netstat -a -b

Active Connections

  Proto  Local Address          Foreign Address        State
  TCP    0.0.0.0:21             DoomServer:0           LISTENING
 [FileZilla Server.exe]
  TCP    0.0.0.0:25             DoomServer:0           LISTENING
 [hMailServer.exe]
  TCP    0.0.0.0:80             DoomServer:0           LISTENING
 Can not obtain ownership information
  TCP    0.0.0.0:110            DoomServer:0           LISTENING
 [hMailServer.exe]
  TCP    0.0.0.0:135            DoomServer:0           LISTENING
  RpcSs
 [svchost.exe]
  TCP    0.0.0.0:143            DoomServer:0           LISTENING
 [hMailServer.exe]
  TCP    0.0.0.0:445            DoomServer:0           LISTENING
 Can not obtain ownership information
  TCP    0.0.0.0:1433           DoomServer:0           LISTENING
 [sqlservr.exe]
  TCP    0.0.0.0:3306           DoomServer:0           LISTENING
 [mysqld.exe]
  TCP    0.0.0.0:3389           DoomServer:0           LISTENING
  TermService
 [svchost.exe]
  TCP    0.0.0.0:8080           DoomServer:0           LISTENING
 Can not obtain ownership information
  TCP    0.0.0.0:10080          DoomServer:0           LISTENING
 [nginx.exe]
  TCP    0.0.0.0:10080          DoomServer:0           LISTENING
 [nginx.exe]
  TCP    0.0.0.0:10080          DoomServer:0           LISTENING
 [nginx.exe]
  TCP    0.0.0.0:10080          DoomServer:0           LISTENING
 [nginx.exe]
  TCP    0.0.0.0:10080          DoomServer:0           LISTENING
 [nginx.exe]
  TCP    0.0.0.0:10080          DoomServer:0           LISTENING
 [nginx.exe]
  TCP    0.0.0.0:10080          DoomServer:0           LISTENING
 [nginx.exe]
  TCP    0.0.0.0:10080          DoomServer:0           LISTENING
 [nginx.exe]
  TCP    0.0.0.0:10080          DoomServer:0           LISTENING
 [nginx.exe]
  TCP    0.0.0.0:10080          DoomServer:0           LISTENING
 [nginx.exe]
  TCP    0.0.0.0:10080          DoomServer:0           LISTENING
 [nginx.exe]
  TCP    0.0.0.0:10080          DoomServer:0           LISTENING
 [nginx.exe]
  TCP    0.0.0.0:10080          DoomServer:0           LISTENING
 [nginx.exe]
  TCP    0.0.0.0:10080          DoomServer:0           LISTENING
 [nginx.exe]
  TCP    0.0.0.0:10080          DoomServer:0           LISTENING
 [nginx.exe]
  TCP    0.0.0.0:10080          DoomServer:0           LISTENING
 [nginx.exe]
  TCP    0.0.0.0:10080          DoomServer:0           LISTENING
 [nginx.exe]
  TCP    0.0.0.0:10080          DoomServer:0           LISTENING
 [nginx.exe]
  TCP    0.0.0.0:10080          DoomServer:0           LISTENING
 [nginx.exe]
  TCP    0.0.0.0:10080          DoomServer:0           LISTENING
 [nginx.exe]
  TCP    0.0.0.0:10080          DoomServer:0           LISTENING
 [nginx.exe]
  TCP    0.0.0.0:10080          DoomServer:0           LISTENING
 [nginx.exe]
  TCP    0.0.0.0:10080          DoomServer:0           LISTENING
 [nginx.exe]
  TCP    0.0.0.0:10080          DoomServer:0           LISTENING
 [nginx.exe]
  TCP    0.0.0.0:47001          DoomServer:0           LISTENING
 Can not obtain ownership information
  TCP    0.0.0.0:49152          DoomServer:0           LISTENING
 [wininit.exe]
  TCP    0.0.0.0:49153          DoomServer:0           LISTENING
  eventlog
 [svchost.exe]
  TCP    0.0.0.0:49154          DoomServer:0           LISTENING
  Schedule
 [svchost.exe]
  TCP    0.0.0.0:49155          DoomServer:0           LISTENING
 [lsass.exe]
  TCP    0.0.0.0:49157          DoomServer:0           LISTENING
 [services.exe]
  TCP    0.0.0.0:52309          DoomServer:0           LISTENING
  PolicyAgent
 [svchost.exe]
  TCP    127.0.0.1:14147        DoomServer:0           LISTENING
 [FileZilla Server.exe]
  TCP    127.0.0.1:14147        DoomServer:52055       ESTABLISHED
 [FileZilla Server.exe]
  TCP    127.0.0.1:14147        DoomServer:57096       TIME_WAIT
  TCP    127.0.0.1:14147        DoomServer:57097       TIME_WAIT
  TCP    127.0.0.1:14147        DoomServer:57098       TIME_WAIT
  TCP    127.0.0.1:14147        DoomServer:57099       TIME_WAIT
  TCP    127.0.0.1:14147        DoomServer:57100       TIME_WAIT
  TCP    127.0.0.1:14147        DoomServer:57101       TIME_WAIT
  TCP    127.0.0.1:14147        DoomServer:57102       TIME_WAIT
  TCP    127.0.0.1:14147        DoomServer:57103       TIME_WAIT
  TCP    127.0.0.1:14147        DoomServer:57104       TIME_WAIT
  TCP    127.0.0.1:14147        DoomServer:57105       TIME_WAIT
  TCP    127.0.0.1:14147        DoomServer:57106       TIME_WAIT
  TCP    127.0.0.1:14147        DoomServer:57107       TIME_WAIT
  TCP    127.0.0.1:14147        DoomServer:57108       TIME_WAIT
  TCP    127.0.0.1:14147        DoomServer:57109       TIME_WAIT
  TCP    127.0.0.1:14147        DoomServer:57110       TIME_WAIT
  TCP    127.0.0.1:14147        DoomServer:57111       TIME_WAIT
  TCP    127.0.0.1:14147        DoomServer:57112       TIME_WAIT
  TCP    127.0.0.1:14147        DoomServer:57113       TIME_WAIT
  TCP    127.0.0.1:14147        DoomServer:57114       TIME_WAIT
  TCP    127.0.0.1:14147        DoomServer:57115       TIME_WAIT
  TCP    127.0.0.1:14147        DoomServer:57116       TIME_WAIT
  TCP    127.0.0.1:14147        DoomServer:57117       TIME_WAIT
  TCP    127.0.0.1:14147        DoomServer:57118       TIME_WAIT
  TCP    127.0.0.1:14147        DoomServer:57119       TIME_WAIT
  TCP    127.0.0.1:14147        DoomServer:57120       TIME_WAIT
  TCP    127.0.0.1:14147        DoomServer:57121       TIME_WAIT
  TCP    127.0.0.1:14147        DoomServer:57122       TIME_WAIT
  TCP    127.0.0.1:14147        DoomServer:57123       TIME_WAIT
  TCP    127.0.0.1:14147        DoomServer:57124       TIME_WAIT
  TCP    127.0.0.1:14147        DoomServer:57125       TIME_WAIT
  TCP    127.0.0.1:14147        DoomServer:57126       TIME_WAIT
  TCP    127.0.0.1:14147        DoomServer:57127       TIME_WAIT
  TCP    127.0.0.1:14147        DoomServer:57128       TIME_WAIT
  TCP    127.0.0.1:14147        DoomServer:57129       TIME_WAIT
  TCP    127.0.0.1:14147        DoomServer:57130       TIME_WAIT
  TCP    127.0.0.1:14147        DoomServer:57131       TIME_WAIT
  TCP    127.0.0.1:14147        DoomServer:57132       TIME_WAIT
  TCP    127.0.0.1:14147        DoomServer:57133       TIME_WAIT
  TCP    127.0.0.1:14147        DoomServer:57134       TIME_WAIT
  TCP    127.0.0.1:14147        DoomServer:57135       TIME_WAIT
  TCP    127.0.0.1:14147        DoomServer:57136       TIME_WAIT
  TCP    127.0.0.1:14147        DoomServer:57137       TIME_WAIT
  TCP    127.0.0.1:14147        DoomServer:57138       TIME_WAIT
  TCP    127.0.0.1:14147        DoomServer:57139       TIME_WAIT
  TCP    127.0.0.1:14147        DoomServer:57140       TIME_WAIT
  TCP    127.0.0.1:14147        DoomServer:57141       TIME_WAIT
  TCP    127.0.0.1:14147        DoomServer:57142       TIME_WAIT
  TCP    127.0.0.1:14147        DoomServer:57143       TIME_WAIT
  TCP    127.0.0.1:14147        DoomServer:57145       TIME_WAIT
  TCP    127.0.0.1:14147        DoomServer:57146       TIME_WAIT
  TCP    127.0.0.1:14147        DoomServer:57147       TIME_WAIT
  TCP    127.0.0.1:14147        DoomServer:57148       TIME_WAIT
  TCP    127.0.0.1:14147        DoomServer:57149       TIME_WAIT
  TCP    127.0.0.1:14147        DoomServer:57151       TIME_WAIT
  TCP    127.0.0.1:14147        DoomServer:57152       TIME_WAIT
  TCP    127.0.0.1:14147        DoomServer:57153       TIME_WAIT
  TCP    127.0.0.1:14147        DoomServer:57154       TIME_WAIT
  TCP    127.0.0.1:14147        DoomServer:57155       TIME_WAIT
  TCP    127.0.0.1:14147        DoomServer:57157       TIME_WAIT
  TCP    127.0.0.1:14147        DoomServer:57158       TIME_WAIT
  TCP    127.0.0.1:14147        DoomServer:57161       TIME_WAIT
  TCP    127.0.0.1:14147        DoomServer:57162       TIME_WAIT
  TCP    127.0.0.1:14147        DoomServer:57163       TIME_WAIT
  TCP    127.0.0.1:14147        DoomServer:57167       TIME_WAIT
  TCP    127.0.0.1:14147        DoomServer:57168       TIME_WAIT
  TCP    127.0.0.1:14147        DoomServer:57169       TIME_WAIT
  TCP    127.0.0.1:14147        DoomServer:57170       TIME_WAIT
  TCP    127.0.0.1:14147        DoomServer:57171       TIME_WAIT
  TCP    127.0.0.1:14147        DoomServer:57172       TIME_WAIT
  TCP    127.0.0.1:52055        DoomServer:14147       ESTABLISHED
 [FileZilla Server Interface.exe]
  TCP    127.0.0.1:57159        DoomServer:3306        TIME_WAIT
  TCP    127.0.0.1:60422        DoomServer:60423       ESTABLISHED
 [hMailServer.exe]
  TCP    127.0.0.1:60423        DoomServer:60422       ESTABLISHED
 [hMailServer.exe]
  TCP    188.40.55.84:80        gw:57672               ESTABLISHED
 Can not obtain ownership information
  TCP    188.40.55.84:110       mail-gy0-f131:53479    TIME_WAIT
  TCP    188.40.55.84:139       DoomServer:0           LISTENING
 Can not obtain ownership information
  TCP    188.40.55.84:3389      dtv254:62866           ESTABLISHED
  TermService
 [svchost.exe]
  TCP    188.40.55.84:51899     cds62:http             CLOSE_WAIT
 [Download_for_SQL_Server_2008_R2_Web_(x86_x64_ia64)_DVD_en.exe]
  TCP    188.40.55.84:51901     cds62:http             ESTABLISHED
 [Download_for_SQL_Server_2008_R2_Web_(x86_x64_ia64)_DVD_en.exe]
  TCP    [::]:80                DoomServer:0           LISTENING
 Can not obtain ownership information
  TCP    [::]:135               DoomServer:0           LISTENING
  RpcSs
 [svchost.exe]
  TCP    [::]:445               DoomServer:0           LISTENING
 Can not obtain ownership information
  TCP    [::]:1433              DoomServer:0           LISTENING
 [sqlservr.exe]
  TCP    [::]:3389              DoomServer:0           LISTENING
  TermService
 [svchost.exe]
  TCP    [::]:8080              DoomServer:0           LISTENING
 Can not obtain ownership information
  TCP    [::]:47001             DoomServer:0           LISTENING
 Can not obtain ownership information
  TCP    [::]:49152             DoomServer:0           LISTENING
 [wininit.exe]
  TCP    [::]:49153             DoomServer:0           LISTENING
  eventlog
 [svchost.exe]
  TCP    [::]:49154             DoomServer:0           LISTENING
  Schedule
 [svchost.exe]
  TCP    [::]:49155             DoomServer:0           LISTENING
 [lsass.exe]
  TCP    [::]:49157             DoomServer:0           LISTENING
 [services.exe]
  TCP    [::]:52309             DoomServer:0           LISTENING
  PolicyAgent
 [svchost.exe]
  TCP    [2002:bc28:3754::bc28:3754]:1433  DoomServer:57166       ESTABLISHED
 [sqlservr.exe]
  TCP    [2002:bc28:3754::bc28:3754]:57166  DoomServer:ms-sql-s    ESTABLISHED
 [TfsJobAgent.exe]
  UDP    0.0.0.0:123            *:*
  W32Time
 [svchost.exe]
  UDP    0.0.0.0:500            *:*
  IKEEXT
 [svchost.exe]
  UDP    0.0.0.0:1434           *:*
 [sqlbrowser.exe]
  UDP    0.0.0.0:4500           *:*
  IKEEXT
 [svchost.exe]
  UDP    0.0.0.0:5355           *:*
  Dnscache
 [svchost.exe]
  UDP    127.0.0.1:55354        *:*
 [Download_for_SQL_Server_2008_R2_Web_(x86_x64_ia64)_DVD_en.exe]
  UDP    188.40.55.84:137       *:*
 Can not obtain ownership information
  UDP    188.40.55.84:138       *:*
 Can not obtain ownership information
  UDP    [::]:123               *:*
  W32Time
 [svchost.exe]
  UDP    [::]:500               *:*
  IKEEXT
 [svchost.exe]
  UDP    [::]:1434              *:*
 [sqlbrowser.exe]
  UDP    [::]:4500              *:*
  IKEEXT
 [svchost.exe]
  UDP    [::]:5355              *:*
  Dnscache
 [svchost.exe]

C:\Windows\system32>

2 Answers

Voted

Chris W · Answer 1 · 2010-09-29T23:52:26+08:00

Best Answer

Chris W

2010-09-29T23:52:26+08:002010-09-29T23:52:26+08:00

A daft question but is the SQL Server actually listening on 1433?

If it's a named instance of SQL Express for example it may be listening on a different port entirely which you either need to specify in the connection string, configure in the client config or have the SQL Browser service running and available to redirect connections.

The SQL Browser service listens on port 1434.

2

Adrian Hand · Answer 2 · 2010-09-30T00:25:07+08:00

Adrian Hand

2010-09-30T00:25:07+08:002010-09-30T00:25:07+08:00

You can check the port that SQL server is really listening on with an elevated command prompt and:

netstat -a -b

Then, as DoomStone says, bung the port in your connection string.

0

Remote MS SQL 2008 connections

Ping a Specific Port

How do I tell Git for Windows where to find my private RSA key?

How do you restart php-fpm?

What's the default superuser username/password for postgres after a new install?

What port does SFTP use?

Resolve host name from IP address

How can I sort du -h output by size

Command line to list users in a Windows Active Directory group?

What is a Pem file and how does it differ from other OpenSSL Generated Key File Formats?

How to determine if a bash variable is empty?