Is there a way to see the security configuration of existing mirrored databases? I need to re-mirror these databses and so I need to know if Windows autentication has been used or Sql-server autentication. Any answer would be helpfull Regards Hugo
Mirroring endpoints security is configured either through Windows IDs or Certificates. To determine what authentication your endpoints are using run the following: SELECT * FROM sys.database\_mirroring\_endpoints Look under the connection\_auth\_desc column for endpoint authentication type.