posts - 234, comments - 480, trackbacks - 56

My Links

News




I am born in Bangladesh and currently live in Melbourne, Australia. I am a co-founder and core developer of Pageflakes www.pageflakes.com and CEO at Simplexhub, a highly experienced software development company based in Melbourne Australia and Dhaka, Bangladesh. Simplexhub, is on its mission to build a smart virtual community in Bangladesh and recently launched beta realestatebazaar.com.bd an ASP.NET MVC application written in C#.NET.

I also created SmartCodeGenerator

Some of my articles
Flexible and Plugin based .Net Application..
Mass Emailing Functionality with C#, .NET 2.0, and Microsoft® SQL Server 2005 Service Broker'
Write your own Code Generator or Template Engine in .NET
Smart Code Generator .NET: Usage Overview
Smart Code Generator .NET: Architectural Overview
Smart Code Generator .NET: using with NAnt and Cassini

Archives

Free Programming Language Training

Sql Server 2005: The session keys for this conversation could not be created or accessed. The database master key is required for this operation.

Today I was playing with the Sql Server 2005 Service Broker funcrionality and created MessageType, Queues, Services, Contracts as necessary and after trying to Send Messages I could not find anything in the Queue.

After investigating further found that the Messages are all sitting in the sys.transmission_queue and with the following error.

The session keys for this conversation could not be created or accessed. The database master key is required for this operation.

After investigating further I realised that the DB do not have a masterkey and after creating the masterkey for the database all running ok.

In this link you will find a tool ServiceListingManager which can make life a lot easy on creating masterkey and certificates.

http://www.gotdotnet.com/codegallery/codegallery.aspx?id=9f7ae2af-31aa-44dd-9ee8-6b6b6d3d6319

 

Print | posted on Thursday, August 31, 2006 5:04 AM |

Feedback

No comments posted yet.
Post A Comment
Title:
Name:
Email:
Website:
Comment:
Verification:
 
 

Powered by: