question

hugo avatar image
hugo asked

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
securitymirroringconfiguration
10 |1200 characters needed characters left characters exceeded

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

ThomasRushton avatar image
ThomasRushton answered
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 comment
10 |1200 characters needed characters left characters exceeded

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

@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 Like 1 ·
Blackhawk-17 avatar image
Blackhawk-17 answered
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 characters needed characters left characters exceeded

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

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

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