November 17, 2008 at 10:42 am
I have set up a stored procedure that begins a dialog and sends a message and a procedure that is activated by the message such that both the sender and receiver exist in the same database.
I am receiving an error that I think is caused by the send statement that appears to be related to security or permissions and I am not clear how to resolve the problem.
The error is
An exception occurred while enqueuing a message in the target queue Error 15404 State 19 could not obtain information about windows NT group 'xxxx' eror code 0x5.
I created all of the service broker components and related procedures as sa. I am login into SQL Server as sa. The xxxx domain\user referenced is my windows domain login (suser_name()), but I am not sure why that even plays into this at all.
November 17, 2008 at 1:24 pm
one reason might be hopping ID, i.e. your id might be present in several groups. or check this out and see if this helps:
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=65711&SiteID=1
Maninder
www.dbanation.com
November 17, 2008 at 4:58 pm
Thank you for the response. It seemed that I needed to use the alter authorization command to alleviate this issue.
A follow-on question. In the activation procedure if there are no rows received I rollback the transaction and return. If the procedure recieves the message type I am looking for I process the message and end the conversation. All appears to work well except that I see there is an entry in the sys.converstion_endpoints table each time the activation procedure executes. I would think I fix this issue with the 'with cleanup' clause on the end conversation, but everything that I read indicates that this clause should only used during development. It is unclear why there is an instance added to this table everytime the activation procedure execs.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply