Encryption and SSL and Email

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?
thanksConsider posting this question to security newsgroups. There are no inbuilt
data encrytion routines in SQL Server, so if will have to roll out your own
functions. You can utilize the Cryptography APIs to come up with your own.
Regarding the emails, AFAIK xp_sendmail cannot send encrypted emails from
SQL Server.
Anith

encrypted email

Hi,
is there anyway to encrypt any emails that are sent out by using send db
mail? is that hanlded at the database level or exchange server level?
Any Idea?
Thanks
EdHi
"Ed" wrote:

> Hi,
> is there anyway to encrypt any emails that are sent out by using send db
> mail? is that hanlded at the database level or exchange server level?
> Any Idea?
> Thanks
> Ed
AFAIK there is no way to encrypt your email when using database mail, you
could encrypt the contents/attachments (separately) and send the encrypted
content/attachment, but you would need a method of decryption at the
recipient.
This is not the same as sending the email over an IPSEC or a similar
connection see
[url]http://www.microsoft.com/technet/prodtechnol/windows2000serv/howto/ispstep.mspx[/u
rl]
John

encrypted email

Hi,
is there anyway to encrypt any emails that are sent out by using send db
mail? is that hanlded at the database level or exchange server level?
Any Idea?
Thanks
EdHi
"Ed" wrote:
> Hi,
> is there anyway to encrypt any emails that are sent out by using send db
> mail? is that hanlded at the database level or exchange server level?
> Any Idea?
> Thanks
> Ed
AFAIK there is no way to encrypt your email when using database mail, you
could encrypt the contents/attachments (separately) and send the encrypted
content/attachment, but you would need a method of decryption at the
recipient.
This is not the same as sending the email over an IPSEC or a similar
connection see
http://www.microsoft.com/technet/prodtechnol/windows2000serv/howto/ispstep.mspx
John

encrypted email

Hi,
is there anyway to encrypt any emails that are sent out by using send db
mail? is that hanlded at the database level or exchange server level?
Any Idea?
Thanks
Ed
Hi
"Ed" wrote:

> Hi,
> is there anyway to encrypt any emails that are sent out by using send db
> mail? is that hanlded at the database level or exchange server level?
> Any Idea?
> Thanks
> Ed
AFAIK there is no way to encrypt your email when using database mail, you
could encrypt the contents/attachments (separately) and send the encrypted
content/attachment, but you would need a method of decryption at the
recipient.
This is not the same as sending the email over an IPSEC or a similar
connection see
http://www.microsoft.com/technet/prodtechnol/windows2000serv/howto/ispstep.mspx
John

Encrypt Report Attachments (through Subscriptions) -- possible?

We currently email out reports as either PDF or Excel attachments using Data Driven subscriptions in SSRS 2005. I've been asked to be able to encrypt the attachments and am wondering if anyone has done this or can point me in the right direction.

There's been a couple of mentions about "encrypted email" -- but I don't know where to find further information. Is this possible using SSRS subscriptions?

Thanks in advance,

- Jesse Wolgamott

Currenlty, the way to do this is to write a custom delivery extension. The one provided with reporting servcies does not support encrypting the report.

-Lukasz

|||Thanks!

For people who are reading this later on, more information about custom delivery extensions is here: http://msdn2.microsoft.com/en-us/library/ms154050.aspx

Encrypt Report Attachments (through Subscriptions) -- possible?

We currently email out reports as either PDF or Excel attachments using Data Driven subscriptions in SSRS 2005. I've been asked to be able to encrypt the attachments and am wondering if anyone has done this or can point me in the right direction.

There's been a couple of mentions about "encrypted email" -- but I don't know where to find further information. Is this possible using SSRS subscriptions?

Thanks in advance,

- Jesse Wolgamott

Currenlty, the way to do this is to write a custom delivery extension. The one provided with reporting servcies does not support encrypting the report.

-Lukasz

|||Thanks!

For people who are reading this later on, more information about custom delivery extensions is here: http://msdn2.microsoft.com/en-us/library/ms154050.aspx

Encrypt Report Attachments (through Subscriptions) -- possible?

We currently email out reports as either PDF or Excel attachments using Data Driven subscriptions in SSRS 2005. I've been asked to be able to encrypt the attachments and am wondering if anyone has done this or can point me in the right direction.

There's been a couple of mentions about "encrypted email" -- but I don't know where to find further information. Is this possible using SSRS subscriptions?

Thanks in advance,

- Jesse Wolgamott

Currenlty, the way to do this is to write a custom delivery extension. The one provided with reporting servcies does not support encrypting the report.

-Lukasz

|||Thanks!

For people who are reading this later on, more information about custom delivery extensions is here: http://msdn2.microsoft.com/en-us/library/ms154050.aspx

Encoding string from MS SQL

Hi all,

