Configuration Failed

J. Simms 1 Reputation point
2021-10-22T15:36:43.573+00:00

Have a fresh install of Sharepoint 2019 (Windows Server 2019 Standard) and SQL Server 2019 Standard Edition.

SharePoint server installs with the setup domain account without issue but the products configuration wizard will not bypass the Specify Configuration Database Settings with the domain account.

When specifying the db server/name/username/password and selecting next I immediately receive an error cannot connect to database master at SQL server error. The domain account has the required server roles in SQL (dbcreator, public, securityadmin, sysadmin).

Running the configuration as the local administrator allows me to successfully enter the configuration database settings but fails on step 3 with the error failed to create configuration database. An error occurred while getting information about the user ***** at server ****: Access is denied.

I gave the user domain admin access, local admin access on both servers (restarted after doing both) to see if that would fix the issue but I still receive the same errors above.

Any help / guidance would be greatly appreciated.

SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
9,738 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Elsie Lu_MSFT 9,771 Reputation points
    2021-10-25T06:25:11.883+00:00

    Hi @J. Simms , welcome to Q&A forum!

    If this account is used to set up each server in your farm by running the SharePoint Products Configuration Wizard, the initial Farm Configuration Wizard, and PowerShell, it requires the following permissions. Please check and compare:
    143343-100.png
    Reference:
    Account permissions and security settings in SharePoint Servers

    ================
    Update1======================

    In order to better trouble shooting, I have found a blog for you to do a more detailed inspection. (For example: Make sure SQL Server is running on a service account that is granted with local administrator access rights! (Not running on accounts such as local service, network service!)

    Please refer to this blog for more information about the steps:
    Configuration Failed: Failed to create the configuration database in SharePoint Products Configuration Wizard
    Note: Microsoft is providing this information as a convenience to you. The sites are not controlled by Microsoft. Microsoft cannot make any representations regarding the quality, safety, or suitability of any software or information found there. Please make sure that you completely understand the risk before retrieving any suggestions from the above link.

    In addition, please ensure that your SQL Server account and SQL browser account are in the correct running state with the correct permissions:
    145700-107.png

    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.