Running Clustered SQL Service 2008 on Network Service Account

Answered 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

All Replies

  • Thursday, April 26, 2012 5:26 AM
     
     Answered

    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!

  • Thursday, April 26, 2012 8:44 AM
     
     
    remember Keep the cluster startup account password~ otherwise will have trouble.
  • Thursday, April 26, 2012 11:25 AM
    Moderator
     
     

    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 :-)