Encryption and SSL Question

I am running MS 2003 Server with SQL Server 2000 including SP4 which I
installed yesterday. In addition, I have also installed SOAP Toolkit 3.0,
SQLXML 3.0 SP3 and SQLNS 2.0 SP1...not sure how much of this is relavent to
my question...
I am designing a web-page which sits behind an SSL...how do I encrypt my
data...i am accepting credit card and banking account information on this
page and then want to have a secure email sent to my outlook....so really
two questions here..
1. how do I encrypt data?
2. how do I send secure and/or encrypted email?
thanksDoesn't sound like it's a SQL Server issue here.
With SQL Server 2000, you'll need a 3rd party solution (Protegrity seems to
be a popular one) to encrypt data inside the database. SQL Server 2005 will
have encryption capabilities built in.
Network packet encryption is a "turn on/off" switch from the network
configuration utility.
Encrypting emails and SSL are not really tied to the database.
Did I misunderstand your question?
joe.
"SQL Brad" <SQLBrad@.discussions.microsoft.com> wrote in message
news:F7988D30-6E33-4E8C-AEE5-A0031952AE43@.microsoft.com...
>I am running MS 2003 Server with SQL Server 2000 including SP4 which I
> installed yesterday. In addition, I have also installed SOAP Toolkit 3.0,
> SQLXML 3.0 SP3 and SQLNS 2.0 SP1...not sure how much of this is relavent
> to
> my question...
> I am designing a web-page which sits behind an SSL...how do I encrypt my
> data...i am accepting credit card and banking account information on this
> page and then want to have a secure email sent to my outlook....so really
> two questions here..
> 1. how do I encrypt data?
> 2. how do I send secure and/or encrypted email?
> thanks|||Joe,
Thanks for your response...
I was told from a developer that I can build a SQL database and the contents
inside could be encrypted. I am looking for the 'easiest, cheapest, safest'
way to store banking information from my web-page into the db.
I should have made the email portion separate also. On that note, I would
like to write a stored procedure or use SQL-NS to tell me that a a'payment'
has been made and then an email (secure using TLS, or TSL') could be sent
out. does that make sense?
thanks for your help
"Joe Yong" wrote:
> Doesn't sound like it's a SQL Server issue here.
> With SQL Server 2000, you'll need a 3rd party solution (Protegrity seems to
> be a popular one) to encrypt data inside the database. SQL Server 2005 will
> have encryption capabilities built in.
> Network packet encryption is a "turn on/off" switch from the network
> configuration utility.
> Encrypting emails and SSL are not really tied to the database.
> Did I misunderstand your question?
>
> joe.
>
> "SQL Brad" <SQLBrad@.discussions.microsoft.com> wrote in message
> news:F7988D30-6E33-4E8C-AEE5-A0031952AE43@.microsoft.com...
> >I am running MS 2003 Server with SQL Server 2000 including SP4 which I
> > installed yesterday. In addition, I have also installed SOAP Toolkit 3.0,
> > SQLXML 3.0 SP3 and SQLNS 2.0 SP1...not sure how much of this is relavent
> > to
> > my question...
> >
> > I am designing a web-page which sits behind an SSL...how do I encrypt my
> > data...i am accepting credit card and banking account information on this
> > page and then want to have a secure email sent to my outlook....so really
> > two questions here..
> >
> > 1. how do I encrypt data?
> > 2. how do I send secure and/or encrypted email?
> >
> > thanks
>
>|||Hi
SQL Server 2000 will not encrypt it. You would have to do it in code.
SQL Server 2005 (in Beta) supports column level encryption.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"SQL Brad" <SQLBrad@.discussions.microsoft.com> wrote in message
news:512AED76-DB94-45EB-AC6A-C1BD46A40642@.microsoft.com...
> Joe,
> Thanks for your response...
> I was told from a developer that I can build a SQL database and the
> contents
> inside could be encrypted. I am looking for the 'easiest, cheapest,
> safest'
> way to store banking information from my web-page into the db.
> I should have made the email portion separate also. On that note, I would
> like to write a stored procedure or use SQL-NS to tell me that a
> a'payment'
> has been made and then an email (secure using TLS, or TSL') could be sent
> out. does that make sense?
> thanks for your help
> "Joe Yong" wrote:
>> Doesn't sound like it's a SQL Server issue here.
>> With SQL Server 2000, you'll need a 3rd party solution (Protegrity seems
>> to
>> be a popular one) to encrypt data inside the database. SQL Server 2005
>> will
>> have encryption capabilities built in.
>> Network packet encryption is a "turn on/off" switch from the network
>> configuration utility.
>> Encrypting emails and SSL are not really tied to the database.
>> Did I misunderstand your question?
>>
>> joe.
>>
>> "SQL Brad" <SQLBrad@.discussions.microsoft.com> wrote in message
>> news:F7988D30-6E33-4E8C-AEE5-A0031952AE43@.microsoft.com...
>> >I am running MS 2003 Server with SQL Server 2000 including SP4 which I
>> > installed yesterday. In addition, I have also installed SOAP Toolkit
>> > 3.0,
>> > SQLXML 3.0 SP3 and SQLNS 2.0 SP1...not sure how much of this is
>> > relavent
>> > to
>> > my question...
>> >
>> > I am designing a web-page which sits behind an SSL...how do I encrypt
>> > my
>> > data...i am accepting credit card and banking account information on
>> > this
>> > page and then want to have a secure email sent to my outlook....so
>> > really
>> > two questions here..
>> >
>> > 1. how do I encrypt data?
>> > 2. how do I send secure and/or encrypted email?
>> >
>> > thanks
>>|||You could use the encryption native to Windows to encrypt the FILE on disk
but it won't stop anyone from viewing the data if they get access to your
database. It only comes in handy if someone gets hold of the file. You will
need to encrypt the file using the account that runs SQL Server.
"SQL Brad" wrote:
> Joe,
> Thanks for your response...
> I was told from a developer that I can build a SQL database and the contents
> inside could be encrypted. I am looking for the 'easiest, cheapest, safest'
> way to store banking information from my web-page into the db.
> I should have made the email portion separate also. On that note, I would
> like to write a stored procedure or use SQL-NS to tell me that a a'payment'
> has been made and then an email (secure using TLS, or TSL') could be sent
> out. does that make sense?
> thanks for your help
> "Joe Yong" wrote:
> > Doesn't sound like it's a SQL Server issue here.
> >
> > With SQL Server 2000, you'll need a 3rd party solution (Protegrity seems to
> > be a popular one) to encrypt data inside the database. SQL Server 2005 will
> > have encryption capabilities built in.
> >
> > Network packet encryption is a "turn on/off" switch from the network
> > configuration utility.
> >
> > Encrypting emails and SSL are not really tied to the database.
> >
> > Did I misunderstand your question?
> >
> >
> > joe.
> >
> >
> > "SQL Brad" <SQLBrad@.discussions.microsoft.com> wrote in message
> > news:F7988D30-6E33-4E8C-AEE5-A0031952AE43@.microsoft.com...
> > >I am running MS 2003 Server with SQL Server 2000 including SP4 which I
> > > installed yesterday. In addition, I have also installed SOAP Toolkit 3.0,
> > > SQLXML 3.0 SP3 and SQLNS 2.0 SP1...not sure how much of this is relavent
> > > to
> > > my question...
> > >
> > > I am designing a web-page which sits behind an SSL...how do I encrypt my
> > > data...i am accepting credit card and banking account information on this
> > > page and then want to have a secure email sent to my outlook....so really
> > > two questions here..
> > >
> > > 1. how do I encrypt data?
> > > 2. how do I send secure and/or encrypted email?
> > >
> > > thanks
> >
> >
> >