Connecting to MSSQL2000 on a remote server

[Arc]

Posted this in DB forujm and never got any responses... hopefully someone here has experience with this problem and can enlighten me 🙂

Connecting to MSSQL2000 on remote server
Anyone know how to connect to MSSQL2000 when it is located on a different server than the php files?

The Hostname and username and password i am using are all correct so that can't be the problem. Here is the code i am using..

<?php
$Hostname = "11.111.111.111";
$Database = "dbname";
$Username = "username";
$Password = "password";

$Connect = mssql_connect($Hostname, $Username, $Password) or die("Unable to connect to Database");
mssql_select_db($Database, $Connect) or die( "Unable to select Database"); 
?>

Is there something wrong with that code? Am i supposed to add a port number or source name in the host name? If so how?

Thanks!

[SensualSandwich]

At a quick glance the code looks fine, however, you will probaly need to specify a port. Ex. 11.111.111.111:11 (:11 tells it to use port 11).