Encryption of Data in SQL Server 2000

I know it is possible to encrypt data going to and from SQL Server, but is
there any way to encrypt the data within a DB, either on a whole DB basis, o
r
specific tables or specific fields within tables?
Kind regards
Ross PetersenThere is no native on-disk encryption in SQL 2000. That feature was added
to SQL 2005 and works pretty good.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Ross" <Ross@.discussions.microsoft.com> wrote in message
news:5DE2DCC2-E813-40A4-87EC-AFE43B0BA0C1@.microsoft.com...
>I know it is possible to encrypt data going to and from SQL Server, but is
> there any way to encrypt the data within a DB, either on a whole DB basis,
> or
> specific tables or specific fields within tables?
> Kind regards
> Ross Petersen|||Thanks Geoff
--
Kind regards
Ross Petersen
"Geoff N. Hiten" wrote:

> There is no native on-disk encryption in SQL 2000. That feature was added
> to SQL 2005 and works pretty good.
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
>
> "Ross" <Ross@.discussions.microsoft.com> wrote in message
> news:5DE2DCC2-E813-40A4-87EC-AFE43B0BA0C1@.microsoft.com...
>
>|||S2K not support native encryption mechanism.
But support serveral hash functions and extended procedures.
You cans access below url how to extended peocesure(hash function).
http://www.codeproject.com/database/xp_md5.asp
Also,You can review encryption in SQL Server 2005.
"Ross"?? ??? ??:

> I know it is possible to encrypt data going to and from SQL Server, but is
> there any way to encrypt the data within a DB, either on a whole DB basis,
or
> specific tables or specific fields within tables?
> Kind regards
> Ross Petersen|||Thanks hongju
very helpful
Kind regards
Ross Petersen
"hongju" wrote:
[vbcol=seagreen]
> S2K not support native encryption mechanism.
> But support serveral hash functions and extended procedures.
> You cans access below url how to extended peocesure(hash function).
> http://www.codeproject.com/database/xp_md5.asp
> Also,You can review encryption in SQL Server 2005.
>
> "Ross"?? ??? ??:
>

Enabling Network Protocols in MSDE 2000

Hello,
I installed MSDE 2000 it's not accepting connections from
any machine i think the network protocols got disabled is
there a way to enable them rather than installing again
MSDE installs a tool called srvnetcn.exe that can be used to configure the
network protocols of an MSDE instance. It is located in
Program Files\Microsoft SQL Server\80\Tools\Binn
Jim
"sch" <anonymous@.discussions.microsoft.com> wrote in message
news:1a4e501c41d83$c6d49b80$a101280a@.phx.gbl...
> Hello,
> I installed MSDE 2000 it's not accepting connections from
> any machine i think the network protocols got disabled is
> there a way to enable them rather than installing again
|||Hi Jim,
Actually svrnetcn.exe.
HTH,
Greg Low (MVP)
MSDE Manager SQL Tools
www.whitebearconsulting.com
"Jim Young" <thorium48@.hotmail.com> wrote in message
news:OYHIoBaHEHA.2300@.tk2msftngp13.phx.gbl...
> MSDE installs a tool called srvnetcn.exe that can be used to configure the
> network protocols of an MSDE instance. It is located in
> Program Files\Microsoft SQL Server\80\Tools\Binn
> Jim
>
> "sch" <anonymous@.discussions.microsoft.com> wrote in message
> news:1a4e501c41d83$c6d49b80$a101280a@.phx.gbl...
>
|||Thanks Very Much Guys!
|||
>--Original Message--
>MSDE installs a tool called srvnetcn.exe that can be
used to configure the
>network protocols of an MSDE instance. It is located in
>Program Files\Microsoft SQL Server\80\Tools\Binn
>Jim
>
>"sch" <anonymous@.discussions.microsoft.com> wrote in
message[color=darkblue]
>news:1a4e501c41d83$c6d49b80$a101280a@.phx.gbl...
from[color=darkblue]
is
>
>.
>works great, thanks Jim