Re: how to proceed

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

I think I have to go to Symmetric Key becuase I also want good performance,
Sql Server 2000 already installed into that Server and I am going to install
SQL Server 2005 as a Named Instace. Here is my server configuration, What is
your thought.

Windows Server 2003
Service Pack 2

Dell Server
2.99 GHz 2 GB of RAM


Thanks


"Ekrem Önsoy" <ekrem@xxxxxxxxxxxx> wrote in message
news:757611C1-9D9C-4D3D-BBED-19D0C4CC8087@xxxxxxxxxxxxxxxx
Well... It depends on your needs.

If you are looking for a tough encryption (this brings performance
degradation), then you could use Certificates \ Asymmetric Keys,

If you are looking for an encryption (which is not as powerful as the
previous ones) which does not affect performance as much as the others,
then you could Symmetric Keys.

It's your choice. But both of them asks for a sacrifice from your system.

Please read the following articles from BOL
About Master Key:
http://msdn2.microsoft.com/en-us/library/ms174382.aspx

Symmetric Key:
http://msdn2.microsoft.com/en-us/library/ms188357.aspx

Asymmetric Key:
http://msdn2.microsoft.com/en-us/library/ms174430.aspx

Certificate:
http://msdn2.microsoft.com/en-us/library/ms187798.aspx



--
Ekrem Önsoy




"Rogers" <naissani@xxxxxxxxxxx> wrote in message
news:Ob$VD$w6HHA.980@xxxxxxxxxxxxxxxxxxxxxxx
That's also I want to ask from you guys like I have a Windows 2003 Server
Service Pack 2. Which Encryption would be best and more secure. I would
appreciate if you can send me any step by step Installation & Encryption
website.

Thanks

"Ekrem Önsoy" <ekrem@xxxxxxxxxxxx> wrote in message
news:1EF69DAD-7138-435E-89AC-41DC7B3EA29A@xxxxxxxxxxxxxxxx
Hello Rogers,


Will you tell us what kind of an encryption did you use for your
database?


--
Ekrem Önsoy



"Rogers" <naissani@xxxxxxxxxxx> wrote in message
news:eNaIvxY6HHA.5844@xxxxxxxxxxxxxxxxxxxxxxx
Dear Experts.

I have a SQL Server 2000 on my production machine and contains 31
databases, one of the database contain most critical information, now
our organization wants that database should be encrypted, just because
of that I am going to installed SQL Server 2005 side by side
installation on the same box and restore that database into SQL Server
2005 and implement the encryption, I would appreciate if any one of
your guide me the better approach or what sort of information I have to
be considered before installing and implementing this.



Thanks in advance.








.

Relevant Pages

  • Re: CREATE SYMMETRIC KEY
    ... AES is only supported by SQL Server on Windows 2003. ... To test it out using encryption, I created a database, TestEncrypt, ... CREATE SYMMETRIC KEY SSN_Key_01 ... DECRYPTION BY CERTIFICATE HumanResources037; ...
    (microsoft.public.sqlserver.security)
  • RE: SQL 2005 Dev - No Encryption Library Installed
    ... I was accidently connecting my SQL Server 2005 Management Console to a SQL ... to the SQL Server 9.0 database, voila, the encryption works as advertised. ... CREATE SYMMETRIC KEY SecureSymmetricKey ...
    (microsoft.public.sqlserver.security)
  • Re: how to proceed
    ... I have a SQL Server 2000 on my production machine and contains 31 databases, one of the database contain most critical information, now our organization wants that database should be encrypted, just because of that I am going to installed SQL Server 2005 side by side installation on the same box and restore that database into SQL Server 2005 and implement the encryption, I would appreciate if any one of your guide me the better approach or what sort of information I have to be considered before installing and implementing this. ...
    (microsoft.public.sqlserver.clients)
  • [NT] SQL Server Installation Process May Leave Passwords on System
    ... service pack for SQL Server 7.0 or SQL Server 2000, ... without having to actually perform an installation. ... to SQL Server 7.0 Service Pack 4, the passwords were stored in clear text. ... information in the setup.iss and log files would not allow any access. ...
    (Securiteam)
  • Re: SQL or Access DB
    ... As far as encryption goes though... ... with Sql Server you can use SQL DMO and encrypt your stored procedures ... installation - Security was absolutely critical and in most instances, ... > then we create a nice gui around this database and sell it to automotive ...
    (microsoft.public.dotnet.languages.vb)