Can we connect to SQL server 2000 through Internet using a static

Peri wrote:
> Dear All,
> Can we connect to SQL Server 2000 through internet using static ip?
> We have a static IP in our office and we would like one of our customer to
> connect to our database using this static IP. Is this possible?
> Regards,
> Peri
>
Certainly possible, but use extreme caution. Doing this will require an
open port through your firewall. Opening that port will expose your
server to the outside world. I would HIGHLY recommend configuring a
firewall rule to allow ONLY connections from your customer's IP to
connect to the newly opened port. Get your network people involved to
make sure this is done securely.Peri wrote:
> Thanks a lot.
> But can you please tell me which port should I open?
> Regards,
> Peri
>
Unless you changed it during the SQL Server install, it's the default
port 1433. Confirm with "netstat -a" at the command prompt.