SQL 2000 and PHP 4.0.4pl1

[Anon]

Hi,

I have read all the articles on SQL 7 and PHP 4 and have had no luck in getting a connection to an SQL Server. The web server (apache) is on one NT server and the SQL 2000 is on another NT server.

I've tried using ODBC and MSSQL_CONNECT both getting a similar error message of:-

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

OR

Warning: SQL error: [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user '\'., SQL state 28000 in SQLConnect

the user is actually set to a name even though the script reports back that it is '\'.

Any ideas ???!?!

[Anon]

Your problem is with your sql server configuration. Check the authentication type for that user under the security properties for that user. Use sql server authentication and check the permissions. You also need to adjust your configuration for your system dsn to use sql server authentication.