Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

I need to change the Service Account for Sql Server (i.e. I need SQL Server to run under a different account). Can I just change the account or do I need to perform some Sharepoint configuration as well please?

Thanks and Regards,

Joseph

share|improve this question
add comment

1 Answer

up vote 0 down vote accepted

You can change the SQL Service Account without any additional changes to SharePoint. Make the changes and Restart the SQL Service. Ensure that the service account of SQL has the necessary rights in the operating system where the SQL Server is running.

The rights you need to configure for SharePoint service account on SQL Server is of db_creator and securityadmin security roles. As long as these roles are in place , you are safe from access troubles.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.