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.