Help - I can't shut off Remote Connections
- From: "John Kotuby" <JohnKotuby@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Tue, 31 Jul 2007 14:18:30 -0400
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...
.
- Prev by Date: Re: Duplicating a user
- Next by Date: SQL 2005 Password Changes
- Previous by thread: Re: Duplicating a user
- Next by thread: SQL 2005 Password Changes
- Index(es):
Relevant Pages
|
|
