Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
shinobigoh
Starting Member
13 Posts |
 Posted - 2011-06-14 : 10:47:44
|
| Hi guys, I setup a SQL Server failover cluster using a domain user Domain User A (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.aspxbut 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 |
|
|
shinobigoh
Starting Member
13 Posts |
Posted - 2011-06-14 : 10:57:34
|
| I have also created a login to sql server to that new domain user and make it sysadmin server role but the configuration manager still has the error( the server threw an exception) |
 |
|
|
shinobigoh
Starting Member
13 Posts |
Posted - 2011-06-14 : 11:44:49
|
| domain user A is the original service account for SQL Server and SQL Server Agentbut domain user A was added to the local administrator group of every node so It has local administrative rightsI 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 loginbut 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? |
|
|
|
|
|
|
the server threw an exception [0x80010105]