Geeks With Blogs

News Awarded Microsoft MVP C#.NET - 2007, 2008 and 2009


I am born in Bangladesh and currently live in Melbourne, Australia. I am a Microsoft Certified Application Developer MCAD Chartered Member (C# .Net)and born in Bangladesh.
I am founder and Chief Executive Officer of
Simplexhub, a highly experienced software development company based in Melbourne Australia and Dhaka, Bangladesh. Co-founder and core developer of Pageflakes www.pageflakes.com.
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.


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
Shahed Khan blog

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

 

Posted on Thursday, August 31, 2006 5:04 AM | Back to top


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

No comments posted yet.
Your comment:
 (will show your gravatar)


Copyright © Shahed Khan | Powered by: GeeksWithBlogs.net