How Do I Block Port 1434 - Need Simple And Clear Answer

[simple25]

I've been looking through sites to see if anyone could provide the correct steps to block port 1434, which is a MSSQL port.

NOBODY and I mean NOBODY was smart enough to give a clear and simple answer. The question again is...

HOW DO I BLOCK PORT 1434?

*** answers include the following:
Go to your firewall....
You don't need to block it...
Technically you don't want to block it...
You need to get windows service pack...

[Edited out SHOUTING comment]

[azimmer]

If you stop shouting and calm down you may want to give us more hints (e.g. why would it be impossible to block it through the firewall -- that's pretty normal...)

Smart people search if do not know something.

Read this: http://support.microsoft.com/kb/813878 It may still not be what you're after since we know very little of what you want (but know a pletora of what you do not...)

This is also worth reading (although longish compared to your apparent patience): http://msdn2.microsoft.com/en-us/lib...#c18618429_015

[space1000]

Cool down. I don't have to know the reason why you want to block the port nor why the firewall doesn't want to do that for you. Simply open your network card properties and have a look into the advanced properties. You can block ports on the nic.

[simple25]

I've done so much searching. Pretty much everybody digresses from the question or they give answers that are very unclear, or they direct me to a website with 10 pages of information.

Pardon my frustration, but when you search and search and you can't find an answer to your problem you're not exactly high as a kite. And when everyone dodges the question or gives you a pathetic one-liner answer, that makes my blood boil.

I would like only simple, clear, and step by step information, like a recipe for baking a cake.

NEW QUESTION: Is there a way I can block port 1434 without using IPsec?

What I've done so far in my firewall is go to Traffic Monitoring and clicked on Port Settings. Then I added port 1434 to be monitored in the Monitor Selected Ports list.

[simple25]

Cool down. I don't have to know the reason why you want to block the port nor why the firewall doesn't want to do that for you. Simply open your network card properties and have a look into the advanced properties. You can block ports on the nic.

See this is what I mean. Unclear and vague answers like these are exactly what's wrong with today's forums. You can have 1000 people in a forum and about 90% will give you a **** answer like this.

Lets look at why this answer is so ****...

"simply open your network card properties"
What is "SIMPLY" to you may not be for someone else. Therefore, clear and step by step instructions are important when dealing with problems.

"network card properties"
Is the option you are wanting me to click actually specifically called, "NETWORK CARD PROPERTIES?"
Use the correct name when you are helping people.

"Have a look in advanced properties."
OKAY, GREAT IM AT ADVANCED PROPERTIES. PROBLEM SOLVED! -- NOT!
When I get to advanced properties what am I supposed to see?
Where am I supposed to go?


Please any other people smarter than this who can give me hand?

[MMcCarthy]

OK simple25

There are very strict guidelines when posting on this forum. You can find these here. The use of bad language is not tolerated and I've edited your previous posts accordingly. You are also required to treat the experts with respect. They volunteer their time and don't deserve to be abused for offering to help.

To the point of your post. This is not my area of expertise but for someone who is giving out about experts not giving clear step by step instructions your original post is in itself not very clear. If you repost your question with a clear explanation of your problem. Why you are encountering it? What solutions you have tried so far? Indicate your lack of expertise in this area to the experts so they know to give more detailed instructions.

Experts don't normally give step by step instructions as it is not usually necessary and can be felt to be patronising by most posters. However, they are usually happy to do so if they are politely asked to.

You will receive a lot more assistance on this forum if you revise your attitude and start treating the experts with respect. I would suggest you start by apologising to the particpants in this thread.

ADMIN

[simple25]

OK simple25

There are very strict guidelines when posting on this forum. You can find these here. The use of bad language is not tolerated and I've edited your previous posts accordingly. You are also required to treat the experts with respect. They volunteer their time and don't deserve to be abused for offering to help.

To the point of your post. This is not my area of expertise but for someone who is giving out about experts not giving clear step by step instructions your original post is in itself not very clear. If you repost your question with a clear explanation of your problem. Why you are encountering it? What solutions you have tried so far? Indicate your lack of expertise in this area to the experts so they know to give more detailed instructions.

Experts don't normally give step by step instructions as it is not usually necessary and can be felt to be patronising by most posters. However, they are usually happy to do so if they are politely asked to.

You will receive a lot more assistance on this forum if you revise your attitude and start treating the experts with respect. I would suggest you start by apologising to the particpants in this thread.

ADMIN

I'm not trying to abuse anybody. I am being honest and frank. If you're an expert and you're here to help others, you can at least be clear in your instructions. I mean, it really isn't that hard. I'm here to look for a solution.
It is as simple as PROBLEM = THIS, therefore SOLUTION = THIS!
Honestly, there aren't very many people, expert or not, who know how to give clear and concise answers that effectively solve the problem. I mean, that is TRUTH.

NOW TO THE PROBLEM:
"Why you are encountering it? What solutions you have tried so far? Indicate your lack of expertise in this area to the experts so they know to give more detailed instructions."

__I am encountering it because there is a new worm going out that is attacking through port 1434 MSSQL. Which is why I want to block this port.

__Solutions I've tried so far are going to my firewall (I DON'T USE WINDOWS FIREWALL) in my Kaspersky Anti-virus and monitoring the port. I don't know if this blocks it or not.

