| Author |
Topic |
|
mori0043
Starting Member
18 Posts |
 Posted - 2007-08-23 : 18:46:15
|
| Hi, I can't seem to get SQL Server running on a different port. I have SQL Server 2000 Enterprise on Windows 2003 Enterprise Edition. I right clicked in the Enterprise Manager on the local instance and clicked on the network configuration. I then went and set the TCP/IP port to 8888. I opened up the port on the router and turned off the windows firewall. I still can't seem to connect from a client machine through the internet.Any ideas???thanks in advance... |
|
|
kenchee
Starting Member
49 Posts |
Posted - 2007-08-23 : 21:32:08
|
| hi, try going into the "server network utility" found at start->programs->microsoft sql server. click on the tcp/ip properties and check if the port is set to 8888.have you done port forwarding on your router to port forward 8888 to the sql server ip address from your internet? also try using odbc on the client machine and go into "client configuration" and uncheck the dynamically determine port and put in 8888. |
 |
|
|
mori0043
Starting Member
18 Posts |
Posted - 2007-08-23 : 22:48:36
|
| Hi, thanks for replying. I have done both and nothing. I still can't seem to connect... What am I doing wrong? |
|
|
|
kenchee
Starting Member
49 Posts |
Posted - 2007-08-23 : 23:14:35
|
| you got a fixed WAN ip address?? and are you connecting using the wan ip address or the lan ip address.eg. your sql server is 192.168.0.1 and your wan ip is 222.222.222.222, at your client you should have use 222.222.222.222\sql_instance_name. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-08-23 : 23:25:11
|
| Don't think internet user can see your sql server if you put it inside your company's network. |
|
|
|
mori0043
Starting Member
18 Posts |
Posted - 2007-08-24 : 09:16:22
|
| I am sure that this can be done because I connect to other databases out in the internet all the time. To answer kenchee's question... that is correct. I have a fixed WAN ip address and the client is being used in the way you describe but still nothing is working.I can connect to the database from another computer on the same network, but once I get outside (start using TCP/IP) it no longer works.Any other suggestions? Thanks in advance!! |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-08-24 : 23:55:06
|
| Opened sql port on your network firewall? |
|
|
|
mori0043
Starting Member
18 Posts |
Posted - 2007-08-25 : 13:02:31
|
| Yes, I actually turned the firewall off just to make sure. Is there only one port that I am supposed to open? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-08-25 : 23:01:57
|
| Did you restart the SQL Server service after you made the port change? Verify in the SQL Server Error Log that the port is in use. For 2000, the log is sorted by oldest events to newest events. It should be in the first 50 messages or so. It'll say what IP address it is using and what port it is listening on.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-08-26 : 12:31:10
|
| Not just windows firewall, company usually has firewall between internal and external networks. |
|
|
|
|
Cannot setup SQL Server on different port