We are trying to setup simple queue where we are trying to insert(enqueue) record ,it's inserted successfully .
But we can't find any element in the queue.when we used command
(select*fromsys.transmission_queue )
sys.transmission_queue, in column 'transmission_status' we are getting
'The session keys for this conversation could not be created or accessed. The database master key is required for this operation.'
For solving this we have used command
USE master ;
GO
ALTERDATABASE database name SET ENABLE_BROKER ;
but unable to solve it.
When we dequeue an element which already exist in the Queue we are able to dequeue it.
In a sample example we can dequeue the element which can be removed but we can't enqueue the element, we can send you sample if you need.
Regards,
Ali
Add an WITH ENCRYPTION = OFF to your BEGIN DIALOG statements to avoid session keys altogether.
Alternatively you could ensure that the databaseaster key exists and is encrypted with service master key:
create master key encryption by password = 'MyPassword';
alter master key add ADD ENCRYPTION BY SERVICE MASTER KEY;
