locked
Changing the SQL Services Start up account RRS feed

 , 
 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    We are using MOPS 2007 + Sp2+ Dec CU

    We are being advised bu the SQL Server team to change the SQL Services start-up account. I am trying to understand the impact of this in an existing MOPS installation. What do I need to have the SQL team confirm, to make sure that we have no issues after this change?

    Friday, July 16, 2010 12:22 PM
    |

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hello Prasanna,

    You can change the SQL service account, provided need to think about the farm account permissions on the SQL server.

    It is very important to keep the permissions of the account what you are using to access sharepoint & Project databases. Otherwise it will lead to production down.

    In case you remove the farm account from SQL, need to create another account with all the databases permission and need to follow the article below to update the sharepoint farm.

    http://support.microsoft.com/kb/934838

    Cheers. Happy troubleshooting !!! Sriram E - MSFT Enterprise Project Management
    Tuesday, July 20, 2010 2:40 AM
    |

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hello Prasanna,

    You can change the SQL service account, provided need to think about the farm account permissions on the SQL server.

    It is very important to keep the permissions of the account what you are using to access sharepoint & Project databases. Otherwise it will lead to production down.

    In case you remove the farm account from SQL, need to create another account with all the databases permission and need to follow the article below to update the sharepoint farm.

    http://support.microsoft.com/kb/934838

    Cheers. Happy troubleshooting !!! Sriram E - MSFT Enterprise Project Management
    Tuesday, July 20, 2010 2:40 AM
    |
  • Question
    Sign in to vote
    0
    Sign in to vote
    Thanks Sriram.
    Thursday, July 22, 2010 9:25 PM
    |