Web application being stopped by Server 2003 permissions issue
Posted on 2008-10-20
We are having an issue with a newly installed application that uses Pervasive SQL and IIS to run a browser based HR portal for our employees. The application is installed on a domain server and it uses Active Directory user logins to authenticate the browser logon. The users access a specific web page (running on our server) and logon as follows:
DomainName\Username and then enter a password.
Everything works fine as long as the user is a member of the Administrators group. However, as soon as we remove the user from the Administrators group and make them a member of the domain users group they can no longer log in and they receive a "Login Failed" error.
The company who designed the HR portal (Municipal Accounting) has tested it thoroughly and stated that it is something on our end. The evidence that they use to back this up is that they say that they cannot use remote desktop and log on locally as any standard user even if they give the standard user access rights to logon to the server as a remote desktop user.
Therefore, they are saying that since a standard user cannot log on locally to the server as a remote desktop user, we must have permissions issues on our server.
They may be right to some extent, but we certainly should not need to allow users remote access rights to connect to the server. However, they may be correct in that it appears to me that the web based logon is going to require users to have permissions to logon to the server locally.
This company assures me that the app is working in other places and that the problem is on our end. If anyone has any ideas it would be greatly appreciated.