Cannot connect to MSSQL db

lhauser63

Hi,

I have a MSSQL that I can access fine through cold fusion and through enterprise. I cannot connect through PHP. My ISP is pretty worthless and won't even tell me if they have it configured to work. I'm using the following code:

$hostname = "put in IP address here";
$username = "username";
$password = "password";
$dbName = "database";

MSSQL_CONNECT($hostname,$username,$password) or DIE("DATABASE FAILED TO
RESPOND.");

Am I doing something wrong with the hostname? I've tried the DNS I use in ColdFusion and also the IP address of the database. With the DNS I get a general unable to connect error. With the IP address I get an error saying it couldn't log in my user name.

HELPPPP

lhauser63

I should point out it is a MSSQL 2000 server and I did put IP address,port number in the host string -- but still says unable to connect.

Sphynx

This may be a silly question, but did you create the DB user and give them access to the specified DB?

Hey... gotta start somewhere, eh 😉

lhauser63

I use a third party ISP and they have to set it up. The finally admitted it wasn't setup and said they did so, but I still cannot connect. I'm almost positive it's on their end

ihenman

Just a stab but how you tried something simple like

'localhost' for the Server.

If your sure your username, and PW are right. And teh ISP says they've created everything correctly then it should work obviously.

What are they telling you to use for a host?