Solved

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

Posted on 2009-05-13
8
476 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 68

Expert Comment

by:Qlemo
Comment Utility
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
Comment Utility
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 68

Expert Comment

by:Qlemo
Comment Utility
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
 

Author Comment

by:TechGuy100
Comment Utility
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
Highfive Gives IT Their Time Back

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

 
LVL 68

Expert Comment

by:Qlemo
Comment Utility
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
Comment Utility
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 68

Accepted Solution

by:
Qlemo earned 500 total points
Comment Utility
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
Comment Utility
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

Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

Join & Write a Comment

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…
Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

728 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

Need Help in Real-Time?

Connect with top rated Experts

9 Experts available now in Live!

Get 1:1 Help Now