locked
mirroring setup endpoint error RRS feed

  • Question

  • Hi

    I am having no luck trying to setup mirroring between remote servers. on local instances is ok.  I went thru both windows and certificate authenication version.  With windows authenication, I checked the troubleshooting steps,

    in step 6, Make sure that the login from the other server has CONNECT permission, I ran the query

    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

    but the result does not have the mirroring endpoint that I created and granted connect permission to?

    GRANT CONNECT ON ENDPOINT::Mirroring TO [Windows\xxx]

    I ran the above statement, but nothing.  Is this an error?

    P

    Sunday, November 26, 2006 10:21 PM