Re: how to proceed

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Well, I do not know the possible workload on your server so I don't have any clue about how it is going to work.

I suggest you to install R2 to your Windows Server 2003 if you have not.

Good luck!

--
Ekrem Önsoy


"Rogers" <naissani@xxxxxxxxxxx> wrote in message news:Opnifkx6HHA.5980@xxxxxxxxxxxxxxxxxxxxxxx
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: Trouble Getting VS.Net 2003 WalkThroughs MSDE Connection
    ... Config Tool of SQL Server? ... > link to download the PUBs database. ... >>> Setup and they directed me to install MSDE and they attached a ...
    (microsoft.public.sqlserver.msde)
  • Re: Sharepoint not working anymore
    ... a way to rebuild the master database (which you can think of as the database ... Microsoft Small Business Server Support ... SBS Newsgroups: ... >> You mentioned that you had set out to install SP1... ...
    (microsoft.public.windows.server.sbs)
  • Re: Proposal for Lite Encryption for Login Form without SSL
    ... This way the password is not sent to the server ... simply copy the server-side salt used to hash the pw in the ... password in the database, it does make public the server-side salt ... This would be the equivalent to a public key in public key encryption ...
    (comp.lang.php)
  • Re: FlatFile Encryption using FILESTREAM
    ... If a folder on a domain contains confidential flat files, ... files can be added to a database filegroup and read using FILESTREAM. ... SQL Server ensures data-level consistency between the relational data in the ... "Note that this encryption is made by default when you create ...
    (microsoft.public.sqlserver.server)
  • Re: Multiple instances
    ... "We wrote the books on Project Server" ... >> install; one production, one demo. ... >> I first created a new project database, populated it by running setupdb, ... >> had MSProjectServerUser in the MSProjectMember Role text box under ...
    (microsoft.public.project.pro_and_server)