My level of expertise = YOU WON'T OFFEND ME IF YOU GIVE ME A CLEAR CONCISE AND STEP BY STEP SOLUTION. BUT YOU WILL OFFEND ME IF YOU GIVE ME A SOLUTION OF EXTREMELY POOR QUALITY. SET PERSONAL EGO ASIDE AND LETS SOLVE THIS PROBLEM.

1 + 1 = ?

SOLUTION = 2!

[MMcCarthy]

I think my post was very clear and I have no interest in entering into a dialog with you on this. Any further abuse of the experts could result in your account being banned.

You have at least provided further information about your problem. The experts may be able to help if you haven't offended them so much that they have no interest in trying.

ADMIN

[mp328]

1. Press the windows key and the letter "M" (the letter M is between N and > on your keyboard) at the same time. This will minimize all of the open windows.
2. Take control of the mouse with your hand.
3. Right click on Network Neighborhood or My Network Places and left click properties.
4. Right click on the connection you wish to see the properties for -most likely labeled local area connection.
5. Left click on properties.
6. Select TCP/IP by scrolling through the installed components and left clicking once.
7. Left click the properties button below the installed components.
8. Left click the advanced tab.
9. Left click the options tab.
10. Left click once on TCP/IP Filtering.
11. Click properties.
12. Enable filtering (check the box)
13. Select Permit only and add the ports you need to allow in the TCP and UDP sections.
14. Apologize to the ADMIN. You offer nothing. They deliver, and deliver free of charge.

[simple25]

1. Press the windows key and the letter "M" (the letter M is between N and > on your keyboard) at the same time. This will minimize all of the open windows.
2. Take control of the mouse with your hand.
3. Right click on Network Neighborhood or My Network Places and left click properties.
4. Right click on the connection you wish to see the properties for -most likely labeled local area connection.
5. Left click on properties.
6. Select TCP/IP by scrolling through the installed components and left clicking once.
7. Left click the properties button below the installed components.
8. Left click the advanced tab.
9. Left click the options tab.
10. Left click once on TCP/IP Filtering.
11. Click properties.
12. Enable filtering (check the box)
13. Select Permit only and add the ports you need to allow in the TCP and UDP sections.
14. Apologize to the ADMIN. You offer nothing. They deliver, and deliver free of charge.

Great Reply!
I LOVE YOU ADMIN AND EVERYONE HERE!

I understand your point of view. Nobody likes a jerk. But sometimes you gotta do what you gotta do, even if you lose friends. And I had to do something to change the atmosphere here. We need guidelines and structure in answering technical questions. That is very important and we don't have that.

I believe that every response should be like this.
It is hierarchical, clear, and detailed. THUMBS UP ON THAT!

One problem though... it kind of doesn't answer my question. When I get to the very end, I have to add all the ports I need to allow. There are so many and...

1. How do I know what ports I need to allow?

2. Is entering every single one of them really the best way?

3. Doesn't the use of ports change from a day to day basis based upon the computer activities you do?

Based upon my thinking, I wanted to enter in the port number somewhere and have it be blocked. Why wouldn't a system allow it to be done this way?

[JamieHowarth0]

Hi there,

Right, first things first, us users need some basic info about your SQL Server setup to help you:
1) What version of SQL Server are you running?
2) Are you using SQL Server Enterprise Manager or SQL Management Studio to administer your database server?
3) Are you using a firewall (including Windows Firewall and/or any hardware firewalls/routers in your network setup)?

Once you provide this information I can help you further with step-by-step instructions to block your 1434 port.

Thanks,

medicineworker

[Plater]

There are times when I wonder why people bother to help.
This guy's saying "give me simple answers", someone gives a simple answer and there is complaining that "what is is simply I don't get it".
If you act like that in real life I can't believe anyone would even spit on you if you were on fire.

[simple25]

There are times when I wonder why people bother to help.
This guy's saying "give me simple answers", someone gives a simple answer and there is complaining that "what is is simply I don't get it".
If you act like that in real life I can't believe anyone would even spit on you if you were on fire.

What the hell are you talking about? Spit on fire? You sound like a true idiot. Why do you even bother to post your stupid comment. It isn't helping and it just makes you stand out like a dunce. Sometimes I wonder why people even bother to say something stupid, when they should know better to shut their mouths.

[simple25]

Hi there,

Right, first things first, us users need some basic info about your SQL Server setup to help you:
1) What version of SQL Server are you running?
2) Are you using SQL Server Enterprise Manager or SQL Management Studio to administer your database server?
3) Are you using a firewall (including Windows Firewall and/or any hardware firewalls/routers in your network setup)?

Once you provide this information I can help you further with step-by-step instructions to block your 1434 port.

Thanks,

medicineworker

I'm not using SQL server.
I not using SQL anything.
I am using firewall provided by my anti-virus not windows.
I can't seem to close port 1434 to prevent virus worms.
There's gotta be a way.

[MMcCarthy]

As you have posted your question in the SQL Server forum you can understand the confusion.