I've created a Domain Controller and 3 additional machines (SQL-A, SQL-B, SQL-CORE). All are on Windows Server2008R2 as VMs running on virtualbox. I have successfully joined the 3 machines to the domain.

Next, I created a user in Active Directory called Kim_Akers who is a member of Domain Admins, Domain users, Enterprise Admins and Schema Admins.

When I login to SQL-A (for example) as [domain]\Kim_Akers and then try and run something like ServerManager.msc. I get a permissions error:

Windows cannot access the specified device, path or file. You may not have the appropriate permissions.

What am I doing wrong such that Kim_Akers doesn't have permissions to do this?

  • How long did you wait before testing "Kim_Akers"? – boburob Sep 12 '12 at 8:35
  • @boburob A few minutes, but I just restarted the machine, and it still has an issue. – Antonio2011a Sep 12 '12 at 8:45
  • 2
    Have you double checked that Domain Admins is in the local administrators group on the SQL servers? Is this only happening on SQL-A, or on all 4 servers with that user? What about a different user in the same groups? – Steve G Sep 12 '12 at 16:08
  • @boburob With only one Domain Controller in this domain, there should be 0 delay, since there's no inter-DC replication. – HopelessN00b Sep 13 '12 at 1:28
  • @SteveG Yes Domain Admins is in the local administrators group. The problem happens on all machines. I created another user name in the same groups and it shows the same behavior. I know I've probably done something stupid, but I'm at a loss as to why it won't work. – Antonio2011a Sep 13 '12 at 4:17

Are you running servermanager.msc (or more specifically, MMC.EXE) as an Administrator (i.e.: right-click and "Run as administrator"). If not, UAC may be the cause, in that your full-admin token isn't being used to launch the .EXE

  • No I wasn't choosing "run as administrator", however when I try this I get the same error message as before. Note I'm not prompted for a login / password. Thanks anyway. – Antonio2011a Sep 13 '12 at 4:33

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.