Sensory Computer Systems Forums Index Sensory Computer Systems Forums
Welcome to the Sensory Computer Systems Online Forums!
 
 FAQFAQ   SearchSearch   RegisterRegister 
 ProfileProfile   Log inLog in   
   Sensory Computer Systems Home   

SQL Server Port 1433 and Windows Firewall

 
Post new topic   Reply to topic    Sensory Computer Systems Forums Index -> Installation / Setup / Hardware
View previous topic :: View next topic  
Author Message
ForumAdmin
Site Admin


Joined: May 20 2005
Posts: 120
Location: New Jersey

PostPosted: Wed Oct 23, 2013 11:14 am    Post subject: SQL Server Port 1433 and Windows Firewall Reply with quote


How to: Configure a data host PC Windows Firewall for SQL Database Access

Option A: Easy one line command

    C:> netsh advfirewall firewall add rule name="SQL Server" dir=in action=allow protocol=TCP localport=1433
or

Option B: Manually To open port 1433 in the Windows firewall for TCP access:

    1. Open Windows Control Panel, Windows Firewall. Or Start menu, click Run, type WF.msc.

    2. In the Windows Firewall with Advanced Security, in the left pane, right-click Inbound Rules, and then click New Rule in the action pane.

    3. In the Rule Type dialog box, select Port, and then click Next.

    4. In the Protocol and Ports dialog box, select TCP. Select Specific local ports, and then type the port number 1433. Click Next.

    5. In the Action dialog box, select Allow the connection, and then click Next.

    6. In the Profile dialog box, select any profiles that describe the computer connection environment when you want to connect to the Database Engine, and then click Next.

    7. In the Name dialog box, type a name such as "SQLServer" and any description/notes for this rule, and then click Finish.

All Windows versions.

References:
http://technet.microsoft.com/en-us/library/ms175043






Last edited by ForumAdmin on Tue Mar 04, 2014 8:45 am; edited 5 times in total

Back to top
View user's profile
ForumAdmin
Site Admin


Joined: May 20 2005
Posts: 120
Location: New Jersey

PostPosted: Wed Oct 23, 2013 11:45 am    Post subject: Command Line Reply with quote


Netsh Command Line:

SQL Server ports:
netsh advfirewall firewall add rule name="SQL Server" dir=in action=allow protocol=TCP localport=1433
netsh advfirewall firewall add rule name="SQL Admin Connection" dir=in action=allow protocol=TCP localport=1434
netsh advfirewall firewall add rule name="SQL Service Broker" dir=in action=allow protocol=TCP localport=4022
netsh advfirewall firewall add rule name="SQL Debugger/RPC" dir=in action=allow protocol=TCP localport=135

May need to turn Firewall off/on to see changes immediately.

Allowing Pings (ICMP Echo Request) Through Your Windows Firewall:
netsh advfirewall firewall add rule name="ICMP Allow incoming V4 echo request" protocol=icmpv4:8,any dir=in action=allow
Old syntax: netsh firewall set icmpsetting 8

Firewall Enable/Disable On/Off:
netsh advfirewall set allprofiles state on
netsh advfirewall set allprofiles state off

Parameter notes:
If profile is not specified, the default is any.

Query:
netsh advfirewall firewall show rule name=all

Reference:
http://windowsitpro.com/windows-server/top-10-windows-firewall-netsh-commands
Netsh advfirewall command reference:
http://technet.microsoft.com/en-us/library/dd734783.aspx
Netsh command reference:
http://technet.microsoft.com/en-us/library/cc771920.aspx



Last edited by ForumAdmin on Fri Mar 07, 2014 4:01 pm; edited 2 times in total

Back to top
View user's profile
ForumAdmin
Site Admin


Joined: May 20 2005
Posts: 120
Location: New Jersey

PostPosted: Fri Mar 07, 2014 4:00 pm    Post subject: TELNET Port 1433 Test Reply with quote


Telnet Usage Notes

For Testing SQL PORT 1433 Telnet.exe is a standard windows file located in C:\Windows\System32\


C:\> Telnet 192.168.1.123 1433


Success looks like a blank white screen. You’re successfully in a live terminal session.


