| Author |
Topic |
|
FiFo
Starting Member
12 Posts |
 Posted - 2007-12-02 : 14:17:26
|
| hi everybodyI've been working in the database field for 9 monthsI started from very simple tables, to some sql stuffAnd then I started studying SQL Server 2005 extensively until I took MCTS SQL Server 2005During that time, I was building a database for a new company from scratch, and while I build it for them I keep on reading books and learning, and using this knowledge to upgrade the databaseRecently, I could successfully migrate the back-end to SQL Server 2005, and after days of struggling I could connect the front end to it via ODBC in a LANMy next step is connecting the database through the internet, so I just changed the server name in the DSN file to the address of the server, and opened the ports, but it didn't work....Can you tell me what's the problem?Is there a book that can help me do this thing?I can buy any book and I have the will to learn, provided that I'll apply for MCITP Database Developer next monthsThank you.. |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-12-02 : 16:26:15
|
| Can you ping that server over internet? |
 |
|
|
FiFo
Starting Member
12 Posts |
Posted - 2007-12-02 : 16:36:43
|
| It looks that i'll have to give you some information about my setup:The sql server is installed on windows xp, and the front-end is installed in a vmware image on the same machineI could successfully connect the access front-end to the server using computername\servername combination, i could ping the public address of the server, i checked that port 1433 is open, and i have a dynamic ipStill, i can't connect to my server through the public ip... |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-12-02 : 22:47:36
|
| What do you mean dynamic ip? Got ip address via dhcp? Is the ip address a valid internet address? |
|
|
|
FiFo
Starting Member
12 Posts |
Posted - 2007-12-03 : 01:14:06
|
| sorry, i meant: dynamic dns service (No IP) |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-12-03 : 22:36:18
|
| Is it your company's internal ip address? Will not work if so. |
|
|
|
FiFo
Starting Member
12 Posts |
Posted - 2007-12-04 : 00:27:06
|
| the problem is not with the port or the ipi already checked that the port is open, and that the dynamic dns is working, and i'm sure about it |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-12-04 : 22:44:49
|
| Nothing to do with your dns, have to register your server in internet domain's dns. |
|
|
|
FiFo
Starting Member
12 Posts |
Posted - 2007-12-05 : 02:02:57
|
| i told u before, i already have a dynamic dns account with no-ip, after all i found the problemit was that i connected from the same public ipso both the source and destination ips were the same... |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-12-05 : 23:01:13
|
| Every machine on network has ip address, don't know what you mean 'have a dynamic dns account with no-ip'. |
|
|
|
FiFo
Starting Member
12 Posts |
Posted - 2007-12-06 : 00:13:23
|
| i mean, i have a free domain address from no-ip.biz that points to my ip whenever it's changed, and that's why it's dynamic...i use this domain address (something.no-ip.biz) to connect to my home computer because it has a dynamic ip |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-12-06 : 22:48:21
|
| Can you ping that domain address from other machine? |
|
|
|
FiFo
Starting Member
12 Posts |
Posted - 2007-12-07 : 01:47:44
|
| yes, i can |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-12-07 : 23:59:18
|
| Then try connect to sql server from that machine. |
|
|
|
FiFo
Starting Member
12 Posts |
Posted - 2007-12-08 : 00:46:27
|
| i already told you beforei could connect from another public ip, but from the same public ip i can'tthnx for your help |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-12-08 : 00:54:43
|
| You said you can connect from lan but not via internet in first post, then you said ping from internet works above. Now you have another store, looks like you need find some local help. |
|
|
|
FiFo
Starting Member
12 Posts |
Posted - 2007-12-08 : 03:15:53
|
| i can connect through the lani can connect through the internet using a computer that has a different public ipi can't connect through the internet using a computer that has the same public ipso if i want to test the connectivity, then i need to connect from a computer outside the lan |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-12-08 : 17:42:11
|
| How can multiple machines have same ip address on the network? |
|
|
|
FiFo
Starting Member
12 Posts |
Posted - 2007-12-09 : 00:27:35
|
| imagine 10 computers connected to the same dsl modemthey will share the same public ip, using different local ips |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-12-09 : 17:53:47
|
| That's the problem. How can you tell which is which on public network? |
|
|
|
FiFo
Starting Member
12 Posts |
Posted - 2007-12-09 : 22:25:30
|
| i didn't get it |
|
|
|
Next Page
|
Access07 to SQL Server 2007 through the...