I have an ERP application which uses 2 servers. Server A for application installation while Server B for SQL server database hosting. Both servers located in the same workgroup and physically next to each other.
In order to run the ERP application, I need to install the ERP client into my user workstations (also in the same workgroup and same premises). Now my problem is, some of the workstation are able to run the application where some cannot. All the workstations are able to connect to both servers (tested on opening share folders from both servers). The only different is, some users are Administrators group in Server A and others are Power Users. The database link from Server A to Server B is using SA from ODBC.
WorkstationUsername ServerA_Username ServerA_Usergroup Remark
UserA UserA Administrators Can run client application
UserB UserB Power Users Cant run client application
Error message is the application error which says something like "No organisation found". I would like to know, what is the permission missing from Power Users which stop them from running the application from their workstation?
Both servers are Win2003 Server. Workstations are running on WinXP