Running Clustered SQL Service 2008 on Network Service Account
-
Thursday, April 26, 2012 4:52 AM
Can we use NETWORK SERVICE for clustered SQL Server services? If yes any additional configs needs to be taken care and is this a recomended practice ?
Trinity
Answers
-
Thursday, April 26, 2012 5:26 AM
Hi,
For clustered instances it is highly recommended to use a domain user account. You can see permissions required and provided by SQL setup here
http://msdn.microsoft.com/en-us/library/ms143504(v=sql.105).aspx
Sean Massey | Consultant, iUNITE
Feel free to contact me through My Blog, Twitter or Hire Me.
Please click the Mark as Answer or Vote As Helpful button if a post solves your problem or is helpful!- Proposed As Answer by Pradeep AdigaMicrosoft Community Contributor Thursday, April 26, 2012 5:46 AM
- Marked As Answer by Stephanie LvMicrosoft Contingent Staff, Moderator Thursday, May 03, 2012 9:19 AM
All Replies
-
Thursday, April 26, 2012 5:26 AM
Hi,
For clustered instances it is highly recommended to use a domain user account. You can see permissions required and provided by SQL setup here
http://msdn.microsoft.com/en-us/library/ms143504(v=sql.105).aspx
Sean Massey | Consultant, iUNITE
Feel free to contact me through My Blog, Twitter or Hire Me.
Please click the Mark as Answer or Vote As Helpful button if a post solves your problem or is helpful!- Proposed As Answer by Pradeep AdigaMicrosoft Community Contributor Thursday, April 26, 2012 5:46 AM
- Marked As Answer by Stephanie LvMicrosoft Contingent Staff, Moderator Thursday, May 03, 2012 9:19 AM
-
Thursday, April 26, 2012 8:44 AMremember Keep the cluster startup account password~ otherwise will have trouble.
-
Thursday, April 26, 2012 11:25 AMModerator
Network Service is a local system account and you wont be able to run clustered SQL Server with this account. You need to create a account in AD which you are supposed to use it as service account
Mark as ANSWER if I helped you today :-)
.png){kind=spacer}
