06BVjacquelin
New Member
I have a PHP application currently connectig to a SQL Server via ODBC using Windows Authentication (odbc_connect).Under Apache this works fine.However I need to run this under PHP-IIS. While I can run PHP under IIS, and get this very same application connect to SQL Server when I run it from Apache, trying to run via IIS gives me the following problem:\[code\]PHP Warning: odbc_connect() function.odbc-connect</a>: SQL error: [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot open database "xxx_v2" requested by the login. The login failed., SQL state 37000 in SQLConnect \[/code\]I'm desperate and have been trying to do this for days. I will really appreciate you help!I'm using php 5.2.6, IIS 7 and SQL Server 2008