Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Login failed for user '(null)'

Author  Topic 

dkusum_4
Starting Member

1 Post

Posted - 2007-10-08 : 11:26:34
I need to connect remotely to MS SQL Server 2000 using

php.I am using the following codes:

$dbhost = "IP address of server";
$dbuser = "username";
$dbpass = "password";
mssql_connect($dbhost, $dbuser, $dbpass) or die("Unable to

connect to $db");

But I keep getting the following error:
PHP Warning: mssql_connect() [function.mssql-connect]:

message: Login failed for user '(null)'. Reason: Not

associated with a trusted SQL Server connection. (severity

14).

I have already set mixed mode authentication on the

server, but it did not help.

Please help

Kristen
Test

22859 Posts

Posted - 2007-10-08 : 12:20:55
Sounds like the mssql_connect() function is using Trusted mode regardless!

See: www.connectionstrings.com

Kristen
Go to Top of Page
   

- Advertisement -