Security Configuration on SQL2008 Mirror

Question

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

Answer 1

0

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 documentation

answered Sep 04 '12 at 07:57 AM

ThomasRushton ♦
29.5k ● 6 ● 9 ● 36

@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

Sep 04 '12 at 08:34 PM Kev Riley ♦♦

(comments are locked)

Answer 2

0

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 '12 at 12:21 PM

Blackhawk-17
10.5k ● 23 ● 29 ● 34

(comments are locked)

Security Configuration on SQL2008 Mirror

Follow this question

Related Questions