I have an application which will send out email in plain text in multi langauage.
the email content will be pull from txt file save in UTF-8.
i can send out email from the template with the encoding.
but when i insert data from the SQl server. the data from the SQL server are not encoded.
how do i encode the data (in other lanagauge) from sql server into UTF-8 so that it can be send together with the template.

I have try changing the data into byte and encode it in UTF-8.
but it won't displayed correctly. pls help. thanks

Unicode in SQL Server is either UCS-2 or UTF 16 and the later is the generally used version, .NET is UTF 16 by default so you can change your .NET encoding to UTF 16. The reason is NChar, NVarchar, NText, NChar max and NVarchar max are multi bytes by definition so you just need to convert to UTF 8 in your code. Hope this helps.|||

my data from the database look like this ??òú??. it is chinese simplified gb2313
the datatype for the fields is varchar.
so how do i encode it into UTF8 and it can be display in chinese.
pls help i'm totally confuse by the encoding.

|||

The Chinese you are using is Windows code page, there are six Chinese collation in SQL Server you have to find the right one in the thread below. And to UTF 8 encode in VS you start at the link below it is for VS2003 but I think it should work. So you do column level collation for your specific Chinese in SQL Server and do Unicode encoding in VS and it may be resolved. Hope this helps.

http://forums.asp.net/1067798/ShowPost.aspx

http://www.aspnetresources.com/blog/unicode_in_vsnet.aspx

|||

Hi Thanks for you advice,

base on your info i manage to find the extended proc to solve my prob xp_cp2u_web.
but i have another prob. in my stored procedure the output parameter i set it to a size of 20 data type nvarchar. it will return the result. and it will display correctly on screen. but when it is use to send via email. the rest of the content in the email is gone after my chinese character.

after some debugging, i found that it is due to the size of nvarchar i set. my chinese character size is 3. so if i set the nvarchar size to 3 all will work but if the size i set is bigger than the actual result return. it will affect the rest of the text in my email..

can anyone pls advise me on how to set the nvarchar size for my output sqlparameter.
is there a way where i can set the size of the Nvarchar as dynamic. Thanks

cmd5.CommandText = "GetEmailDetail";
cmd5.CommandType = CommandType.StoredProcedure;
cmd5.Parameters.Add("@.No", Service_ID);
SqlParameter parameterfullname = cmd5.Parameters.Add("@.name", SqlDbType.NVarChar, 20);
parameterfullname.Direction = ParameterDirection.Output;

|||

Try the link below everything you need is covered including the correct stored procedure because that is important. When you are getting value back from a SQL Server stored procedure it is OUTPUT parameter except INT which is return value, so if in doubt always use OUTPUT if it is not needed SQL Server will ignore it. So use correct column level collation and ADO.NET OUTPUT parameters. Hope this helps.

http://msdn.microsoft.com/msdnmag/issues/05/05/DataPoints/

Enabling E-Mail Delivery for RS

What is required in order to schedule a report for email delivery?
I have modified the RSReportServer.config file on SQL Server and created a
subscription for a report.
I can setup the subscription but it never runs.
Is there another step that I have left out?Carl,
Do you get any error messages in the Status column on the Subscriptions page
of report designer?
Andre
"Carl Meister" wrote:
> What is required in order to schedule a report for email delivery?
> I have modified the RSReportServer.config file on SQL Server and created a
> subscription for a report.
> I can setup the subscription but it never runs.
> Is there another step that I have left out?
>|||Andre,
On the subscriptions page for the report in the status column is "New
Subscription".
The Last Run column is empty.
I have this report scheduled to run every hour but it seems like it never
kicks off.
"Andre" wrote:
> Carl,
> Do you get any error messages in the Status column on the Subscriptions page
> of report designer?
> Andre
> "Carl Meister" wrote:
> > What is required in order to schedule a report for email delivery?
> >
> > I have modified the RSReportServer.config file on SQL Server and created a
> > subscription for a report.
> >
> > I can setup the subscription but it never runs.
> >
> > Is there another step that I have left out?
> >|||Hi Carl
I think the "SQL Agent" need to run, check this.
BR Per

Enable Email Delivery of Reports

We have just installed SQL Server and Reporting Services. I'm trying to
setup automatic EMAIL delivery of some reports, but the only option I have
is to deliver to a file share.
How can I enable email delivery as a delivery option on SSRS? Thanks a ton
for your help.It won't be an option until you configure RS with an email source. You have
several options for this. My company has a smtp server around that does not
require a password to use to send email. Use the Reporting Services
Configuration tool to configure it for email.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"HBJimmie" <someone@.mydomain.com> wrote in message
news:4FFAADAD-A502-473B-96FB-2C5C525A495A@.microsoft.com...
> We have just installed SQL Server and Reporting Services. I'm trying to
> setup automatic EMAIL delivery of some reports, but the only option I have
> is to deliver to a file share.
> How can I enable email delivery as a delivery option on SSRS? Thanks a ton
> for your help.