Skip to main content
cancel
Showing results forย 
Search instead forย 
Did you mean:ย 

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

Reply
desidude71
New Contributor

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
Honored Contributor

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
DataBard
Contributor

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?

v-achippa
Honored Contributor

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
Honored Contributor

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
Honored Contributor

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

v-achippa
Honored Contributor

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

Helpful resources

Announcements
Top Solution Authors
Top Kudoed Authors
Users online (8,588)