Reply
desidude71
New Member

Cannot create SQL Mirrored database

Hi

I cannot create a SQL Database.

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

1 ACCEPTED SOLUTION
v-achippa
Community Support
Community Support

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

View solution in original post

5 REPLIES 5
v-achippa
Community Support
Community Support

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

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

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

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. If the issue is resolved, please mark the solution as Accept as solution to help the other members of the community find it more quickly. Don't forget to give a "Kudos" – I’d truly appreciate it! 

 

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

 

Thanks and Regards,

Anjan Kumar Chippa

DataBard
Resolver II
Resolver II

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?

avatar user

Helpful resources

Announcements
MarchFBCvideo - carousel

Fabric Monthly Update - March 2025

Check out the March 2025 Fabric update to learn about new features.

March2025 Carousel

Fabric Community Update - March 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)