Re: Configure MSDE 2000 for Internet

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Hi,

comments inline:

HTH,

--
Greg Low [MVP]
MSDE Manager SQL Tools
www.whitebearconsulting.com

"Allcomp" <marc@xxxxxxxxxxxxxxxxx> wrote in message
news:4256496e$0$8656$ba620e4c@xxxxxxxxxxxxxxxxx
> Hello,
>
> Thank you, it is working perfectly.
> Do you know any mean to forbid an IP address after 3 failed attempts?
GREG> Not via SQL Server or the MSDE.

> Is it possible to deactivate the sa login from Internet and not from the
> LAN?
GREG> Not really but suggest you don't use it anyway.

>
> After that, I will try to use the encryption.
> As I must use a named instance, the multi protocol is not possible.
> Do you know where I can find informations on the encryption without the
> multi protocol?
> Is it possible to only encrypt with a connection by Internet and not
> with a local one (for speed?)
GREG> Read up on exposing an SSL port for SQL Server

>
>
> Thank you
> Marc Allard
> Allcomp
>
>
> Greg Low [MVP] wrote:
>> Hi Mark,
>>
>> Far easiest option is to not use dynamic port addressing. Run
>> svrnetcn.exe,
>> disable dynamic port selection for that instance, specify an unused (and
>> unlikely) port like 34879, open it, close all the other ones you've
>> opened,
>> and restart the MSDE.
>>
>> On the client, run cliconfg.exe and set up an alias to that IP address
>> and
>> port number for the name of the server.
>>
>> ENSURE YOUR SECURITY CONFIGURATION ON THE MSDE BOX IS GOOD AND YOU ARE AT
>> LEAST AT SP3A. (Sorry, had to make that very clear :-)
>>
>> And you should be up and going.
>>
>> HTH,
>>


.

Relevant Pages

  • Re: Actual risk of opening port 1433
    ... SQL Authentication is very insecure. ... Every hacker in the world knows that port 1433 is a standard SQL port and ... MSDE runs with LocalSystem permissions. ... Your outside users access the internal network using a secure VPN. ...
    (microsoft.public.sqlserver.security)
  • Re: MSDE vs Windows XP PRO firewall
    ... >>> MSDE does not require file level access, ... >>> and only requires port 1433 to remotely access the databases. ... >> a sql problem. ... There is no reason to expose a server to ports that are not ...
    (microsoft.public.windowsxp.help_and_support)
  • Re: Understanding differences between licensing (CALs) and Connections for MSDE
    ... MSDE Manager SQL Tools ... GREG> Not if they're only accessing the MSDE. ... GREG> No limit exists on connections. ...
    (microsoft.public.sqlserver.clients)
  • Re: verwendeter Port der MSDE abfagen?
    ... Da steht dann auch irgendwo "Server listening on"... ... einem:NET Programm und auch nicht mit einem SQL Server Manager Express. ... Mein Verdacht ist nun, das die MSDE auf einem andern Port läuft, wie kann ... gibt es da einen T-SQL Befehl um den Port zu ermitteln? ...
    (microsoft.public.de.sqlserver)
  • Re: How can I find the port SQL SERVER 2000 is listening on?
    ... MSDE Manager SQL Tools ... > I am having trouble connecting ColdFusion to sql server 2000. ... > have more than one Instance you need to find the port. ...
    (microsoft.public.sqlserver.msde)