Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 425
  • Last Modified:

PHP Windows Authentication SQL Server

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?
0
MrBaseball9
Asked:
MrBaseball9
  • 3
  • 2
2 Solutions
 
Ted BouskillSenior Software DeveloperCommented:
You cannot trick NTLM authentication.  If PHP is running in IIS it is running in an application pool.   If you use a domain account in the identity of the application pool then use integrated security in the data connection that domain account is used to connect to SQL.  It's a very safe secure way to have a web application communicate with SQL.
0
 
cj_1969Commented:
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.
0
 
MrBaseball9Author 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?
0
Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
cj_1969Commented:
If you are using a php driver then you might be stuck providing credentials for the connection string.
If you can use the examples I provided within php great, otherwise try creating a system DSN and configure it to use Windows authentication.  Hopefully this will use the app pool identity when the php script runs to authenticate the connection to the database.
0
 
MrBaseball9Author Commented:
I followed the follorwing tutorial and have managed to connect successfully.

http://msdn.microsoft.com/en-us/library/cc296205(SQL.90).aspx
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now