We are trying to connect to SQL Server with PHP and get a 500 error.

Error using this Database Connection!
Server Response:
500 - Internal Server Error

Server Error

500 - Internal Server Error

There is a problem with the resource you are looking for, and it cannot be displayed.

We are troubleshooting the PHP install on IIS, but we're hoping you could point us in the right direction.
Thanks.

Hello Lauren,
Please check the following tutorial: www.dmxzone.com/go/32354/debugging-problems-in-dmxzone-server-connect/

Thanks for the quick response. I can't get the server connect to connect to the database with php (I've successfully connected with ASP) - I'm getting the 500 error when I test the DB connection. So it won't save the Action file - because "Validation Failed! Please enter Connection Options".

When I check in the browser, there's no code associated with the DB connection/action - since it's not being added in DW.

Hello Lauren,
So this happen in database setup field? Please make sure everything is properly entered in the fields when trying to setup the connection.

Yes. In the database setup field. I can use the same information/connection info and successfully connect to ASP on another server. It's the PHP connection that's giving me trouble.

Are you sure PHP PDO is installed and the driver for your database is also installed and enabled?

This reply was removed on 4/13/2018 8:02:46 PM.
See the changelog

We've confirmed that PHP PDO is installed an enabled. We're still getting a 500 error. I tried turning on error logging, but since we can't save a connection file - nothing appears in the log folder. I was able to connect succesfully the database using a simple php script.
PDO
PDO support enabled
PDO drivers sqlsrv
pdo_sqlsrv
pdo_sqlsrv support enabled
ExtensionVer 4.1.4.9021
Directive Local Value Master Value
pdo_sqlsrv.client_buffer_max_kb_size 10240 10240
pdo_sqlsrv.log_severity 0 0

sqlsrv
sqlsrv support enabled
ExtensionVer 4.1.4.9021
Directive Local Value Master Value
sqlsrv.ClientBufferMaxKBSize 10240 10240
sqlsrv.LogSeverity 0 0
sqlsrv.LogSubsystems 0 0
sqlsrv.WarningsReturnAsErrors On On