locked
Failed to create the configuration database. RRS feed

  • Question

  • I am facing an issue while running SharePoint 2106 Configuration Wizard. Error: Failed to create the configuration database.This is a critical task. You have to fix the failures before you can continue. -------------------------------------------------------------------------------- An exception of type System.Data.SqlClient.SqlException was thrown. Additional exception information: CREATE DATABASE permission denied in database 'master'. Please help me on this. Thanks in advance...
    Tuesday, February 19, 2019 3:52 AM

Answers

  • Hi,

    Per the error message, it means the account to create the database doesn't have the necessary permissions in SQL Server.

    If the account that you use to run the configuration wizards does not have the appropriate special SQL Server role membership or access as db_owner on the databases, the configuration wizards will not run correctly.

    1. Run "SQL Server Management Studio" as administrator.

    2. Open Security -> Then Logins

    3. Select the account and open the account’s properties.

    4. Click Server Roles and then check dbcreator and securityadmin.

    Account permissions and security settings in SharePoint Servers 2016

    Best regards,

    Linda


    Please remember to mark the replies as answers if they helped. If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com.

    SharePoint Server 2019 has been released, you can click here to download it.
    Click here to learn new features. Visit the dedicated forum to share, explore and talk to experts about SharePoint Server 2019.

    • Marked as answer by Srikanth Battu Tuesday, February 19, 2019 12:13 PM
    Tuesday, February 19, 2019 8:04 AM