Security Configuration on SQL2008 Mirror

Question

question

hugo asked Sep 4, '12

Security Configuration on SQL2008 Mirror

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

security mirroring configuration

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Answer 1 · 2012-09-04T07:57:36Z

ThomasRushton answered Sep 4, '12

SELECT SERVERPROPERTY('IsIntegratedSecurityOnly') That'll return an INT: * 1 = Integrated security (Windows Authentication) * 0 = Not integrated security. (Both Windows Authentication and SQL Server Authentication.) See [SERVERPROPERTY][1] documentation [1]: http://msdn.microsoft.com/en-us/library/ms174396.aspx

1

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Kev Riley ♦♦ commented · Sep 04, 2012 at 08:34 PM

@hugo as you can see the security mode is set at server level and not at database level - and mirroring is a database level option, so the answer will be the same for all the mirrored databases

1 ·

Answer 2 · 2012-09-05T12:21:45Z

Blackhawk-17 answered Sep 5, '12

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.

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

question