| Author |
Topic |
|
matthewric
Starting Member
9 Posts |
 Posted - 2007-07-11 : 11:26:36
|
| hello i have a sql 2000 server on the company network and a website hosted with a webhoster i have a php site hosted on the website and i would wish to access a database of the sqlserver i have opened port 1433 and 1434 but the website will not connect to the database can you please help me |
|
|
b.veenings
Yak Posting Veteran
96 Posts |
Posted - 2007-07-11 : 12:05:44
|
| be sure that you use the correct login information and u need to add port 1434 in server settings --> network parameters --> tcp/ip, restart sql service.Need an SQLDB consultant?check www.veeningsengineering.nl |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-07-11 : 12:52:04
|
| You have to open port 1433 on firewall, not good practice. |
|
|
|
matthewric
Starting Member
9 Posts |
Posted - 2007-07-11 : 17:22:14
|
| im not exactly sure what your trying to say i have both ports open it still dosent access over the internet |
|
|
|
b.veenings
Yak Posting Veteran
96 Posts |
Posted - 2007-07-11 : 17:27:14
|
| can you see any errors when you try to access your db, or do you get no respons.try running profile on this database and then try to connect again through your website, if there is activity that's through soap or throug internet or whenever its not local. if it doesn't it's blocked by your firewall or sql server.Need an SQLDB consultant?check www.veeningsengineering.nl |
|
|
|
matthewric
Starting Member
9 Posts |
Posted - 2007-07-11 : 17:36:08
|
| this is the error i get now it all works if hosted localyFatal error: Call to undefined function: mssql_connect() in public_html/index.php on line 5 |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-07-11 : 22:39:27
|
| Port is opened on your company firewall? Your sql server has public ip address? |
|
|
|
matthewric
Starting Member
9 Posts |
Posted - 2007-07-12 : 05:29:20
|
| well there is a network off a router and the port is open from the router to the ip address of the sql server |
|
|
|
matthewric
Starting Member
9 Posts |
Posted - 2007-07-13 : 05:34:53
|
| aggg this is driving me crazy i have no idea whats wrong |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-07-13 : 18:38:59
|
| Is port open to outside of your network? |
|
|
|
matthewric
Starting Member
9 Posts |
Posted - 2007-07-14 : 11:35:37
|
| it should be i opened it the same way i opened other ports that are open |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-07-14 : 13:02:18
|
| What you can try is ping your sql server from hosting company's machine. As I know, company will not use public domain ip address for internal servers. And there is DMZ between company's network and internet. Unless you have direct connection between internal network and hosting company. |
|
|
|
matthewric
Starting Member
9 Posts |
Posted - 2007-07-14 : 14:24:21
|
| it uses a standard internet connection and a router but i only need to access small bits from the database |
|
|
|
b.veenings
Yak Posting Veteran
96 Posts |
Posted - 2007-07-14 : 14:27:32
|
| try telnet ip_adress 1433 or 1434 if you get an response it might be an security issue, if you don't get an response it's blocked from the outside.Need an SQLDB consultant?check www.veeningsengineering.nl |
|
|
|
matthewric
Starting Member
9 Posts |
Posted - 2007-07-14 : 15:05:42
|
| no responce with telnet |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-07-14 : 20:22:28
|
| As expected, most of companies don't let connection from outside. |
|
|
|
matthewric
Starting Member
9 Posts |
Posted - 2007-07-14 : 22:10:16
|
| well the internet and the router and the pc allowes the connection i think it is somthing to do with sql its self |
|
|
|
|
help accessing sql2000 off a website