We help IT Professionals succeed at work.

Check out our new AWS podcast with Certified Expert, Phil Phillips! Listen to "How to Execute a Seamless AWS Migration" on EE or on your favorite podcast platform. Listen Now

x

PHP Windows Authentication SQL Server

Medium Priority
1,028 Views
Last Modified: 2013-12-13
I created a program and tested it under a php/mysql platform. I now need to alter my code to use Windows Authentication to connect to a SQL server database. Due to the server configuration, I cannot use mixed mode. I read somewhere that if I create the same usernames on both servers that i could trick the authentication. Could anyone supply me with some example connection strings that I could use to connect to an SQL server with Windows Authentication?
Comment
Watch Question

Senior Software Developer
CERTIFIED EXPERT
Top Expert 2009
Commented:
Unlock this solution with a free trial preview.
(No credit card required)
Get Preview
CERTIFIED EXPERT

Commented:
To add to what tedbilly said, and to I believe address your question ...
If you create identical accounts on both servers and give them the same password then you can use this account on the application pool and use integrated security in the data connection AND grant the account on the SQL server permissions to the database then this should work.

Author

Commented:
OK, that sounds like what I was reading about.

Is there anything specific about the connection strings for this to happen?
Does anyone have a example that I can mimic?
CERTIFIED EXPERT

Commented:
CERTIFIED EXPERT
Commented:
Unlock this solution with a free trial preview.
(No credit card required)
Get Preview

Author

Commented:
I followed the follorwing tutorial and have managed to connect successfully.

http://msdn.microsoft.com/en-us/library/cc296205(SQL.90).aspx
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a free trial preview!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.