Database master key

There's a conflict on my understanding of the database master key in
SQL Server 2005.
Reading from the book, it mention database master key is optional.
But when I try to create certificate, it prompt me error:
====== Msg 15581, Level 16, State 1, Line 1
Please create a master key in the database or open the master key in
the session before performing this operation.
======
After I create the master key, then create the certificate again, it
works fine. It means that the database master key is mandatory IF I'm
going to use encryption.
Anyone can clarify this?
Thanks.
wodoy.peterYou need to use the ENCRYPTION BY PASSWORD clause.
"wodoy.peter" <wodoy.peter@.gmail.com> wrote in message
news:1170010225.064765.151440@.l53g2000cwa.googlegroups.com...
> There's a conflict on my understanding of the database master key in
> SQL Server 2005.
> Reading from the book, it mention database master key is optional.
> But when I try to create certificate, it prompt me error:
> ======> Msg 15581, Level 16, State 1, Line 1
> Please create a master key in the database or open the master key in
> the session before performing this operation.
> ======> After I create the master key, then create the certificate again, it
> works fine. It means that the database master key is mandatory IF I'm
> going to use encryption.
> Anyone can clarify this?
> Thanks.
>
> wodoy.peter
>|||Thanks.
On Jan 29, 12:46 pm, "Mike C#" <x...@.xyz.com> wrote:
> You need to use the ENCRYPTION BY PASSWORD clause.
> "wodoy.peter" <wodoy.pe...@.gmail.com> wrote in messagenews:1170010225.064765.151440@.l53g2000cwa.googlegroups.com...
>
> > There's a conflict on my understanding of the database master key in
> > SQL Server 2005.
> > Reading from the book, it mention database master key is optional.
> > But when I try to create certificate, it prompt me error:
> > ======> > Msg 15581, Level 16, State 1, Line 1
> > Please create a master key in the database or open the master key in
> > the session before performing this operation.
> > ======> > After I create the master key, then create the certificate again, it
> > works fine. It means that the database master key is mandatory IF I'm
> > going to use encryption.
> > Anyone can clarify this?
> > Thanks.
> > wodoy.peter- Hide quoted text -- Show quoted text -