| Author |
Topic |
|
sushiboy
Starting Member
12 Posts |
 Posted - 2008-02-14 : 08:32:28
|
| set up windows 2003 serversql server 2000have public IP from netword soluctionsI can see websitewhat settings to i need to open up sql server to the public? |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2008-02-14 : 09:59:43
|
the SQL server port no. But are you sure you want to do this ?
KH[spoiler]Time is always against us[/spoiler] |
 |
|
|
sushiboy
Starting Member
12 Posts |
Posted - 2008-02-14 : 10:04:39
|
| yes. I have a sql server on the web that users connect to with MS access adp file.I want to move that sql DB to to my net work (windows sql server 2000)i have everything installedI have the public IP and i can see my websitebut i have no idea how to link to my sql server on my server like i used to.what do i need to set up in sql. what do i put in the "SQL server port no" where is that anyway? |
|
|
|
sushiboy
Starting Member
12 Posts |
Posted - 2008-02-14 : 10:36:20
|
quote:
Originally posted by khtan
the SQL server port no. But are you sure you want to do this ?
KH[spoiler]Time is always against us[/spoiler]
please help |
|
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2008-02-14 : 11:36:26
|
| Just to be clear , are you trying to move your server, or do you have the server already in place , and you simply want your web site to connect?Jack Vamvas--------------------Search IT jobs from multiple sources- http://www.ITjobfeed.com |
|
|
|
sushiboy
Starting Member
12 Posts |
Posted - 2008-02-14 : 11:46:26
|
yes ..its already in place and i want to connect directly from ms access adp to my sql server..some now i keep getting DB does not exist. it is not a windows log in to get in to sql severquote:
Originally posted by jackv
Just to be clear , are you trying to move your server, or do you have the server already in place , and you simply want your web site to connect?Jack Vamvas--------------------Search IT jobs from multiple sources- http://www.ITjobfeed.com
|
|
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2008-02-14 : 11:55:14
|
| Are you able to ping the ip from the Access machine?Also, are you using ADP or ODBC to connect?Jack Vamvas--------------------Search IT jobs from multiple sources- http://www.ITjobfeed.com |
|
|
|
sushiboy
Starting Member
12 Posts |
Posted - 2008-02-14 : 13:30:31
|
adp and odbc both connect but only within the domain (the companies newwork).. outside world can not see it. its like the iis doesnt know sql server is there.and also the I can only connect with the domain name and not the IP(outside ip) that networksolutions gave me I get connection falied sqlstate: '08001'sql server error 12sql server does not exist or access deniedquote:
Originally posted by jackv
Are you able to ping the ip from the Access machine?Also, are you using ADP or ODBC to connect?Jack Vamvas--------------------Search IT jobs from multiple sources- http://www.ITjobfeed.com
|
|
|
|
Hommer
Aged Yak Warrior
808 Posts |
Posted - 2008-02-14 : 14:57:21
|
| I think your over all architecture design has some flaws. It is not a good idea to expose your db server to the web like the way you have described. And it is also not desirable to host ADP on the web. I assume you want to make the connection between access and sql server through the web because your access and the server are not physically located at the same location, or within the same domain. |
|
|
|
sushiboy
Starting Member
12 Posts |
Posted - 2008-02-14 : 15:00:16
|
| the data is located at here in the office. the adp file will be on local laptops. the adp has a lot of forms and stuff. I have no idea why i cant connect to the sql server like i do with other hosting plans. |
|
|
|
Hommer
Aged Yak Warrior
808 Posts |
Posted - 2008-02-14 : 16:11:47
|
| Then there is no point of punch a hole in your firewall to go through your web for the connection. |
|
|
|
jemacc
Starting Member
42 Posts |
Posted - 2008-02-14 : 17:32:10
|
| change the port to something like 1447, change youe firewall exception and add the newly created portconnect to your server via ip address, for example:33.333.6.66, 1447Note: as recommended practice caution and do not expose your database |
|
|
|
sushiboy
Starting Member
12 Posts |
Posted - 2008-02-15 : 07:23:40
|
is there a way to put the domain name and the port #like www.omghelp.com, 1447?quote:
Originally posted by jemacc
change the port to something like 1447, change youe firewall exception and add the newly created portconnect to your server via ip address, for example:33.333.6.66, 1447Note: as recommended practice caution and do not expose your database
|
|
|
|
|
how do i open up sql server to the public on web