DB_ Mirroring

[Former Member]

Dear Experts,

After the DB Mirroring i am not able to see the status of mirror sever connected in mirroring monitor screen.

please find the below screen shot and please help me out in this.

Regrads,
NetWeaver.

[former_member184473 · Accepted solution]

Hello,

Does the user used during the setup has enough authorizations on both servers (principal and mirror)? If a SQL login was used it has to be a valid login on both servers.

Check if the user has login authorization (sp_grantlogin) and sysadmin role (sp_addsrvrolemember sysadmin).

Regards,

Eduardo Rezende

[Sriram2009]

Hi Abbas

Are you using the Witness connection ? your DB mirroring in the WAN link? Normally without witness it shows the below screen shots

Or at the time of DB mirroring just deselect the witness server instance as refer the below screen shot

Re do the Mirroring task once again without witness

Thanks

Ram