Re: How to use Windows Authentication (SSPI) with mssql_connect command ?

If you set mssql.secure_connection = On, is there a way in PHP where you can then retrieve the username of the person that is trying to update the database? On 5/30/07, Frank M. Kromann <frank@kromann.info> wrote:

use the mssql.secure_connection = On in your php.ini file and make sure the IIS users has access to the database. - Frank Hi, Does someone knows how to use the Windows Authentication (SSPI) with mssql_connect() ? Here's my trouble : I'm using an MS SQL Server 2000 and use the windows credential to log... I can logon SSPI with ASP and Javascript using ADO... But it doesn't seems to work with PHP My Server is a Windows 2003 with MS SQL 2000 and IIS 6.0 and PHP 5.2.2.2 I changed the following value to use the NT authentication ... mssql.secure_connection = On But when i try to connect supplying only the server... i get the following error : Warning: mssql_connect() [function.mssql-connect]: message: Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection. (severity 14) in C:\Inetpub\wwwroot\portail\Outils\functions.php on line 280 And here's my authentication options in IIS ( see attachment ) Could someone explain to me how to supply windows credential to PHP using mssql_connect method Thanks Mat -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php