connecting to a remote MS SQL server

Anon

Hi,

I'm having a hard time connecting to a remote MS SQL server. My client is running Windows2000, IIS, and MS SQL 2000. He has placed the SQL Server version of NTWDBLIB.DLL in the proper directory on the server running PHP. He has set his authenication to SQL Server authentication and Windows authentication. I've tried using the following scripts with MSSQL_CONNECT($dbhost,$dbuser,$dbpass):

$dbhost="ipaddress";

$dbuser="myusername";
$dbpass="mypassword";

$dbhost="ipaddress\ipaddress";

$dbuser="myusername";
$dbpass="mypassword";

$dbhost="ipaddress:port";

$dbuser="myusername";
$dbpass="mypassword";

and the above with:
$dbhost="servername"; $dbhost="servername\servername"; $dbhost="servername:port";

It won't connect with any of them. Is there something that we're missing that anyone can think of?

Thanks.
-Derek

Anon

I don't use ms sql, but perhaps this info about mysql will help.

CONNECTING TO MYSQL REMOTELY
So how do you connect from a remote machine to a mysql server with IP address 128.206.100.15?

The machine you're connecting from must have mysql installed, of course.
You must have an account on the server you're connecting to. You must also have GRANT previledges on the server that allows remote access.
Launch the DOS console and CD to mysql\bin. First, make sure the server is running by typing TELNET 128.206.100.15 3306. If the server is running, you should get a response that indicates the mysql version. If not, you will get a message that says, CANNOT CONNECT.
Once you know the server is running, issue the command mysql -u username -h 128.206.100.15 -p. Replace username with a username you already have set up on your mysql server.
** If the server is running on a port other than the default, the command will be mysql -u username -h 128.206.100.15😛ortNumber -p

Richie.
geocities.com/akindele/