SQL Server Mirroring - Principal Database is not configured for mirroring

Question

Is there any way of figuring out what the real reason is for Mirroring to give up on the
Alter Database dbPrincipal Set Partner = 'TCP://Domain + server : Port , etc.

There are so many reason why you will get the same error: Principal Database is not configured for mirroring

This time, checked the sys.databases, etc..... nothing is weird with the Principal Database .... it turned out that the Query Store was turned on - so it did not complete the Mirroring process .... we are not using the GUI; all with SQL code.

Because Microsoft gave up on Mirroring, they are not giving you detailed messages about the failure of the Mirroring attempt.

Was just curious.....

Thank you

Answer 1

Hi @travisGatesMcGee@hotmail.com ,

Ensure that you are meeting all the prerequisites for database mirroring.

And then please reference : troubleshoot-database-mirroring-configuration-sql-server

More information about creating database mirroring:
example-setting-up-database-mirroring-using-windows-authentication-transact-sql,
create-database-mirroring

If the reply is helped, please do “Accept Answer”.
BR,
Mia

Answer 2

Yuximiao-MSFT

Of course, I was using code .... or GUI would give the same standard error message.

Regardless of what is in the article.... there are probably 15+ reasons why the mirroring will fail with "Principal Database is not configured for mirroring"

Our example was: Query Store was turned on.

Can you do your internal research .... is there a compiled information showing Check List by version, of course?

Because Mirroring as a Feature and its error messages have been frozen in time, but newer versions of SQL are adding new capabilities to databases that will prevent Mirroring being configured.

Did you get my point?

Answer 3

Hi @travisGatesMcGee@hotmail.com ,

OK. Can you tell me the topology diagram and t_sql of your mirroring configuration?
I will reproduce the mirrirong configuration on my own side.

BR,
Mia