Encryption of Data in SQL05

My current experience is with access and sql2000. In my current application, I compress/encrypt my data prior to storing in my database. Does the new verion of sql support compression/encryption and if so can you please point me to any links which discuss.

thanks,

Fred Herring

Encryption is supported in SQL Server 2005, see for example:

http://msdn2.microsoft.com/en-us/library/ms345262(en-US,SQL.90).aspx

I also have a number of postings with examples on my blog:

http://blogs.msdn.com/lcris/archive/category/10357.aspx

If you want to evaluate the encryption features of SQL Server 2005, they're also available in the Express edition, which you can get from here:

http://msdn.microsoft.com/sql/express/

If you need more specific information, this is the right place to post questions.

Thanks
Laurentiu

|||

I have read that encryption is available for SQL 05. I have also attempted encryption on a column.

What are some good examples and practices when using encryption in SQL 05? How and where is the key stored?

How does the key work per column, or one per database?

How do you manage encryption keys?

Where are encryption keys stored and where is a safe place to store them? I don't have a full understanding of how encryption works in SQL 05, so any help would be great- I've read syntax and how to create and use them- but only in an example- I have not used them in practice- I don't understand how to use them in a real world example, or at least for our business.

Any help?

|||

You can find detailed answers to these questions by following these links:

Encryption Hierarchy article in Books Online:
http://msdn2.microsoft.com/en-us/library/ms189586.aspx

My blog with various examples and discussions of encryption functionality:
http://blogs.msdn.com/lcris/archive/category/10357.aspx

If after reading those articles, you still have questions that are unanswered, let us know.

Thanks
Laurentiu

|||Great! Thanks for the blog and the links! I look forward to diving into these!

encrypting backup in sql2000

Hi
Does anyone know what is the best way to encrypt the backups in sql server
2000.
I know sqllite software but are there any freeware or utilities that
can encrypt the backups.
Tks
Mangesh
there could be others as well but the one I found out randomly is
Mizo - CD Librarian License: Freeware
You can find it:
http://www.dirfile.com/freeware/stor...-migration.htm
Regards,

encrypting backup in sql2000

Hi
Does anyone know what is the best way to encrypt the backups in sql server
2000.
I know sqllite software but are there any freeware or utilities that
can encrypt the backups.
Tks
Mangeshthere could be others as well but the one I found out randomly is
Mizo - CD Librarian License: Freeware
You can find it:
http://www.dirfile.com/freeware/sto...e-migration.htm
Regards,sql

encrypting backup in sql2000

Hi
Does anyone know what is the best way to encrypt the backups in sql server
2000.
I know sqllite software but are there any freeware or utilities that
can encrypt the backups.
Tks
Mangeshthere could be others as well but the one I found out randomly is
Mizo - CD Librarian License: Freeware
You can find it:
http://www.dirfile.com/freeware/stored-procedure-migration.htm
Regards,

Encrypted data

