Wednesday, March 21, 2012

Encrypting SQL database

Hi,
Is it possible to encrypt a MS SQL database '
Thanks
Rajeev RYes.
In Books on Line search for encrypting.
Peter
>--Original Message--
>Hi,
> Is it possible to encrypt a MS SQL database '
>Thanks
>Rajeev R
>
>.
>|||you can detach database and log onto a client (or server) under the sql user
account and navigate to those files. then on those database files set the
encryption bit/OK. you then can reattach the db files.
might be an idea for you to take a (non encrypted) copy of the files first
in case you run into problems, although the procedure is quite straight
forward.
--
BR,
Mark Broadbent mcse+i, mcdba
_________________________
"Rajeev Ramanujan" <rajeevramanujan@.hotmail.com> wrote in message
news:%23N1E7gcUDHA.1004@.TK2MSFTNGP12.phx.gbl...
> Hi,
> Thanks for your reply.
> I have a database named DATACLIENTS in my SQL Server. How will I
encrypt
> this database ?
> Can you help me for this ?
> Thanks
> Rajeev R
>
> "Mark Broadbent" <nospamplease_mark.broadbent@.virgin.net> wrote in message
> news:JxNTa.8123$g4.157900@.news1.nokia.com...
> > yes. as long as the files are encypted under your SQL service account.
> >
> > --
> > BR,
> >
> > Mark Broadbent mcse+i, mcdba
> > _________________________
> > "Rajeev Ramanujan" <rajeevramanujan@.hotmail.com> wrote in message
> > news:uqr$LPcUDHA.1748@.TK2MSFTNGP12.phx.gbl...
> > > Hi,
> > >
> > > Is it possible to encrypt a MS SQL database '
> > >
> > > Thanks
> > > Rajeev R
> > >
> > >
> >
> >
>sql

No comments:

Post a Comment