Share via

Unable to create database in Azure Arc SQL MI from SQL Server Management Studio(SSMS)

Venu Gogineni 0 Reputation points
2023-01-16T17:36:25.44+00:00

After creating a general purpose Azure Arc SQL MI on Azure Stack HCI, I tried to create a sample database from SQL Server Management Studio (SSMS). It failed with below error (screenshot also attached - SSMS_SQL-MI-Issue.jpg), but database was actually created. Same thing has happened when I tried to remove the sample database. It showed an error, but database got actually deleted. I am using SSMS v18.12.1. As per this link, Arc SQL MI can be managed from SSMS, but basic operations like database creation and deletion are failing. Please let me know, how to fix these error popups.

Error Message

The operation cannot be performed on database "test" because it is involved in a database mirroring session or an availability group. Some operations are not allowed on a database that is participating in a database mirroring session or in an availability group. ALTER DATABASE statement failed. (Microsoft SQL Server, Error: 1468)

Azure SQL Database
Azure Arc
Azure Arc
A Microsoft cloud service that enables deployment of Azure services across hybrid and multicloud environments.
465 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Alberto Morillo 34,451 Reputation points MVP
    2023-01-16T20:38:15.04+00:00

    Maybe that Managed Instance is part of an Auto-failover group, and you may want to remove the failover group, and then try the ALTER statement again.

    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.