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

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> 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?
Yes, but typically not recommended. Without a firewall in place explicitly
allowing that specific IP in, your database is exposed to everyone on the
Internet.
So, the question on my mind is, have you tried it?
A|||Thanks a lot.
But can you please tell me which port should I open?
Regards,
Peri
"Tracy McKibben" <tracy@.realsqlguy.com> wrote in message
news:uXu0vpemGHA.2316@.TK2MSFTNGP04.phx.gbl...
> Peri wrote:
> 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.

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.