question

JSimms-8517 avatar image
0 Votes"
JSimms-8517 asked ElsieLu-MSFT commented

Configuration Failed

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.







office-sharepoint-online
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

I'm looking into your issue now and I will reply you as soon as possible.

Thanks for your understanding and patience :-)

0 Votes 0 ·

1 Answer

ElsieLu-MSFT avatar image
0 Votes"
ElsieLu-MSFT answered ElsieLu-MSFT commented

Hi @JSimms-8517 , 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.


100.png (73.3 KiB)
107.png (68.2 KiB)
· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @JSimms-8517 , is there any progress on the issue? We are looking forward to your reply.

0 Votes 0 ·

Hi @JSimms-8517 , to help you better, I have updated my answer. Please check the update1 section. If the problem persists, don't hesitate to let us know. :)

0 Votes 0 ·