How to initiate MS SQL trusted connection for PHP

Question

I have been trying to initiate database trusted connection to MS SQL using PHP but failed. My PHP development machine is not part of the domain and the MS SQL server is in a domain. Unfortunately I cannot join my development machine to the domain. My DBA is reluctant to change the authentication mode of the SQL server.

Is there anyway for me to connect to the MS SQL server with trusted connection using PHP with just a domain logon credential?

Thank you

Answer 1

In Asp.net we can use Integrated Security=True";or Trusted_Connection=Yes;in your connection string or Trusted Connection=SSPI" in connection string

in php go to the php.ini and verify the mssql.secure_connection parameter :

[MSSQL]

mssql.secure_connection = On