 | |
how to proceed
microsoft.public.sqlserver.clients microsoft.public.sqlserver.clients
 |
| | Thread Tools | Display Modes |
#1
 
| |||
| |||
|
how to proceed -
08-28-2007
, 10:59 AM
#2
| |||
| |||
|
|
Hello Rogers, Will you tell us what kind of an encryption did you use for your database? -- Ekrem Önsoy "Rogers" <naissani (AT) hotmail (DOT) com> wrote in message news:eNaIvxY6HHA.5844 (AT) TK2MSFTNGP02 (DOT) phx.gbl... 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. |
#3
| |||
| |||
|
|
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 (AT) hotmail (DOT) com> wrote in message news:Ob$VD$w6HHA.980 (AT) TK2MSFTNGP06 (DOT) phx.gbl... 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 (AT) btegitim (DOT) com> wrote in message news:1EF69DAD-7138-435E-89AC-41DC7B3EA29A (AT) microsoft (DOT) com... Hello Rogers, Will you tell us what kind of an encryption did you use for your database? -- Ekrem Önsoy "Rogers" <naissani (AT) hotmail (DOT) com> wrote in message news:eNaIvxY6HHA.5844 (AT) TK2MSFTNGP02 (DOT) phx.gbl... 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. |
#4
| |||
| |||
|
|
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 (AT) hotmail (DOT) com> wrote in message news:Opnifkx6HHA.5980 (AT) TK2MSFTNGP04 (DOT) phx.gbl... 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 (AT) btegitim (DOT) com> wrote in message news:757611C1-9D9C-4D3D-BBED-19D0C4CC8087 (AT) microsoft (DOT) com... 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 (AT) hotmail (DOT) com> wrote in message news:Ob$VD$w6HHA.980 (AT) TK2MSFTNGP06 (DOT) phx.gbl... 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 (AT) btegitim (DOT) com> wrote in message news:1EF69DAD-7138-435E-89AC-41DC7B3EA29A (AT) microsoft (DOT) com... Hello Rogers, Will you tell us what kind of an encryption did you use for your database? -- Ekrem Önsoy "Rogers" <naissani (AT) hotmail (DOT) com> wrote in message news:eNaIvxY6HHA.5844 (AT) TK2MSFTNGP02 (DOT) phx.gbl... 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. |
#5
| |||
| |||
|
|
Check it out http://www.microsoft.com/windowsserver2003/default.mspx -- Ekrem Önsoy "Rogers" <naissani (AT) hotmail (DOT) com> wrote in message news:%23zelnGy6HHA.5752 (AT) TK2MSFTNGP04 (DOT) phx.gbl... R2 means Raid? Thanks "Ekrem Önsoy" <ekrem (AT) btegitim (DOT) com> wrote in message news:A5CF4674-3944-49F7-93DD-AF03D407AB02 (AT) microsoft (DOT) com... 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 (AT) hotmail (DOT) com> wrote in message news:Opnifkx6HHA.5980 (AT) TK2MSFTNGP04 (DOT) phx.gbl... 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 (AT) btegitim (DOT) com> wrote in message news:757611C1-9D9C-4D3D-BBED-19D0C4CC8087 (AT) microsoft (DOT) com... 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 (AT) hotmail (DOT) com> wrote in message news:Ob$VD$w6HHA.980 (AT) TK2MSFTNGP06 (DOT) phx.gbl... 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 (AT) btegitim (DOT) com> wrote in message news:1EF69DAD-7138-435E-89AC-41DC7B3EA29A (AT) microsoft (DOT) com... Hello Rogers, Will you tell us what kind of an encryption did you use for your database? -- Ekrem Önsoy "Rogers" <naissani (AT) hotmail (DOT) com> wrote in message news:eNaIvxY6HHA.5844 (AT) TK2MSFTNGP02 (DOT) phx.gbl... 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. |
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.