• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2417
  • Last Modified:

SCVMM 2012 Self-Service User Role Access Error

We have SCVMM 2012 installed in our environment. When one of our domain user with the Self-Service role try to access the private cloud we've assigned, this user gets the following error message below.

The SQL Server service account does not have permission to access Active Directory Domain Services (AD DS).

Ensure that the SQL Server service is running under a domain account or a computer account that has permission to access AD DS. For more information, see "Some applications and APIs require access to authorization information on account objects" in the Microsoft Knowledge Base at http://go.microsoft.com.com/fwlink/?LinkId=121054

We tried the suggestion from this link http://blogs.technet.com/b/scvmm/archive/2009/06/15/solution-opening-the-scvmm-2008-admin-console-may-fail-with-permissions-related-error.aspx but it didn't work.
Please advise on what we need to do. Thanks!
0
CDMIT
Asked:
CDMIT
1 Solution
 
joyofsharingCommented:
Dear CDMIT,

Do check the following solution;
When VMM & SQL Express were installed, the dbowner on the SQL databases was set to a domain account rather than to a SQL account. At the same time that I mentioned a *new* user account was created in the domain, there was also one deleted at the same time.... and you guessed it, it was the very same one that was set to dbowner on the databases used by VMM.
A simple dbowner change to sa fixed the issue.


http://social.technet.microsoft.com/Forums/en-US/virtualmachinemanager/thread/3799c776-8c48-448a-8bcb-29039c7a3412

joyofsharing
0

Featured Post

[Webinar] Cloud and Mobile-First Strategy

Maybe you’ve fully adopted the cloud since the beginning. Or maybe you started with on-prem resources but are pursuing a “cloud and mobile first” strategy. Getting to that end state has its challenges. Discover how to build out a 100% cloud and mobile IT strategy in this webinar.

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