?
Solved

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

Posted on 2009-05-13
8
Medium Priority
?
503 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 4
8 Comments
 
LVL 70

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 70

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
Veeam Disaster Recovery in Microsoft Azure

Veeam PN for Microsoft Azure is a FREE solution designed to simplify and automate the setup of a DR site in Microsoft Azure using lightweight software-defined networking. It reduces the complexity of VPN deployments and is designed for businesses of ALL sizes.

 

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 70

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 70

Accepted Solution

by:
Qlemo earned 2000 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

Get 15 Days FREE Full-Featured Trial

Benefit from a mission critical IT monitoring with Monitis Premium or get it FREE for your entry level monitoring needs.
-Over 200,000 users
-More than 300,000 websites monitored
-Used in 197 countries
-Recommended by 98% of users

Question has a verified solution.

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

For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
In part one, we reviewed the prerequisites required for installing SQL Server vNext. In this part we will explore how to install Microsoft's SQL Server on Ubuntu 16.04.
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.
Suggested Courses

741 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