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
asked Sep 04, 2012 at 06:24 AM in Default
That'll return an INT:
See SERVERPROPERTY documentation
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.
answered Sep 05, 2012 at 12:21 PM