none
Wrong Database Access Account (Project Server 2013) RRS feed

Answers

  • Hello,

    The Database access account is basically the "Farm Admin account" of your farm. It's possible to change it, however it's not a good idea doing that and it's not pretty, If this is a very new farm then I'll recommend re-creating a farm using correct account. Below are the steps.

    1) Run the SharePoint Config wizard and disconnect the servers from the farm.

    2) Run the SharePoint Config wizard and create new farm >> give correct user name for Database Access Account.

    However if you decide to change it, here is the instructions, they are provided without any guarantee!

    Go to Central Administration -> Security, click the Configure Service Accounts link under General Security head. Then select Farm Account from the doprdown list. Make sure the account you use have all the permissions. You need those permissions.

    Hope this helps!

    Thank you,

    Kiran K.

    • Marked as answer by Robert6156 Saturday, September 20, 2014 8:59 PM
    Saturday, September 20, 2014 11:39 AM
  • Try using PowerShell.  Here is a good referenece

    http://www.sharepoint-reference.com/Blog/Lists/Posts/Post.aspx?ID=12

    The next powershell update SQL server with the correct permissions for database

    http://technet.microsoft.com/en-us/library/ff607596(v=office.15).aspx

    Cheers!


    Michael Wharton, MVP, MBA, PMP, MCT, MCTS, MCSD, MCSE+I, MCDBA
    Website http://www.WhartonComputer.com
    Blog http://MyProjectExpert.com contains my field notes and SQL queries


    Saturday, September 20, 2014 5:22 PM
    Moderator

All replies

  • Hello,

    The Database access account is basically the "Farm Admin account" of your farm. It's possible to change it, however it's not a good idea doing that and it's not pretty, If this is a very new farm then I'll recommend re-creating a farm using correct account. Below are the steps.

    1) Run the SharePoint Config wizard and disconnect the servers from the farm.

    2) Run the SharePoint Config wizard and create new farm >> give correct user name for Database Access Account.

    However if you decide to change it, here is the instructions, they are provided without any guarantee!

    Go to Central Administration -> Security, click the Configure Service Accounts link under General Security head. Then select Farm Account from the doprdown list. Make sure the account you use have all the permissions. You need those permissions.

    Hope this helps!

    Thank you,

    Kiran K.

    • Marked as answer by Robert6156 Saturday, September 20, 2014 8:59 PM
    Saturday, September 20, 2014 11:39 AM
  • Try using PowerShell.  Here is a good referenece

    http://www.sharepoint-reference.com/Blog/Lists/Posts/Post.aspx?ID=12

    The next powershell update SQL server with the correct permissions for database

    http://technet.microsoft.com/en-us/library/ff607596(v=office.15).aspx

    Cheers!


    Michael Wharton, MVP, MBA, PMP, MCT, MCTS, MCSD, MCSE+I, MCDBA
    Website http://www.WhartonComputer.com
    Blog http://MyProjectExpert.com contains my field notes and SQL queries


    Saturday, September 20, 2014 5:22 PM
    Moderator