topic Re: Cannot create SQL Mirrored database in Data Warehouse

Cannot create SQL Mirrored database

desidude71 — Sat, 04 Jan 2025 02:35:26 GMT

I cannot create a SQL Database.

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

Re: Cannot create SQL Mirrored database

DataBard — Sat, 04 Jan 2025 12:45:12 GMT

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?

Re: Cannot create SQL Mirrored database

v-achippa — Mon, 06 Jan 2025 07:33:17 GMT

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.

Verify your account has the necessary permissions
Check that your SQL server version and edition support mirroring.
Review the SQL server error logs for detailed error messages.
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

Re: Cannot create SQL Mirrored database

v-achippa — Thu, 09 Jan 2025 12:41:49 GMT

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

Re: Cannot create SQL Mirrored database

v-achippa — Mon, 13 Jan 2025 11:46:16 GMT

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

Re: Cannot create SQL Mirrored database

v-achippa — Thu, 16 Jan 2025 17:55:11 GMT

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