Problem connecting to MSSQL DB

[Arc]

I have a MSSQL DB on an SQL server.. my files are on a different server. How do i connect to it?

<?php
$Hostname = "11.111.11.111";
$Database = "DBNAME";
$Username = "USERNAME";
$Password = "PASSWORD";

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

This always returns ("Unable to connect to Database"). The IP and username and Password are correct.. what else could be the problem?

I've also tried mssql_connect.. stilll no worky.

Thanks!😃

[daphreeek]

i am not familiar with mssql but in mysql, each user is granted privilages including what host they can access the database from. most servers set all thier users to allow only local hosts to access the database.

hope that helps
- Matt

[Arc]

Well i can connect to the DB thru Enterprise manager from my desktop at home. But for some reason i cant connect to it thru code using the same info. So i dont think its anything to do with local host.

The company that set this SQL server up also set up the Ftp server knowing that they needed to work together so again it doesnt make sense that it would be a localhost issue.

Any other reason it woulndt work?

[daphreeek]

http://www.php.net/manual/en/ref.mssql.php

go there and check you have got your server set up with the extensions correctly

• Matt