Service Broker FAQ

Question 1:

Service Broker FAQ

The activated procedure [dbo] that is running in the queue test.dbo.IncomingQueue. [Readincomingmessageproc]
The following information is output: ' Access to the ' remote server is denied because the ' current security context is not trusted. '
The request to access the remote server was denied because the current security context is not trusted.

Solve:
Modify the trust status of the running Service Broker database to be trusted, note that it must not be a trusted state of the remote target database
For example:
ALTER DATABASE [Guoqiang] SET trustworthy on
Go

Http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=668169&SiteID=1

Question 2:

Event Type: Information
Event Source: MSSQLServer
Event Type: (2)
Event id:9724
Date: 2008-4-16
Event: 10:26:19
Users: N/A
Computer: Qiangguo
Describe:
The activated procedure [dbo] that is running in the queue brokertest.dbo.IncomingQueue. [Readincomingmessageproc_good] Outputs the following information: ' The conversation endpoint is isn't in a valid state for SEND. The current endpoint ' DI '. '

Solve:
? DI was disconnected from the inbound. The remote side of the session has issued an end conversation. The session remains this state until the end conversation is issued on the local side of the session. The application can still receive session messages. The application cannot send messages through this session because the remote end of the session has closed the session. When the application issues end conversation, the session becomes CD state.

? DI, or disconnected_inbound This means the opposite end of the conversation has called end conversation but this ENDP oint hasn ' t. If you are many conversations in this state, the code handling this endpoint isn't calling end conversation when it Shoul D.

In writing the program is, define conversation_handle variables to avoid duplication. Otherwise, the problem may occur.