How to resolve SQL Server service broker issue

Hi All,
Please help me out to resolve the below issue.

Below is the Error in logs

"Service Broker needs to access the master key in the database "Server_services". Error code:26. The master key has to exist and the service master key encryption is required".

Regards.
GK GKAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Eugene ZCommented:
you may need to recreate /set new broker on the db.
check for the key

Select *
from   sys.symmetric_keys;
 
if need to create master key:

How to: Create a Database Master Key
http://msdn.microsoft.com/en-us/library/aa337551(v=sql.105).aspx
0
arnoldCommented:
First thing to check is whether your SQL server is up-to-date with updates.
http://support.microsoft.com/kb/976691

The second is this following the addition of another encrypted DB, Server_services?

If you do not use encrypted DB's, update the service broker settings with encryption=Off
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
GK GKAuthor Commented:
Hi All,

We are created new Database Master Key and it resolved the issue.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.