Help - I can't shut off Remote Connections

Hello all and thanks for any help...
I have just looked into the Event Viewer on our leased Windows Server
running Windows Server 2003 Enterprise Edition and SQL Server 2005 Standard.
I was shocked to see numerous attempts over the last 3 days (hundreds of
them) trying to log into our SQL Server. Unfortunately only the Failed
attempts were logged.
I was under the impression that be default, SQL Server 2005 is installed to
NOT allow remote connections, which I interpret as connections over the
public internet.
When I looked into Properties/Connections for the server instance I was
again shocked to see that "Allow remote connections" was checked. So I tried
logging into our SQL Server via the internet and got in immediately.
I then unchecked the option to allow remote connections and restarted the
server.
Apparently I don't understand what that option means, because I can still
log in via the internet using the public IP address of the Web Server.
I can only shut the SQL Server down for a short period of time.
Can somebody tell me what option I must configure to stop the ability to log
in via the public internet?
Thanks to all...John
By default SQL Server is listening to 1433 port.You can change it to prevent
(among with other thing you have already mentioned) to log into from the
internet
"John Kotuby" <JohnKotuby@.discussions.microsoft.com> wrote in message
news:uvTki550HHA.4712@.TK2MSFTNGP04.phx.gbl...
> Hello all and thanks for any help...
> I have just looked into the Event Viewer on our leased Windows Server
> running Windows Server 2003 Enterprise Edition and SQL Server 2005
> Standard. I was shocked to see numerous attempts over the last 3 days
> (hundreds of them) trying to log into our SQL Server. Unfortunately only
> the Failed attempts were logged.
> I was under the impression that be default, SQL Server 2005 is installed
> to NOT allow remote connections, which I interpret as connections over the
> public internet.
> When I looked into Properties/Connections for the server instance I was
> again shocked to see that "Allow remote connections" was checked. So I
> tried logging into our SQL Server via the internet and got in immediately.
> I then unchecked the option to allow remote connections and restarted the
> server.
> Apparently I don't understand what that option means, because I can still
> log in via the internet using the public IP address of the Web Server.
> I can only shut the SQL Server down for a short period of time.
> Can somebody tell me what option I must configure to stop the ability to
> log in via the public internet?
> Thanks to all...
>