Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I am pretty new to SQL and administration of databases and still learning. We receive one SQL error for quiete a long time, which has as far as we know no effect on our application. So we put that to second priority. Now it starts bothering me and I want to know whats going on.

Service Broker needs to access the master key in the datasbase "xxx" Error Code:26. The Master Key hast to exist and the service Master Key encryption is required.

I checked our full sql log and found that the error occured out of nothing, I mean no updates installed at that time and no newer version was released of our application. So for me it came "out of nothing" at least I can't see anything now. It's some weeks ago that all started and maybe I can't remember everything.

How can it be possible that the service broker needs to access the master key and we don't even have keys in our db. we never created one.

Can anyone explain me how to use the key? I mean creating is ok :

USE xxx;
CREATE MASTER KEY ENCRYPTION BY PASSWORD = 'xxx';
GO

Any help is upvoted immediately.

share|improve this question
    
Have you seen this one? Should help to resolve this issue. stackoverflow.com/questions/4392343/… –  Ilja Nov 20 '13 at 22:07
    
i found out what i have to do. but that thread gives me additional useful information. please write whatever you want as answer and i give you 50 reputation. The points will be removed anyway if i don't get an answer. –  RayofCommand Nov 21 '13 at 9:16
add comment

1 Answer 1

up vote 1 down vote accepted
+50

RayofCommand, please share with community how you have resolved your issue. This is very important to leave results/comments in the thread. When next time somebody will have the same issue he will find your resolution thereby will save time and money)

share|improve this answer
1  
privet Ilja, if you are using the service broker and get this exception. You are probably missing the master key in your 'sys.symmetric_keys' . So what I did, I checked if I have it and if not created it : IF (select Count(*) from sys.symmetric_keys where name like '%Master Key%') = 0 BEGIN CREATE master key Encryption by password = 'yourpassword'; END –  RayofCommand Nov 21 '13 at 9:33
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.