Does Any One Know The Answer

cirion

!!Please Help!!

I am trying to join all of these together (maybe i am asking for trouble)

i have got this far. I have the MSSQL server talking to the iis server with ipsec (encrypted) and php running on the IIS server and is able to connect to the data base (via php_mssql functions). This means that the MSSQL server has to be running in mix authentication mode as you would know.

now for my question.

I want php to connect to the MSSQL 2000 server via windows authentication so that my MS SQL server is not running in mixed authentication mode, is it possible? and how do you do it?

Hope someone can help
Cheers
CiRioN🙁

Doug_G

I suspect you won't be able to use windows authentication from a non-windows box. I believe windows authentication uses an encrypted, proprietary challenge-response sequence to validate. As far as I know only windows boxes can do this.

cirion

thanks for the relpy

just to help a bit more with my question.

the windows authentication is only between the web server and the SQl Server not on the client machine.

Doug_G

Sorry, I didn't read closely enough, I see you are using a windows web server. I thought you were using a *nix server.

From a windows IIS server, if you want to use windows authentication the web server will be operating in the IUSR_computername user account unless your web is authenticated. If users must authenticat to windows, then the web server will impersonate the logged-in user.

The IUSR_computername user account is a local account to the web server normally, so if the SQL server is on a different box you will need to create a clone user account on the db server. In addition, any authenticated users must have a corresponding user account on the db server.

Then you must allow the proper db access to these windows user accounts and at that time you should be able to connect using windows authentication. Don't specify a user or password in your connection string.

hth