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@xxxxxxxxxxxx> 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
