Connection Thru Internet

Hello again pals, i meet you again to ask an old question i had, but no found answer.

Can i connect to a remote SQL Server thru Internet, lets say from a client like Query Analyzer?

I read to make it using a VPN, but i try to configure it and cant get connected.

I'm using a Win2000 Server or Win2003 Server,

Thanksfull!!!!

There is many people asking for that, i start to think it cant be done! :'(If you are using virtual private networking (VPN) to get onto the network where the SQL Server resides, yes you can access a SQL Server throught the internet. You need a router that allows for VPN, there is some configuration to do here and depending on your SQL authentication method, you are going to either have to setup accounts for the users NT logins(windows authentication) or setup user names and passwords for these users. Do'nt forget to assign them permissions within SQL as well.|||If you are using virtual private networking (VPN)

There is no other way to do it, without using VPN?, it has been a headache to try configure it!

Thanks for your help Thrasymachus, is well received|||This is the only way I can think of if you want use the QA to access the data. You can always create an online interface to do what your users need but it sounds like they need a lot of access.|||If you know how to Telnet and use OSQL you can query your database from the command line|||If you make the ports that your server is listening on open to the internet you could connect directly. If you are using QA though I'd think you were doing some administrative tasks. You really shouldn't open up access to your server to the internet unless it's absolutely neccessary. If you can use a VPN, do it.|||Another way would be to set up port forwarding. But again it's as unsecure as directly exposing the server.