Integrated Security and PHP

[the4thdrawer]

I have a client who insists on using Windoze and SQL Server. So, I have to convert mysql_* to mssql_* and everything else that goes with it.

I am having the usual problems connecting (I'm not looking for the usual answers either - I have them - this is a different issue)

Has anyone used 'Integrated Security' with PHP code? I've seen it in ASP, but never in PHP.

Any comments?

Thanks

Tom

[coopster]

Welcome to WebmasterWorld, the4thdrawer.

I think you are going to have to further define the issue. What are you looking to accomplish with 'Integrated Security'?

[tryant4d]

Hmm... I didn't realize that this was my first post. I must have two accounts.

Anyhoo, it's not really so much what I'm trying to accomplish. It was suggested that my problems with connecting ('Login failed for user 'user_name'. Reason: Not associated with a trusted SQL Server connection') might be solved by using a connection string that includes Integrated Security=yes, among other things. I believe 'Integrated Security' is actually a SQL Server concept. My concern is that this individual may be thinking in ASP, and convincing the host of this.

While searching the web for a php syntax example, I became aware that there aren't any. Lots of VB and ASP, but no PHP.

So my question is: can 'Integrated Security=yes' be used as an argument in a PHP connection string to MS SQL Server? If so, can someone show me how?

Hope this is clearer

Tom