Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
tejo_pan
Starting Member
10 Posts |
 Posted - 2006-01-13 : 11:54:49
|
| Dears, I have a server on the web (office) with a static IP (201.xxx.xxx.xxx), and I would like to know how could I access the SQL Server directly, from my home computer (not using a Server Web Application)Thank you.Sergio |
|
|
Srinika
Master Smack Fu Yak Hacker
1378 Posts |
Posted - 2006-01-13 : 12:49:37
|
| Anybody answers this post, please answer mine as well.My server, which has a static IP address, but its behind a firewall. Is there a way for me to access the data from outside. I have adminstrator priviledges in machine / Database.System : Win2k Server, SQL 2k |
 |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2006-01-13 : 23:50:08
|
| For security purposes it is better to connect to your office network via VPN. Then you will know who will be accessing the Server from outside.If you are not worry about security, configure your router / firewall to forward the port to your SQL Server's IP. The default port no is 1433. Basically it is (assuming SQL Server port is 1433)Public IP (Port 1433) ==> SQL Server IP (Port 1433)or if your router support this, xxxx is any other port noPublic IP (Port xxxx) ==> SQL Server IP (Port 1433)-----------------'KH'if you can't beat them, have someone else to beat them |
|
|
|
Srinika
Master Smack Fu Yak Hacker
1378 Posts |
Posted - 2006-01-14 : 07:40:56
|
| Thanks khtan,I got my answer.Can somebody answer tejo_pan, who is the real initiater of this thread. |
|
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2006-01-14 : 09:06:56
|
| My answer is also applicable to tejo_pan's question.-----------------'KH'if you can't beat them, have someone else to beat them |
|
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2006-01-15 : 00:41:00
|
| If you are doing this for your office, you should NOT DO IT!!!! This is a hacker's dream come true. Get VPN. That's what it's for. You are exposing your database server to the entire world when you do it. It's fine for playing around at home, but not at work. Remember, when you openly expose one SQL Server like this to the world, you are giving them the keys to all the SQL Servers in your network on many poorly setup networks (that would be a lot of them).If you did it where I work, you would be given a nice box for your own personal usage. I'm sure you could guess how the remainder of your day would go.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
|
|
|
|
|
How to configure the SQL Server to execute for IP?