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

more ▼

asked Sep 04, 2012 at 06:24 AM in Default

avatar image

10 1 1 1

(comments are locked)
10|1200 characters needed characters left

2 answers: sort voted first
 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

more ▼

answered Sep 04, 2012 at 07:57 AM

avatar image

ThomasRushton ♦♦
42.2k 20 57 53

@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, 2012 at 08:34 PM Kev Riley ♦♦
(comments are locked)
10|1200 characters needed characters left

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.

more ▼

answered Sep 05, 2012 at 12:21 PM

avatar image

12.1k 30 36 42

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Sep 04, 2012 at 06:24 AM

Seen: 1143 times

Last Updated: Sep 05, 2012 at 12:21 PM

Copyright 2018 Redgate Software. Privacy Policy