Connecting to SQL Server through Internet
-
Hello. I'm new to this forum. I've been searching for an answer but to no avail. So finally this is my last hope to see whether the gurus here able to help me.
My company got a SQL server 2000 running in a data center outside our office. It is connected to the Internet and even got a CNAME created for it. The questions is. How to connect to the SQL Server in the data center:
1. Using Enterprise Manager from my office, I can't find anyway to enter IP address or domain name. It seems like SQL Server can only be connected in a LAN environment.
2. Connect using application such as VB.NET, ASP and VB6. What's the connection string that shoul be use.
Thank you.
-
You connect to it like you connect to any other 'network-device'.
If it's from the internal LAN, you need to make sure that your connecting computer can find it's way to the server (through firewalls etc). In EM, you specify the servername or IP adress (which is also the name) when you register the server. If it's already registered, you can edit the settings by rightclicking on the server icon in EM. If you're using QA, you can enter the servername or IP adress in the connect dialog.
If you want to connect over the internet, then your computer needs an internet connection to start with. The adress would then be the adress that is registered in the DNS.
In all cases, you need a valid network adress (that the connecting party also can reach, which may be the thing that causes most problems), and a valid login and password once you reach the server. How the string would look in each different case is very much depending on the tool/programming language/platform used.
A good place to start is trying to ping the server.
Once you get the ping to answer, chances increase that you then will be able to log in sucessfully as well.
Though be aware that firewall rules may prevent ping to be answered. This is stuff you need to talk to your network guys about.
/Kenneth
-
Firewalls will often get in the way (as they should
)You could see if you can have a VPN set up to bypass the firewalls. Then just connect via IP address - not the internet IP address of the server but the server's local network address (since you will be "virtually" on that local network).
-
Now I can connect to the SQL Server in the data center. Yupe. You said it right. It was blocked by the ISA 2004 in my office. Thanks for the tips.
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply