| Author |
Topic |
|
eric1964
Starting Member
4 Posts |
 Posted - 2007-05-24 : 12:02:19
|
| Is it possible to connect to a sql server express over internet or not ?- I am using a win2003 sp1 server. Freshly installed.- The server is directly connected to internet. - For the purpose of the test, I stopped the windows firewall and the IPSec service. - I stopped SQL server Browser service.- I find a free port (here : 1401)- I activated TCP/IP protocol in SQL Server Configuration Manager, and I have selected 1401 as the TCP port in the IPAll sextion of TCP/IP protection (and I remove the '0' of the dynamic TCP Port).- Restarted SQL server express...In the sql server log, I get the message "Serveur Server is listening on [ 'any' <ipv4> 1401]"But I never get an answer from the server.sqlcmd -S ip_of_the_server, 1401 -U username -P password is working fine if launched on the server. But I always get a timeout error from any PC. Same with a telnet on port 1401.Any idea ?- |
|
|
Rwj6001
Starting Member
12 Posts |
Posted - 2007-05-24 : 12:24:27
|
| As far as the connection to the Internet goes, I don't believe I've ever seen a system that was connected "directly" to the Internet, there is almost always some type of hardware in between the system and the Internet. Usually a firewall of some type, perhaps a router, possibly a switch, maybe a modem, something along those lines. Most times this piece of hardware will need to be configured to allow an outside connection by opening a port, allowing port forwarding, ETC. depending upon the hardware.Can you tell us more about the type of Internet connection that you have?Rwj6001 |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-05-24 : 13:02:40
|
| Where did you run sqlcmd? Is the ip address your internal one or on internet? |
|
|
|
eric1964
Starting Member
4 Posts |
Posted - 2007-05-24 : 16:26:31
|
quote:
Originally posted by Rwj6001
As far as the connection to the Internet goes, I don't believe I've ever seen a system that was connected "directly" to the Internet, there is almost always some type of hardware in between the system and the Internet. Usually a firewall of some type, perhaps a router, possibly a switch, maybe a modem, something along those lines. Most times this piece of hardware will need to be configured to allow an outside connection by opening a port, allowing port forwarding, ETC. depending upon the hardware.Can you tell us more about the type of Internet connection that you have?Rwj6001
Well, this server is hosted in a hosting company, and, yes, its network card it's directly connected to the backbone of the hoster. So no more firewall.I am working on this issue since 3 days. And I dont have any idea now. Any idea will be appreciated. |
|
|
|
eric1964
Starting Member
4 Posts |
Posted - 2007-05-24 : 16:28:17
|
quote:
Originally posted by rmiao
Where did you run sqlcmd? Is the ip address your internal one or on internet?
Because this server is directly connected to internet, there is only one IP address. The whole server is exposed on internet by this IP. I have a ftp and IIS server on this server and everything is fine for that. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-05-24 : 16:48:05
|
| If you can't telnet to port 1401 from your client machine, then the problem is network related.Tara Kizerhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
eric1964
Starting Member
4 Posts |
Posted - 2007-05-24 : 17:22:46
|
quote:
Originally posted by tkizer
If you can't telnet to port 1401 from your client machine, then the problem is network related.Tara Kizerhttp://weblogs.sqlteam.com/tarad/
Ok i agree. I think the problem is that there is something wrong in Win2003. But what ? |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-05-24 : 22:19:51
|
| Is port 1401 open on the network? |
|
|
|
Rwj6001
Starting Member
12 Posts |
Posted - 2007-05-24 : 22:36:05
|
| Windows 2003 does not block tcp/ip ports in itself, except for the function of the built in firewall, its all wide open. Therefore something else is blocking that port.While your hosting company might have told you that this particular server is "directly" connected to the internet, I still doubt that very seriously.Ports 21 (ftp) and 80 (default website) are commonly open in scenario's such as this, where there is a hosting company involved. I still say talk to them and verify that they have the port open and accessible.Just my two cents.....Rwj6001 |
|
|
|
|
connection sql server express 2005 over internet ?