|
|
|
SSC Eights!
      
Group: General Forum Members
Last Login: Yesterday @ 11:19 PM
Points: 823,
Visits: 2,405
|
|
Hi,
1. Principal & mirror server result the same role, Is it correct for FULL safty configuration without wittness?
SELECT role FROM sys.database_mirroring_endpoints; Role = 1 (partner)
2. Grantor is different on principal & mirror server, also same domain account running for SQL service account & Login account,
SELECT EP.name, SP.STATE, CONVERT(nvarchar(38), suser_name(SP.grantor_principal_id)) AS GRANTOR, SP.TYPE AS PERMISSION, CONVERT(nvarchar(46),suser_name(SP.grantee_principal_id)) AS GRANTEE FROM sys.server_permissions SP , sys.endpoints EP WHERE SP.major_id = EP.endpoint_id ORDER BY Permission,grantor, grantee;
--Principal server result
--Name : Mirroring --STATE : G --GRANTOR: servername\Administrator --PERMISSION: co --GRANTEE: domainname\mydomain account
(Grantee filed- SQL service account should display instead of my domain id)
--Mirror server result
--Name : Mirroring --STATE : G --GRANTOR: sa --PERMISSION: co --GRANTEE: domainname\mydomain account
(Grantee filed- SQL service account should display instead of my domain id)
Pl. suggestion me what could be issue display same role name and different grantor, grantee name?
thanks
|
|
|
|
|
SSCertifiable
       
Group: General Forum Members
Last Login: Today @ 3:08 AM
Points: 5,203,
Visits: 11,157
|
|
ananda.murugesan (9/5/2012)
Hi, 1. Principal & mirror server result the same role, Is it correct for FULL safty configuration without wittness? SELECT role FROM sys.database_mirroring_endpoints; Role = 1 (partner) both instances are partners in the mirror session so this is valid
ananda.murugesan (9/5/2012)
2. Grantor is different on principal & mirror server, also same domain account running for SQL service account & Login account, SELECT EP.name, SP.STATE, CONVERT(nvarchar(38), suser_name(SP.grantor_principal_id)) AS GRANTOR, SP.TYPE AS PERMISSION, CONVERT(nvarchar(46),suser_name(SP.grantee_principal_id)) AS GRANTEE FROM sys.server_permissions SP , sys.endpoints EP WHERE SP.major_id = EP.endpoint_id ORDER BY Permission,grantor, grantee;
--Principal server result
--Name : Mirroring --STATE : G --GRANTOR: servername\Administrator --PERMISSION: co --GRANTEE: domainname\mydomain account
(Grantee filed- SQL service account should display instead of my domain id)
--Mirror server result
--Name : Mirroring --STATE : G --GRANTOR: sa --PERMISSION: co --GRANTEE: domainname\mydomain account
(Grantee filed- SQL service account should display instead of my domain id)
Pl. suggestion me what could be issue display same role name and different grantor, grantee name? thanks Not sure what the question is here, this query details users who have been granted connect to the mirroring endpoint
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs"
|
|
|
|
|
SSCommitted
      
Group: General Forum Members
Last Login: Sunday, May 19, 2013 8:09 AM
Points: 1,558,
Visits: 1,396
|
|
To be a mirror or principal partner, the endpoint's role has to be either "partner" or "all". Both can be "partner, both can be "all" or one can be "partner" while the other is "all". That's all fine.
Grantor is informational only and has no net effect on the mirroring session. It does not matter who granted it.
My blog: SQL Soldier Twitter: @SQLSoldier Microsoft Certified Master: SQL Server 2008 Sr. Product Consultant and Chief SQL Server Evangelist @ Idera My book: Pro SQL Server 2008 Mirroring
|
|
|
|