PHP & MSSQL 2 Servers

[dassa]

Hi,

I have apache, php running on a windows 2000 machine accessing a MSSQL7 server, everthing is running ok. I am now trying to access another MSSQL7 server and have set the odbc connect the same as the first connection and it runs the test ok, I can also run the query analyser tool on the apache, php server and connect to the 2 MSSQL Server, but I can't get PHP to bring any data back when i change point by php to this new data source.

The error message returned is

Warning: SQL error: [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'DOMAIN\COMPUTERNAME$'., SQL state 28000 in SQLConnect in c:\program files\apache group\apache\htdocs\auth\db\test.php on line 9 could not connect to ODBC Data Source test.

I don't quite understand why the error message states the login failed for user Domain and then Computer name rather than Domain and the user i'm logged in as Administrator ?

Any help appreciated

Cheers

[Doug_G]

The web server will operate in a different user account than what you're logged in as when testing with query analyzer.

Look over the sql server authentication configuration, maybe the two db servers are configured differently.