sql server - New to Service Broker. Getting Error with setting up Initiator and Target Queues/Services on 1 Database -

sql server - New to Service Broker. Getting Error with setting up Initiator and Target Queues/Services on 1 Database -

i created queues, services, contract, etc. i'm using autocreatelocal binding. on database create start with. have activation sp fired.

when run ssbdiagnose utility follows

ssbdiagnose -e -s . -d myservicebroker configuration service //test.com/items/initiatorservice service //test.com/items/targetservice on contract //test.com/items/contract

it gives me 1 error.

d 29975 myservicebroker user dbo not have send permission on service //test.com/items/targetservice 1 errors, 0 warnings

i explicitly granting send on both services , receive on both queues public role.

grant receive on dbo.initiatorqueueitems public go grant receive on dbo.targetqueueitems public go grant send on service::[//test.com/items/initiatorservice] public go grant send on service::[//test.com/items/targetservice] public go

what can right?

what happens when send message on contract fires sp , removes message never see response message on target queue.

this diagnose message doesn't seem have bearing on working. problem lied in activation stored proc had created somehow got stuck in infinite loop.

sql-server service-broker