To Exit Telnet session:
CTRL-] will get you to the “Welcome to Microsoft Telnet Client Console” screen as shown below, then type “Quit”
Microsoft Telnet> Quit
CTRL-F5 will abrupt exit Telnet to C: prompt, may have to hit it twice.




This is what failure looks like:

C:\> Telnet 192.168.1.123 1433
Connecting To 192.168.1.123 ... Could not open connection to the host, on port 1433: Connect failed

C:\>



C:\> Telnet

Welcome to Microsoft Telnet Client Console

Escape Character is 'CTRL+]'


Microsoft Telnet>
Microsoft Telnet> ?

Commands may be abbreviated. Supported commands are:

c - close close current connection
d - display display operating parameters
o - open hostname [port] connect to hostname (default port 23).
q - quit exit telnet
set - set set options (type 'set ?' for a list)
sen - send send strings to server
st - status print status information
u - unset unset options (type 'unset ?' for a list)
?/h - help print help information



From that Telnet client console interface:

Microsoft Telnet> open 192.168.1.55 1433
Connecting To 192.168.1.55...

Success looks just like that Connecting 192.168.1.55 To… line, you’re successfully in a live terminal session.


This is what failure looks like:

Microsoft Telnet> open 192.168.1.55 1533
Connecting To 192.168.1.55...Could not open connection to the host, on port 1533: Connect failed



Common Ports:

20 FTP data (File Transfer Protocol)
21 FTP (File Transfer Protocol)
22 SSH (Secure Shell)
23 Telnet
25 SMTP (Send Mail Transfer Protocol)
43 whois
53 DNS (Domain Name Service)
68 DHCP (Dynamic Host Control Protocol)
79 Finger
80 HTTP (HyperText Transfer Protocol)
110 POP3 (Post Office Protocol, version 3)
115 SFTP (Secure File Transfer Protocol)
119 NNTP (Network New Transfer Protocol)
123 NTP (Network Time Protocol)
137 NetBIOS-ns
138 NetBIOS-dgm
139 NetBIOS
143 IMAP (Internet Message Access Protocol)
161 SNMP (Simple Network Management Protocol)
194 IRC (Internet Relay Chat)
220 IMAP3 (Internet Message Access Protocol 3)
389 LDAP (Lightweight Directory Access Protocol)
443 SSL (Secure Socket Layer)
445 SMB (NetBIOS over TCP)


Ports between 1024 and 29151 are known as the Registered Ports. Basically, programs are supposed to register their use of these ports and thereby try to be careful and avoid stomping on each other. Here are some common ports and their programs.

1243 SubSeven (Trojan - security risk!)
1352 Lotus Notes
1433 Microsoft SQL Server
1494 Citrix ICA Protocol
1521 Oracle SQL
1604 Citrix ICA / Microsoft Terminal Server
2049 NFS (Network File System)
3306 mySQL
4000 ICQ
5010 Yahoo! Messenger
5190 AOL Instant Messenger
5632 PCAnywhere
5800 VNC
5900 VNC


Your Team at SIMS Sensory Panel Software

Last edited by ForumAdmin on Thu Dec 09, 2021 10:46 am; edited 1 time in total

Back to top
View user's profile
ForumAdmin
Site Admin


Joined: May 20 2005
Posts: 120
Location: New Jersey

PostPosted: Fri Mar 07, 2014 4:07 pm    Post subject: TELNET Port 1433 Test Reply with quote


Enable Telnet

By default, Telnet Client is not enabled in Windows 7. To enable it, you have to add the Telnet Client Windows Feature.

- From Control Panel, click on Programs

- Under Programs and Features, click on Turn Windows Features on or off

- From the Windows Features window, using the slider, scroll down till you reach Telnet Client, select the checkbox beside it, then click on OK

- To confirm that Telnet is installed, open command prompt and type telnet /?


http://social.technet.microsoft.com/wiki/contents/articles/910.enabling-telnet-client-in-windows-7.aspx


Back to top
View user's profile
Display posts from previous:   
Post new topic   Reply to topic    Sensory Computer Systems Forums Index -> Installation / Setup / Hardware All times are GMT - 5 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group