that will be the user configured under IIS (IUSR_<host name>). You don't need that information to update the database you should be able to cal mssql_connect() without any parameters. - Frank > 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 > > > > > -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
