an ASP.NET Open Source CMS & eCommerce platform
Search:
Skip Navigation LinksHome > DotShoppingCart Forums > Support > Using DotShoppingCart > Database Issue after 3.1 upgrade
Last Post 4/28/2009 3:46:52 PM By lukezy. 3 replies.
4/28/2009 3:14:55 PM
Rober
Posts: 5
Joined: 12/11/2008
Location:Alabama, US
Database Issue after 3.1 upgrade
Service Broker needs to access the master key in the database '[dbname]'. Error code:25. The master key has to exist and the service master key encryption is required
 
This is in the Application Event Log after the upgrade to 3.1. The only change to the database (besides a backup) was the .sql scripts in the Migration folder of the 3.1 download. Anyone out there had experience with this. I am no SQL Server expert.
 
 
 
 
4/28/2009 3:29:57 PM
lukezy
Posts: 2109
Joined: 6/12/2007
Location:WA, US
Re: Database Issue after 3.1 upgrade
You can create a master key according to SQL books online.
DotShoppingCart Staff
4/28/2009 3:40:50 PM
Rober
Posts: 5
Joined: 12/11/2008
Location:Alabama, US
Re: Database Issue after 3.1 upgrade
Thanks,
 
How will creating a new key affect any of the current data in the database. I know you use a machine based key for some security, what role does this play?
 
 
4/28/2009 3:46:52 PM
lukezy
Posts: 2109
Joined: 6/12/2007
Location:WA, US
Re: Database Issue after 3.1 upgrade
It shouldn't have any effect. It's basically used to encrypt the dotshoppingcart database key which the service broker uses to encrypt sending messages. DSC doesn't use it directly. Make sure you create a backup of the master key in case you need to restore the database later on.
DotShoppingCart Staff