PHP access to MS SQL Server on NT Server

Anon

I have an NT 4.0 Server (SP5) with Apache, PHP, and Microsoft SQL Server 2000. I can't seem to get a connection to the database through PHP. I am using "mssql_connect()" command to connect to the database, and keep getting the same error even if I use an administrative login account (NT and SQL login).
I'm using mixed authentication in SQL and assuming it's either a sercurity issue or a php.ini setup issue, or both.
The error is :

"Warning; MS SQL message: Login failed for user 'rbaldwin'. (severity 14)....."

and

"Warning: MS SQL: Unable to connect to server:....."

There doesn't seem to be much information that I can find on this particular issue. Is there any thing I can try to get access?

--BOb

jblallement

Can you drop here the code line you use to connect ?

Thanks

Anon

Here is the actual piece of code:

$hostname = "tst_web";
$username = "rbaldwin";
$password = "baldwinr";
$db = mssql_connect($hostname, $username, $password);

jblallement

Did you declare 'tst_web' with client network utility

Anon

Yes. When it's not declared I only get the error "Unable to connect to server....".
I even tried using the IP address to verify naming issues. I may not have all the correct .dll files in the proper places or the php.ini file may not be correctly set.
This is my first attempt with this configuration and have no clue to the proper mesh of these two software.

jblallement

I don't think it's caused by any missing .dll or php.ini because in the 1rst case PHP couldn't be loaded, in the second case you would get a "function undefined" message when you try to connect.
check if your SQLServer accept connection over TCP/IP and not only named pipes and if you can connect from the web server ( the one running PHP ) over TCP/IP with one of the MS tools ( ie Query analyser ).
You may also define an ODBC datasource and check if you can connect with PHP ODBC.
You may also try to add sqlserver address to hosts file on webserver in case of naming issues.

Anon

Thanks for the lead. I've tried using the Query Builder application while on the SQL Server and it won't authenticate through the SQL login.
The TCP connection would seem to be my problem. See if I got this right:
1. I created an admin account for sql server in User Manager for Domains
2. Enabled TCP/IP and Multiprotocol, respectively, in the Client Network Utility on the server
3. The hosts file on the client pc has the ip mapping to the server name

Where else do I set up SQL Authentication to accept the SQL login through a TCP connection?

I feel like an idiot here, there's got to be something simple I'm missing.......

Anon

NEVER MIND! I GOT IT!
Finally. I Went into SQL Enterprise Manager and found a security account for the databases and added the login account information I created in User Manager for Domains.
This enabled me to connect with Query Analyzer, which also allow the PHP code to work properly.

Thank you very much for your time and help.

-BOb

Anon

HELP NEEDED IN SQL DATABSE CONNECTION
GUESS I SHOULDA READ THE BOOK MORE BUT
NO INFO ON THE NAMED PIPES CONECTION NAMES
FOR USING THE DATABES SORRY GUESS THIS MESSAGE (HAS NO PURPISS) I CANNOT FIND A WAY TO GET INTO THE JAVA CONSOLE GUESS I SOULD JUST PLAY WITH THE SOFTWARE MORE

SORRY TO BUG YOU LOT SEEMS THAT I GOTTA READ MORE GUESS IM NOT UP TO SPEED ON SOME STUFF
GOTTA DO STUFF CHEARS!!!

Anon

I have a similar problem and I can't seem to fix it.

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

is the error message i get ... even though the username i use is not '\'

My code is:-

$hostname = "venus";
$username = "web";
$password = "test";
$dbName = "dbUpdate";

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

I run the profiler on the server and it doesnt even blink, so it would appear to me that something is going wrong somewhere ?!?

Any ideas ???

Anon

I get a similar message except my error message doesn't show any username ...

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

even though I pass a valid username and password to the mssql_connect command.

Anon

I can't believe it.

Here I am 4 months later and I still have no solution for working with PHP and Microsoft SQL Server 2000.

PLLLLLLEEEEAAAASEEEEE ... someone respond with how to get this working ???

If I can't get a response, I'll have to drop PHP and use ASP and I don't really want to do that.

Phil Greenway wrote:

I get a similar message except my error message doesn't show any username ...

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

even though I pass a valid username and password to the mssql_connect command.

corsc

Have you tried using ODBC, it is much easier to use and makes it more portable if you decide to change datasources.

Anon

Yep. Tried ODBC too. Still no joy.

This is the error I get in ODBC.

I've tried both of these connection statements.

$cnx = odbc_connect("AFMQR","","");

$cnx =odbc_connect("DSN=AFMQR;UID=admin;PWD=password","","");

Warning: SQL error: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified, SQL state IM002 in SQLConnect

Even though I created a System DSN and a User DSN which point to our sql server and test successfully.