How can I access my Microsoft SQL Server 2000 through internet?

[robert_v]

How can I access my Microsoft SQL Server 2000 through internet?

For example, I set up a Microsoft SQL Server in one of computers of my company, and every computer in my company has its own IP .They are in the same workgroup. Now, there is no problem with database access with another computer in my company. But when I try to access the database through a computer out of my company, I failed.

Can ou tell my how to access it through a computer out of my company?

Thanks

[tridom]

Are you trying to access it using Enterprise Manager......ADO.....Query Analyzer....DNS?

Also, what is the error if there is one?

[robert_v]

I use ADO and VB's Data Environment in my program. the error is I can not connect to the server.
Do u know how to do it?

Thank you!

[antares686]

It would be becuase of the firewall I am sure you are using. You have to open a port to all you to connect to the machine on the other side. I suggest doing it DMZ style or VPN.

[robert_v]

I am sorry, but would you please tell me more details? The computer that is used for server is installed Windows2000.

Thank you!