June 14, 2011 at 8:53 am
Hi guys,
I setup a SQL Server failover cluster using a domain user Domain User A as the service accounts for all services (the domain user was added to local administrator groups of every node that are in the cluster)
I have created a new domain user B without adding it to the local administrator group of each node and have created SQL Server login for this account and assign sysadmin right to this account
I have set access control list on those folders that this account needs to access by following the instructions on the web page "Setting up Windows Service Accounts" http://msdn.microsoft.com/en-us/library/ms143504%28v=sql.90%29.aspx
but when I set the service accounts (SQL Server and SQl Server Agent) to the new domain user B using the sql server configuration manager. I encountered this error "the server threw an exception [0x80010105]"
when I added the new domain users to the local administrator group of every node, I will not encounter this error.
any one has any idea why the domain user B needs to be added to the local administrator group because i have setup the minimum permissions that the new domain account B needs to have?
does any one know any other permission that i need to assign to domain user B so that I do not need add them to the local administrator group of every node
thank you
June 14, 2011 at 8:56 am
I have also created a login to sql server to that new domain user and make it sysadmin server role but it still threw the exception
June 14, 2011 at 9:44 am
domain user A is the original service account for SQL Server and SQL Server Agent
but domain user A was added to the local administrator group of every node so It has local administrative rights
I need to use a service account with minimum privileges so I have created a new domain user B without adding it to the local administrator groups. I have assigned the appropriate access control list for the new domain user B based on the information from this web page "Setting up Windows Service Accounts" http://msdn.microsoft.com/en-us/library/ms143504%28v=sql.90%29.aspx.
I have also created a SQL server login for that new domain user and have assigned sysadmin role to this login
but when I tried to change the service account (SQL Server and SQL Server Agent) to the new domain user using the configuration manager, this error occurred (the server threw an exception [0x80010105] ).
any one has any idea on solving this?
June 14, 2011 at 10:42 am
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply