Forum Discussion

desidude71's avatar
desidude71
New Member
1 year ago
Solved

Cannot create SQL Mirrored database

Hi

I cannot create a SQL Database.

It gives me an internal error when creating an SQL Database.

Mirrored Azure SQL Database
  • v-achippa's avatar
    v-achippa
    1 year ago

    Hi desidude71,

    Thank you for reaching out to Microsoft Fabric Community.

     

    The 'internal error' you are encountering while creating a mirrored SQL Database can be caused from several reasons like, including insufficient permissions, resource constraints, or misconfigured settings.

    1. Verify your account has the necessary permissions
    2. Check that your SQL server version and edition support mirroring.
    3. Review the SQL server error logs for detailed error messages.
    4. If mirroring endpoints are configured, ensure they are set up correctly and the servers can communicate without network restrictions.

    If the issue persists, please share additional details so that we can narrow down the issue. Explain the issue in detail, include the exact error message, please provide the error screen shot and at what step you are getting the error and your SQL server version/edition.

     

    If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it! 

     

    Thanks and regards,

    Anjan Kumar Chippa

5 Replies

  • v-achippa's avatar
    v-achippa
    Community Support
    1 year ago

    Hi desidude71,

    Thank you for reaching out to Microsoft Fabric Community.

     

    The 'internal error' you are encountering while creating a mirrored SQL Database can be caused from several reasons like, including insufficient permissions, resource constraints, or misconfigured settings.

    1. Verify your account has the necessary permissions
    2. Check that your SQL server version and edition support mirroring.
    3. Review the SQL server error logs for detailed error messages.
    4. If mirroring endpoints are configured, ensure they are set up correctly and the servers can communicate without network restrictions.

    If the issue persists, please share additional details so that we can narrow down the issue. Explain the issue in detail, include the exact error message, please provide the error screen shot and at what step you are getting the error and your SQL server version/edition.

     

    If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it! 

     

    Thanks and regards,

    Anjan Kumar Chippa

    • v-achippa's avatar
      v-achippa
      Community Support
      1 year ago

      Hi desidude71, 
      As we haven’t heard back from you, we wanted to kindly follow up to check if the solution I have provided for the issue worked? or let us know if you need any further assistance?

      If my response addressed, please mark it as Accept as solution and click Yes if you found it helpful.

       

      Thank you for being a part of the Microsoft Fabric Community Forum!

       

      Thanks and Regards,

      Anjan Kumar Chippa

      • v-achippa's avatar
        v-achippa
        Community Support
        1 year ago

        Hi desidude71,

         

        Thank you for reaching out to Microsoft Fabric Community.

         

        We wanted to kindly follow up to check if the solution i have provided for the issue worked.
        If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.

         

        Regards,

        Anjan Kumar Chippa

  • DataBard's avatar
    DataBard
    Most Valuable Professional
    1 year ago

    Hi desidude71,

    Can you clarify what you are setting up? Are you mirroring Azure SQL DB or Azure SQL Managed Instance? And what step are you at when you get the internal error?