Create Endpoint Error

• 2Tall

  SSChampion

  Points: 14644

  More actions

  October 26, 2009 at 10:50 am

  #135885

  Hi to all. I am attempting to configure an Endpoint in a virtual lab.

  CREATE ENDPOINT [Mirroring]

  AUTHORIZATION [lab\sql]

  STATE=STARTED

  AS TCP (LISTENER_PORT = 5034, LISTENER_IP = (x.x.x.1))

  FOR DATA_MIRRORING (ROLE = PARTNER, AUTHENTICATION = WINDOWS NEGOTIATE

  , ENCRYPTION = DISABLED)

  I receive error:

  Msg 2793, Level 16, State 11, Line 1

  Specified owner name 'lab\sql' either does not exists or you do not have permission to act on its behalf.

  Well it exists.

  Windows 2003 R2 SP 2 / SQL 2005 X86 SP2

  Any ideas?

  Thanks,

  Phil.

  -------------------------------------------------------------------------------------
  A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."

  Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '

  Tommy Cooper

• Lynn Pettis

  SSC Guru

  Points: 442467

  More actions

  October 26, 2009 at 1:56 pm

  #1070906

  2Tall (10/26/2009)

  ---

  Hi to all. I am attempting to configure an Endpoint in a virtual lab.

  CREATE ENDPOINT [Mirroring]

  AUTHORIZATION [lab\sql]

  STATE=STARTED

  AS TCP (LISTENER_PORT = 5034, LISTENER_IP = (x.x.x.1))

  FOR DATA_MIRRORING (ROLE = PARTNER, AUTHENTICATION = WINDOWS NEGOTIATE

  , ENCRYPTION = DISABLED)

  I receive error:

  Msg 2793, Level 16, State 11, Line 1

  Specified owner name 'lab\sql' either does not exists or you do not have permission to act on its behalf.

  Well it exists.

  Windows 2003 R2 SP 2 / SQL 2005 X86 SP2

  Any ideas?

  Thanks,

  Phil.

  According to BOL the caller has to have impersonation on the specified login:

  To assign ownership by specifying AUTHORIZATION, the caller must have IMPERSONATE permission on the specified login.

  Have you checked to ensure that you have this permission?

• 2Tall

  SSChampion

  Points: 14644

  More actions

  October 26, 2009 at 2:16 pm

  #1070920

  Hi Lynn. I shall take a look.

  Thanks,

  Phil.

  -------------------------------------------------------------------------------------
  A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."

  Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '

  Tommy Cooper

• 2Tall

  SSChampion

  Points: 14644

  More actions

  October 27, 2009 at 3:00 am

  #1071067

  Thought I would post my solution.

  It transpires I had not permitted the account used in the Endpoint role membership on system databases Master & msdb.

  msdb:Roles

  SQLAgentOperatorRole

  SQLAgentReaderRole

  SQLAgentUserRole

  Thanks,

  Phil.

  -------------------------------------------------------------------------------------
  A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."

  Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '

  Tommy Cooper