Hi,
How can I save encryped data in SQL2000? Also, how can I retrieve it?xp_crypt (http://www.activecrypt.com/xp_crypt_364d.zip)|||I have written my own encryption algo in all our in-house applications
and it is running great guns...
I handled both encryption and decrytion at app level,i.e both encrypt()
and decrypt() are defined in applications
just try writing ur own encrypt function or use std algo like
blowfish etc...

Encrypt Data

Hi,

In SQL2000 i need to Encryptdata when I export data using DTS.LikeWise I should when i import data I should authenticate that user and decrypt that.

Can any one help?

Thanks,

Karthik

vgvKarthik wrote:

Hi,

In SQL2000 i need to Encryptdata when I export data using DTS.LikeWise I should when i import data I should authenticate that user and decrypt that.

Can any one help?

Thanks,

Karthik

Yeah. Try a different forum. This has got nothing to do with SSIS.

-Jamie

emtpy sysperfinfo table

Hello!
I am getting no records when querying sysperinfo table:
select * from master..sysperfinfo
This is production server running SQL2000 SP3 onWindows 2002 . I saw many
people asking the same question but didn't find a definite answer. As a
result, I do not see any of the SQL Server counters in the system monitor. I
am pretty much sure server was installed with performance counters.
Any advice would be greatly appreciated.
IgorCheck the following article as it very likely may apply to
the problems you are having - note the message that is
logged to the error log, that's one way to verify if it
applies in your case:
FIX: "Performance monitor shared memory setup failed: -1"
error message when you start SQL Server
http://support.microsoft.com/?id=812915
-Sue
On Tue, 23 Nov 2004 17:05:05 -0800, "Igor"
<imarchenko@.bowneglobal.com> wrote:
>Hello!
>I am getting no records when querying sysperinfo table:
>select * from master..sysperfinfo
> This is production server running SQL2000 SP3 onWindows 2002 . I saw many
>people asking the same question but didn't find a definite answer. As a
>result, I do not see any of the SQL Server counters in the system monitor. I
>am pretty much sure server was installed with performance counters.
> Any advice would be greatly appreciated.
>
>Igor
>|||Hello Sue,
I do not get error you mentioned in SQL Server error log. I also do not
think this case applies to my problem.
Thanks,
Igor
"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
news:6mp7q0pfkrjmp7mfgb8gdn3k4t7lka5ti1@.4ax.com...
> Check the following article as it very likely may apply to
> the problems you are having - note the message that is
> logged to the error log, that's one way to verify if it
> applies in your case:
> FIX: "Performance monitor shared memory setup failed: -1"
> error message when you start SQL Server
> http://support.microsoft.com/?id=812915
> -Sue
> On Tue, 23 Nov 2004 17:05:05 -0800, "Igor"
> <imarchenko@.bowneglobal.com> wrote:
> >Hello!
> >
> >I am getting no records when querying sysperinfo table:
> >
> >select * from master..sysperfinfo
> >
> > This is production server running SQL2000 SP3 onWindows 2002 . I saw
many
> >people asking the same question but didn't find a definite answer. As a
> >result, I do not see any of the SQL Server counters in the system
monitor. I
> >am pretty much sure server was installed with performance counters.
> > Any advice would be greatly appreciated.
> >
> >
> >Igor
> >
>|||Your symptoms do point to the issue in the KB Sue mentioned. Usually when
you don't get the counters (which come from syserfinfo) and your
lastwaittype column in sysprocesses is always Misc you blew away the
counters. The short term solution is to stop anything that is monitoring
the counters and restart SQL Server.
--
Andrew J. Kelly SQL MVP
"Igor" <imarchenko@.bowneglobal.com> wrote in message
news:elohshc0EHA.3708@.TK2MSFTNGP14.phx.gbl...
> Hello Sue,
> I do not get error you mentioned in SQL Server error log. I also do not
> think this case applies to my problem.
> Thanks,
> Igor
> "Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
> news:6mp7q0pfkrjmp7mfgb8gdn3k4t7lka5ti1@.4ax.com...
>> Check the following article as it very likely may apply to
>> the problems you are having - note the message that is
>> logged to the error log, that's one way to verify if it
>> applies in your case:
>> FIX: "Performance monitor shared memory setup failed: -1"
>> error message when you start SQL Server
>> http://support.microsoft.com/?id=812915
>> -Sue
>> On Tue, 23 Nov 2004 17:05:05 -0800, "Igor"
>> <imarchenko@.bowneglobal.com> wrote:
>> >Hello!
>> >
>> >I am getting no records when querying sysperinfo table:
>> >
>> >select * from master..sysperfinfo
>> >
>> > This is production server running SQL2000 SP3 onWindows 2002 . I saw
> many
>> >people asking the same question but didn't find a definite answer. As a
>> >result, I do not see any of the SQL Server counters in the system
> monitor. I
>> >am pretty much sure server was installed with performance counters.
>> > Any advice would be greatly appreciated.
>> >
>> >
>> >Igor
>> >
>

empty resultset from sql2005

Hi,

I have used Red Gates SQL bundle to make an identical db on sql2005 express from sql 2000. When i run my query against the sql2000 i get what I want, but when i run it against the sql2005, i get nothing.

Anyone got any suggestions to why?

web.config:

<!-- <add name="TPLConnectionString" connectionString="Data Source=[SQL2000],1433;Network Library=DBMSSOCN;Initial Catalog=TPL;User ID=??;Password=????;"

providerName="System.Data.SqlClient" />

-->

<

addname="TPLConnectionString"connectionString="Data Source=[SQL2005]\\SQLEXPRESS,1433;Integrated Security=true;Network Library=DBMSSOCN;Initial Catalog=TPL;User ID=???;Password=???;"providerName="System.Data.SqlClient" />

default.aspx.cs

dbConnection.Open();

String ISPQuery ="SELECT STATEMENT";SqlCommand command =newSqlCommand(ISPQuery, dbConnection);SqlDataReader reader = command.ExecuteReader();

Please help!!!

Best regards

Terje Kristensen

Could you try using '(local)\SQLEXPRESS'rather than '[SQL2005]\\SQLEXPRESS''

I had a little difficulty with SQLEXPRESS being a bit precious. I don't know if it'll help but if you're out of ideas... Otherwise I'm being stupid and the '\\' is a typo :/

|||

Hi.

Thank you for replying. It did not help changing the servername to (local), but when I removed the following:

;Integrated Security=true;Network Library=DBMSSOCN

it suddenly worked!

Thank you for helping.

Best regards

Terje Kristensen