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

hugo gravatar 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

ThomasRushton gravatar image

ThomasRushton ♦
34.2k 18 20 44

@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

Blackhawk-17 gravatar image

11.9k 28 31 37

(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.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

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: 974 times

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