Connecting to a remote daabase

[rahulbisme]

Hey ragezone!

I just bought a second VPS to host my GunZ website. I enabled remote connections on my VPS and I used the host name

'64.244.60.17\SQLEXPRESS'

For some odd reason, it still won't connect to the database?

Running:

IIS (Plesk)
MSSQL 2008 RC2
Windows Server 2003 (For db)
Windows Server 2008 (for site)

Does anyone have an idea of what the problem could be?

[MentaL]

[adz28]

Don't connect or page give you errors... i have the same problem last day, be sure your webhost allows MSSQL

[Blasian]

Search a bit more,

$host = 'blah';

$user = 'username';
$pass = 'password';
$db = 'GunzDB';

mssql_connect( $host, $user, $pass) or die ('Could Not Connect to Mssql Server');
mssql_select_db ( $db) or die ( 'Can not select database' ); 

where host is:

server_name:port

Port is the default mssql port.

And this will work on linux even though I don't have MSSQL support?

well if the MSSQL is hosted on a windows or w/e. But there this wine do.

sudo apt-get wine

sudo apt-get winetricks

then run winetricks and see if mssql is supported, I don't know what
version of linux your using, but even if you did Linux os can't run
gunz servers at least i never tried.

Dont for get to like if i helped u =,=

You just want to host your WEBSITE on a linux box right? IF it's just the website just make sure apache/litespeed/whatever webserver is running on the linux box has the MSSQL support added (if it doesn't contact your host and ask for it! It's free for them anyway)

Then it's as simple as doing the remote connection as said above.

Useful links:
apache friends - xampp for linux
SQLSRV Driver API Reference (Microsoft Drivers for PHP for SQL Server)

[rahulbisme]

So IP\SQLEXPRESS:PORT

Correct?

@I transferred to Windows hosting, so I have full mssql support.

[adz28]

Yepe, also you can use the original code, nothing change.
PS: Port is 3776 (if you use XZeenon tutorial)

[rahulbisme]

I fixed it. For anyone who had the same problem, make sure to allow whatever TCP port you are using through Windows Firewall.