October 26, 2009 at 10:50 am
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
October 26, 2009 at 1:56 pm
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?
October 26, 2009 at 2:16 pm
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
October 27, 2009 at 3:00 am
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
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply