How to connect to other M$ SQL Server over internet??(Help me)

[GIGABYTEHANOI]

My English is not good.

I want to connect to other computer that installed M$ SQL Server2K over INTERNET. could you help me, plz.

I have used DNS (DOMAIN NAME SYSTEM) to forward to my computer( that connect to INTERNET) and my friend computer is the same. (because we have not static IP).

Thanks

[rmiao]

If you can ping remote sql server from your box, you can connect to it as long as port used by sql is open on the network.

[GIGABYTEHANOI]

TO RMIAO:

How to ping remote sql server??
Could you show the details, plz.

I have connect by ENTERPRISE MANAGER but not success.

[rmiao]

You can ping remote server in dos prompt with ping command, like:

ping remote_server_name

or

ping remote_server_ip

[GIGABYTEHANOI]

Oh. I have ping[ed].
Ex: solar0402.no-ip.info --> IP: xxx.xxx.xxx but it's remote computer's ip.

I went to ENTERPRISE MANAGER:

1-NEW SQL SERVER REGISTRATION...
2-NEXT. (not checked: From now on, I want to perform.....)
NEXT
3-Left combobox name: AVAILABLE SERVER: xxx.xxx.xxx.xxx(IP that I have got when ping SOLAR.NO-IP.INFO)
Right combobox name:Added Server: xxx.xxx.xxx
NEXT
4-In REGISTER SQL SERVER WIZARD:
Checked: The SQL Server login information....
NEXT
5-Used account/password: sa/sa
NEXT
6-NEXT
7-FINISH
8-Waiting for amoment.
Status ERROR:
SOLAR.NO-IP.INFO-SQL Server does not exists or access denied connectionOpen(Connect())

P.S: In LAN(LOCAL AREA NETWORK) I have successed.

[rmiao]

Then you have to ensure tcp port used by sql is open on related network, check it with your isp.

[MAK]

Check with your ISP the following
a. the TCP/IP port they use on their SQL Server compuyter
b. there is not firewall settings that blocks that port.

Check whether the remote computer is connected to a router that has the list of port blocked includes the SQL Server port.

[dawain]

http://www.hamachi.cc/
..with Hamachi you can organize two or more computers with an Internet connection into their own virtual network for direct secure communication.