change port

Hi all,
I did see that I have 72.000 attempt to invade my SQL by default port, i
would like how change sql default port, and what more I can do to eliminate
this.
Have way to I specific the IP that I want alow connection.
Thanks to allChanging the port is easy. You can just go to the server network utility on
the SQL Server server and change it to something else. You then want to
identify what servers and machines should be able to get information from th
e
server. Get with the nextwork guys and have them limit the communication to
the IP/Port based on the list you have identified.
BTW, they can probably help you find out who is failing the connection. You
really need to figure that out, regardless of whether you change ports or no
t.
--
MeanOldDBA
derrickleggett@.hotmail.com
http://weblogs.sqlteam.com/derrickl
When life gives you a lemon, fire the DBA.
"retf" wrote:

> Hi all,
> I did see that I have 72.000 attempt to invade my SQL by default port, i
> would like how change sql default port, and what more I can do to eliminat
e
> this.
> Have way to I specific the IP that I want alow connection.
> Thanks to all
>
>