Block external access

From: twiggy (etwilegar@ttgonline.com)
Date: 09/16/02 

From: "twiggy" <etwilegar@ttgonline.com>
Date: Mon, 16 Sep 2002 13:35:03 -0700

I don't believe there is a way to do this. SQL has never
had IP restrictions. The best you can do is use a
firewall, or use good password restrictions.

et

>-----Original Message-----
>Hi,
>
>I know this is probably day one stuff, but can someone
tell me how to setup
>a SQL7 server that wont allow access from external IP
addresses. I just
>want to use the Enterprise manager on the desktop, and
dont want remote
>Enterprise managers to be able to connect to it.
>
>Thanks,
>Laurence
>
>
>.
>

Relevant Pages

  • Re: Full Text Indexing Option Disabled
    ... If your firewall prevents the Enterprise Manager from working, ... SQL Full Text Search Blog ... > log onto the server locally before the fulltext options are available. ...
    (microsoft.public.sqlserver.fulltext)
  • Re: newbie Frage zu Server-Explorer - Datenverbindungen
    ... "Microsoft SQL Server " an. ... Ich könnte den Firewall wohl ausschalten, da die Maschine via Proxi ins Netz geht. ... Ich versuche doch nur - lokal innerhalb meiner eigenen Machine - auf der ich als Admin arbeite - hinzubekommen, dass der Servername (oder meinetwegen auch lokal oder was angezeigt wird. ... Im SQL Server Configuration Manager habe ich Shared Memory, Named Pipes, UND TCP/IP Aktiviert. ...
    (microsoft.public.de.german.entwickler.dotnet.datenbank)
  • Re: ReportIoError 2 - any ideas?
    ... job - then modify the schedule as required. ... using DBCC SHRINKFILE to reduce the ldf file size. ... Rerunning the backups through Enterprise Manager. ... My colleagues know even less about SQL Server ...
    (microsoft.public.sqlserver.server)
  • Re: software needed to input data
    ... ENTERPRISE MANAGER give you a simple one table at a time ... Your programmer might have proprietary rights to the ... >If you are database savvy, you can always get into SQL ...
    (microsoft.public.sqlserver.server)
  • Maybe the Records Are There After All
    ... The indication that the records were DELETED is that Server Enterprise ... Type in Server Enterprise Manager and then was making notes and documenting ... the larger database from last night STILL SAYS that it has ZERO records ... Is there some way to monitor the things that SQL is doing in the BACKGROUND ...
    (microsoft.public.sqlserver.server)
Quantcast