MSSQL Connectivity

djg_uk

Hi All,

I'm attempting to connect to MS SQL Server, but the script continuously fails to connect to the server, although both PHP and MS SQL are on the same server. It times out due to the execution time exceeding 30 seconds.

Can anyone shed any light?

Kind Regards,

David Grant

djg_uk

Hi All,

Used "localhost" instead.

-D.

Anon

Hi,

I'm having all sorts of problems trying to get SQL 2000 to talk to PHP but SQL is on a different PC to the PHP / webserver.

Did you come across any errors like this when you connecting on your local box ?

Warning: MS SQL message: Login failed for user '\'. (severity 14)

I'm using the following code to connect:-

$hostname ="VENUS";
$username = "admin";
$password = "passwordhere";
$dbName = "mydb";

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

It's just a thought ... I've had no success with this and I'm been working on it for hours.

djg_uk

Hi Phil,

I connected to localhost, so it wasn't really that complicated. Looking at your problem (although I must stresss I don't have an MS SQL experience), it looks like the problem is with the user authorisation, not the connection. Double-check your username and password, and make sure your IP address isn't blocked.

Kind Regards,

David

Anon

That's the thing. I am specifying a username and password. And no matter what I put in there, it still comes back saying user '/'.

I'm currently logged in as the Administrator so I'm got full access to everything, yet, I still get errors.

I doubt the IP address would be blocked, because this would have had to have been something setup and it's just a standard install.

djg_uk

Hi Phil,

I'm sorry, I can't suggest anything further. I suggest you re-post this request as a new thread.

Kind Regards,

David