What are the best practices for setting up an SQL service account? Or How to do it? When i say how I am familiar with creating users I just don't know what permissions or group it should belong to. Should it be a local admin? A domain admin? With full rights limited rights?
Any help would be great. I changed active directory password and it caused me all sorts of problems because I did not have this setup correctly.