Yes that is possible. If the web server allows anonymous access to the script it will use the generic account, but if anonymous access is disabled you can get the auth method and name from the $_SERVER array. I think it's called $_SERVER['AUTH_USER']. You can test that by creating a small script the spit's put phpinfo(); and remove anonumous access to the script. - Farnk > I know you don't need it to connect/update the database. I was thinking > more along the lines of using it for an event logging type of scenario. > > User A opens and processes an order. Upon completion User A saves the order > with its new status. Would it be possible to extract who User A is by > pulling the name out of the NT authentication required to access the server? > > Almost like how a session works by storing the username after someone logs > in. But instead of them having to log in, it would just pull the "username" > from their NT account. > > > On 5/31/07, Frank M. Kromann <frank@xxxxxxxxxxxx> wrote: > > > > 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
