Problem Connect SQL Remote to Web Hosting
I'm trying to connect my gunz database sql server 2008 to a webhosting and did all opened ports TCP 1433 and dup wirndows disable firewall sql configure and enable the remote connection and it works because I tried it on my pc and if the remote connection is used but not in the web hosting alkyn knows why?.
This is the error telling me:
PHP Code:
Warning: mssql_connect() [function.mssql-connect]: Unable to connect to server: 192.168.1.1\MSSQLSERVER,1433 in /home/gunz/public_html/gunz/jork/secure/config.php on line 7
Fatal error: Call to undefined function mssql_error() in /home/gunz/public_html/gunz/jork/secure/config.php on line 10
Re: Problem Connect SQL Remote to Web Hosting
Are you using gateway IP lol ? 192.168.1.1 ???
use IPv4 whenever u try to connect remote sql.
Re: Problem Connect SQL Remote to Web Hosting
Ronny786 as it happens I'll post my real IPv4 is an example, and discovered something wrong apparently the connection works because I tried it with my computer which is also hosted my site and works but does not work in webhosting that weird?.
Re: Problem Connect SQL Remote to Web Hosting
Quote:
Originally Posted by
jorklenis2
Ronny786 as it happens I'll post my real IPv4 is an example, and discovered something wrong apparently the connection works because I tried it with my computer which is also hosted my site and works but does not work in webhosting that weird?.
Because your hosting does not support MSSQL.
Re: Problem Connect SQL Remote to Web Hosting
Quote:
Originally Posted by
adz28
Because your hosting does not support MSSQL.
It does, read the error properly. It's saying it can't connect to the host but says nothing about MSSQL being undefined.
Re: Problem Connect SQL Remote to Web Hosting
Quote:
Originally Posted by
adz28
Because your hosting does not support MSSQL.
Told andrez, not the vps hosting but if not I have to allow connections from port 1433 but not how to do that.
Quote:
Originally Posted by
Vusion
It does, read the error properly. It's saying it can't connect to the host but says nothing about MSSQL being undefined.
Well you should know that this error, because in my pc I have a website hosted and if it works there but not on web hosting and support functions where buy say the vps hosting does not allow connections from my ip web hosting, any ideas?.
Re: Problem Connect SQL Remote to Web Hosting
Quote:
Originally Posted by
jorklenis2
Told andrez, not the vps hosting but if not I have to allow connections from port 1433 but not how to do that.
Well you should know that this error, because in my pc I have a website hosted and if it works there but not on web hosting and support functions where buy say the vps hosting does not allow connections from my ip web hosting, any ideas?.
just check this. put ip in browser n check if it works. if it is working. u need to allow TCP/IP connection to mssql server from sql configuration. there is help thread of someone regarding this,i have posted whole steps in detail. check it.