How to solve Error 927 'can not open database' while configuring DB mirroring Steps I followed:


Create DB on primary.
Took full backup and log backup.
Restored full and log on secondary in NORECOVERY mode
(now tb shows restoring satus on secondary I guess this is because NORECOVERY mode).
Tried configuring mirror from primary.


I was able to configure it successfully with windows 2012 and SQL server 2012 using SSMS 17.6 but it's giving above error with Win2k16 and SQl server 2016
It seems there are bugs with SSMS (2016) to configure mirroring 
https://stackoverflow.com/questions/38008208/sql-server-2016-cant-start-mirror

Try to use TSQL or SSMS 2014

https://docs.microsoft.com/en-us/sql/database-engine/database-mirroring/database-mirroring-establish-session-windows-authentication