We help IT Professionals succeed at work.

Permission different between Administrators and Power Users?

ohjani
ohjani asked
on
289 Views
Last Modified: 2010-03-05
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.

Example:
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
Comment
Watch Question

Commented:
it seems it's something related to user authentication... everything is in the same windows domain???? everybody can see the domain????
Top Expert 2007

Commented:
My first reaction: this is a problem with the ERP client software and rights on the PC, not something within the domain. By default Domain administrators are also local administrators on all member machines of the domain. Lots of software is badly written and wants all users to be local administrator. A security nono, but not every software company has figured that one out.
Anyway, use regmon ( http://www.microsoft.com/technet/sysinternals/FileAndDisk/Filemon.mspx ) AND filemon ( http://www.microsoft.com/technet/sysinternals/ProcessesAndThreads/Regmon.mspx )  OR Process Monitor ( http://www.microsoft.com/technet/sysinternals/FileAndDisk/processmonitor.mspx ) to monitor what fails when you open the ERP client.

J.

Commented:
One quick possibility to try, as PowerIT pointed out lots of software is badly written, trys to write to installation folder, config information, and temp files. Will fail unless user has full access to installation folder - Administrators will have, Power Users probably not. Try changing permissions on Installation folder to give full access to Power Users.

Author

Commented:
The problem is, the user is already an Administrator at their WinXP workstation.  The situation is, the user is Administrators in their workstation but they are only Power User in ServerA.  Now seems that this application requires me to set them as Administrators in the server~
Top Expert 2007
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION

Author

Commented:
no, it doesn't have a share folder to run the application.  The application structure goes like this, first you installed the application to the server, once the application installation is done, it will create a subfolder called the Client Setup.  After that you'll share the Client Setup folder to the workstations and the workstations will connect to this share folder and run the workstation setup files.  Once the workstation has finished installed, they will no longer need to access the Client Setup folder anymore.  the client setup files will contain all the necessary server IP and folders in order for the workstation to run the application.
Top Expert 2007

Commented:
And the database connection is through ODBC? Everyone is using SA as login with the same password?

J.
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION

Gain unlimited access to on-demand training courses with an Experts Exchange subscription.

Get Access
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Empower Your Career
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.