Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 342
  • Last Modified:

How to lock-down workstations that require local admin rights for main office sql app?

we run an application that requires local administrator rights.  It's a sql based application.  Our server is 2012 Standard.  The software vendor who supports this application is no help with this problem.  How do we lock-down the workstations and still allow this sql-base program to work?

Not only does the program have to run in compatibility mode- "run as administrator, the local user must be admin rights

the workstations are windows 7
0
geek3
Asked:
geek3
2 Solutions
 
McKnifeCommented:
Only third party applications can help you, try powerbroker by beyondtrust.
0
 
R. Toby RichardsCommented:
I can usually get around this problem by granting "Users" modify rights to the program's folder under the "Program Files" directory and granting "Users" full control rights to the program's registry entries under HKLM\Software. If that doesn't do it, then use Procmon to discover what files and/or registry entries show "Access Denied" when you run the program as a regular user.
0
 
geek3Author Commented:
Thank you, I'll try and get back with what worked.
0
Creating Active Directory Users from a Text File

If your organization has a need to mass-create AD user accounts, watch this video to see how its done without the need for scripting or other unnecessary complexities.

 
LeeTutorretiredCommented:
I've requested that this question be deleted for the following reason:

Not enough information to confirm an answer.
0
 
McKnifeCommented:
Since one or the other would solve it, I vote for a split.
Either it can be overcome by adjusting access rights, or it can't, and then powerbroker is the state of the art solution.
0
 
geek3Author Commented:
I decided to split the points between the two answers; I consider the best answer the non-third-party solution, however there probably are situations where you would have to use a piece of software (  to purchase PowerBroker you have to purchase a minimum of 20 users @$37.00)
thanks to all
geek3
0

Featured Post

Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now