ShadowMage Posted June 15, 2017 Share Posted June 15, 2017 I'm not sure if this should go here or in PHP, but I'm having problems getting PHP to connect to a Progress DB. I have IIS installed and configured on a Windows 2008 server and all seems to be fine on that front. I can access the site, and I can run PHP code. I can also access the MySQL databases we have. When I try to access the Progress database, however, I get the following error: Warning: odbc_connect(): SQL error: Specified driver could not be loaded due to system error 5: Access is denied. (Progress OpenEdge 10.2A driver, \\share\path\to\file.dll)., SQL state IM003 in SQLConnect in C:\inetpub\phplib\ODBC.php on line 349 I created a system DSN on the webserver and I am able to successfully test connect from there. I've also added full control for Everyone on the specified DLL (and the path to get to it) and still get the access denied error. Any ideas or suggestions? Thanks in advance for any help you can offer. Link to comment Share on other sites More sharing options...
justsomeguy Posted June 15, 2017 Share Posted June 15, 2017 I'm not sure how Windows permissions specifically work, but in addition to Everyone make sure that you have the IIS account also set up with permissions. Maybe the IIS account specifically doesn't have read access and that overwrites the permissions for Everyone, but like I'm said I'm not sure specifically how it works in Windows. Link to comment Share on other sites More sharing options...
ShadowMage Posted June 15, 2017 Author Share Posted June 15, 2017 Maybe a silly question, but how and where do I find the IIS account? I see a group called IIS_IUSRS but there's no members. Link to comment Share on other sites More sharing options...
justsomeguy Posted June 15, 2017 Share Posted June 15, 2017 Search for the account name for your version of Windows or IIS. It used be called IUSR_ followed by the machine name. Link to comment Share on other sites More sharing options...
dsonesuk Posted June 15, 2017 Share Posted June 15, 2017 You did something like select IIS_IUSRS OR leave as is, and there should be a find button, by clicking that it would bring up a list, if i remember correctly. Link to comment Share on other sites More sharing options...
ShadowMage Posted June 16, 2017 Author Share Posted June 16, 2017 Seems like that was the problem. Apparently Everyone doesn't include the IUSR... I couldn't find a way to add the IUSR account to the share in AD, but I did figure out how to change the account used in anonymous authentication in IIS. Link to comment Share on other sites More sharing options...
ShadowMage Posted April 23, 2019 Author Share Posted April 23, 2019 We're migrating to Windows Server 2019 (IIS 10) now and this issue has reappeared. I've changed the account in anonymous authentication to the domain admin account as before, but the error is still showing up. I tried creating a new account specifically to run PHP/IIS and gave the account access to the share/file. I tried specifying this account in anonymous authentication and in the application pool identity (and setting anon auth to use the app pool identity), but nothing seems to work. Any ideas on what else I can try? Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now