I'm using PHP 4.3.3 on Win 2000, IIS 5, SQL Server 2000 (developer edition), all on a single pc. I cannot connect to the SQL Server. I get the following:
Warning: mssql_connect(): message: Login failed for user 'T450\IUSR_T450'. (severity 14) in D:\Inetpub\wwwroot...\test.php on line 28
line 28 says:
$s = mssql_connect('EARN')
where EARN is an alias in the SQL Server client utility. I get the same thing if I try to connect to 'localhost' (which is where the SQL Server is).
I'm using NT authentication. I modified that to accept either (NT or SQL Server); still no luck. (I'd like to stick with NT authentication only.)
I'm able to connect to the db using ColdFusion.
Thanks.
Michael
