Solved

How to Block SQL server 7 Port 1433 on windows 2000 server.

Posted on 2009-05-13
8
487 Views
Last Modified: 2012-05-06
I have a question regarding the SQL Server(SQL Server 7) port 1433.
Is there a way i can close this port? I tried using secpol.msc and blocked access to the port 1433 for all IP addresses, but
using SQL Entrprise manager i am still able to connect to this server remotely. Has anyone come across this problem?
0
Comment
Question by:TechGuy100
  • 4
  • 4
8 Comments
 
LVL 69

Expert Comment

by:Qlemo
ID: 24376613
Why would you want this? If the server should not be reachable at all, you can disable TCP and Named Pipes for it, that way only local connections with Shared Memory can be established.
0
 

Author Comment

by:TechGuy100
ID: 24377016
This is an old server with blank "sa" password and if the password is changed one of the web applications "Local" to the server stops working .
 So, i  want that nobody can connect to the server remotely. I want to "block" the port from all IP addresses .
I tried disabling TCP 1433 and UDP 1434 ports using secpol.msc but still i am able to connect using SQl enterprise manger from a remote computer.
0
 
LVL 69

Expert Comment

by:Qlemo
ID: 24377100
Did you see this statement: "you can disable TCP and Named Pipes for it, that way only local connections with Shared Memory can be established."?

SecPol restrictions will be useless.


0
Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

 

Author Comment

by:TechGuy100
ID: 24377251
Yes, i saw your statement that  i can disable TCP and named pipes, but i "might" need to give access to this SQL server remotely for 2-3 specific IP / Servers.
 Is it possible through secpol restrictions or something else ( except a hardware firewall ).
0
 
LVL 69

Expert Comment

by:Qlemo
ID: 24377913
No. You need a software firewall at least. Another way: disable MSSQL Browser service, change standard port in TCP settings of MSSQL, and use that port to connect (append the port after a comma to the server name in your connect string). That is not safe, but keeps unsophisticated connect attempts away.
0
 

Author Comment

by:TechGuy100
ID: 24377973
Qllemo thanks a lot  for your comments, i will try that, but could you please explain why "secpol exceptions will be useless" and if possible can you suggest any software firewall for this purpose.
0
 
LVL 69

Accepted Solution

by:
Qlemo earned 500 total points
ID: 24378159
SecPol IP filter lists are applied to IPSec Policies only, AFAIK.

Good firewalls are Comodo, Kerio / Sunbelt or PC Tools (while I'm not keen on using the latter one).
0
 

Author Comment

by:TechGuy100
ID: 24425148
Ultimately I was able to block port 1433 access by using "local Area Connection" properties --> TCP/IP-->Properties --> Advanced -->Options-->TCP/IP filtering--> Properties   & allowing only the specific ports we needed. It requires a restart after changing the settings.
0

Featured Post

Free Webinar: AWS Backup & DR

Join our upcoming webinar with experts from AWS, CloudBerry Lab, and the Town of Edgartown IT to discuss best practices for simplifying online backup management and cutting costs.

Question has a verified solution.

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

Let's review the features of new SQL Server 2012 (Denali CTP3). It listed as below: PERCENT_RANK(): PERCENT_RANK() function will returns the percentage value of rank of the values among its group. PERCENT_RANK() function value always in be…
Introduction SQL Server Integration Services can read XML files, that’s known by every BI developer.  (If you didn’t, don’t worry, I’m aiming this article at newcomers as well.) But how far can you go?  When does the XML Source component become …
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.

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