Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


SBS Permissions

Posted on 2006-03-27
Medium Priority
Last Modified: 2008-03-17
I have a customer that has SBS 2003 with only 3 users. They use Medisoft and Quickbooks 06 Pro from which they maintain the common databases on the server in a shared folder. Every couple of weeks they lose connectivity between their client apps and the shared databases on the server and one or more of the users' permissions get changed. One user has only power user rights on the server and on their local machine and Quickbooks Pro is denying her access. Is this an SBS permissions problem?
Question by:kdsturg48
  • 3
  • 2

Expert Comment

ID: 16309059
In what way to the perissions get changed?

Hve you tried turning on file auditing to see what is changing them?

Author Comment

ID: 16311754
No I haven't turned on auditing but I will try it and let you know how it goes.
LVL 74

Expert Comment

by:Jeffrey Kane - TechSoEasy
ID: 16328077
Quickbooks requires that users have LOCAL Administrator rights.  This is something that is contentious among security experts, but generally is not a huge issue.  The only thing that it really does is allow the users to install software on their machines.  This can be countered with a proper Software Restriction Group Policy.


There are also some posted work-arounds here:

You should NOT grant Power User rights to those users on the domain.


Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.


Author Comment

ID: 16328239
I did try giving the user local Admin rights and I also went into the registry and gave rights on the Quickbooks entries. Still couldn't get the domain power user login rights in Quickbooks. So you are saying that local Admins should not be granted power user on the domain? Does that cause problems with programs like Quickbooks?
LVL 74

Accepted Solution

Jeffrey Kane - TechSoEasy earned 2000 total points
ID: 16377786

I don't use the domain power user group... it's really kindof funky and has a couple of "DENY" permission entries... so best to stay clear of it.  You should just create a new security group on the server for QuickBooks and grant that group full access to the server shared folder which has the QBDatabase.  Then, your user should be a member of that group and then should also have local admin rights on whatever workstation they are using.

No reason to go into the registry -- the local admin should have rights by default.  Otherwise, if not you should reinstall the program.


Author Comment

ID: 16378159
The reason I went into the registry was because that was a recommendation I ran across when I looked the error up on the Quickbooks site. Sounds like a good idea to set up a Quickbooks user group. I'll give that a try.

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In the event you manage a Small Business Server 2003, and you are audited for PCI compliance, there are several changes you must make in order to pass the audit. I can take no credit for discovering any of these fixes or workarounds, but there is no…
Written by Glen Knight (demazter) as part of a series of how-to articles. Introduction One of the biggest consumers of disk space with Small Business Server 2008(SBS) is Windows Server Update Services, more affectionately known as WSUS. For t…
this video summaries big data hadoop online training demo (http://onlineitguru.com/big-data-hadoop-online-training-placement.html) , and covers basics in big data hadoop .
The Relationships Diagram is a good way to get an overall view of what a database is keeping track of. It is also where relationships are defined. A relationship specifies how two tables connect to each other. As you build tables in Microsoft Ac…

564 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question