Sql-server – launch database mirroring monitor grayed out in SQL server 2014

mirroringsql serverssms

I have 2 servers configured with mirroring each other. Both the servers are principal & Mirror servers each other. From the 2nd Server launch database mirroring monitor is working fine but from 1st server launch database mirroring monitor is showing grayed out. Both server services are running with the same administrator account. The below screenshot is for 1st server. Can you please help me how to enable this launch database mirroring option in SQL server 2014 ?

Best Answer

Had the same problem - turns out if the first DB in the list is in restoring (mirroring) state that server will have this issue. Solved it by adding an empty DB "aaa" as the first DB in the list.

Related Solutions

SQL Server 2008 – Database Mirroring with TDE

Found a website with a comment on it.

I added the code to just after where I restore the key and cert

--Mumbojumbo to get mirroring to work
OPEN MASTER KEY DECRYPTION BY PASSWORD = '1Password'
ALTER MASTER KEY ADD ENCRYPTION BY SERVICE MASTER KEY
GO

It works like a charm, it makes a little sense that I had to encrypt the master key that I restored with the service master key of the new server. I guess.

shrug

Sql-server – SQL Server Database Mirroring : strange client application behavior upon failover

Suggest you check to see that each box has each FQDN registered with port, etc, for each target/ sql-srv, as well as the witness FQDN. Each server has all three registered with FQDN. Reinitialized the endpoints and cross your fingers ! :) If in DMZ, are you able to use AD inside DMZ ? or maybe there is trust back out the corp AD ? If short names registered and FQDN, think this trust might be giving you fits, so presented with non-FQDN being used. Rick

Best Answer

Related Solutions

SQL Server 2008 – Database Mirroring with TDE

Sql-server – SQL Server Database Mirroring : strange client application behavior upon failover

Related Question