Re: How to encrypt a column in SQL Server

Hi everyone,

How can you encrypt a column in SQL Server?? I have a text box in Access when user types in his/her password I would like the field to display something like **** in the text box. The password field is a field in a table on SQL Server.
I'm using AC2K and SQL Server 2K.

Thanks in advance.To make the control show asterisks, set its password attribute.

To encrypt the data, pick an encryption algorithm and implement that algorithm in your Access MDB or data project.

-PatP|||we did this one for her already

http://www.dbforums.com/t1095162.html|||Yeah, I know we've done it before... I think more than once actually.

I just figure that if we consistantly give the same answers, eventually it will help solve the problem. Maybe I should have just posted a link to one of the previous answers, but I was feeling too lazy to go find it just then. I've been kind of busy lately, and that often leads me to take the easy answer instead of doing it up properly, especially if the easy and proper ways both generate the same results!

-PatP|||but it is kind of a waste of my employers hard paid salary to have me redudently goofing off.|||I suppose that's true, but they are rarely discriminating about goofing off. I've never heard of a case where redundant goofing off was treated differently than applied goofing off was.

-PatP|||Owhay ancay ooyay encryptay anay olumnkay innay SQLAY Erversay? Unway ethodmay issay ootay oosyay uhthay amousfay "Igpay Atinlay" gorithmlay. Rytay ittay eforebay ooyay ecideday ootay ostpay uthay amesay amnday estionquay againay.

Okay?

Re: How do you encrypt a password column?

Hi all,
How do you encrypt a password column in SQL Server 2000 table?
I would like to store something like *** in the column.
Thanks much!do you submit the same question every couple of weeks to drive me insane?|||I'd check here (http://www.dbforums.com/showthread.php?t=1099654), or here (http://www.dbforums.com/showthread.php?t=1095162) for a couple of answers.

-PatP|||I beleive it's an agent that wakes up once a week...|||Try this:

create function EncryptPassword(@.PasswordString varchar(20))
returns char(10)
as
begin
declare @.NewPassword varchar(20)
set @.NewPassword = isnull(nullif(@.PasswordString, @.PasswordString), '**********')
return @.NewPassword
end|||Here is an even stronger algorithm. It uses a single-pass one-way encryption hash that is very secure. It is impossible to decrypt. As far as I know, this method has never been cracked:

drop function EncryptPassword
go
create function EncryptPassword(@.PasswordString varchar(20))
returns char(10)
as
begin
declare @.ASCIICounter as integer
set @.PasswordString = upper(@.PasswordString)
set @.ASCIICounter = ascii('A')

while @.ASCIICounter <= ascii('Z')
begin
set @.PasswordString = replace(@.PasswordString, char(@.ASCIICounter), '*')
set @.ASCIICounter = @.ASCIICounter + 1
end

return @.PasswordString
end|||Hi,

To those who replied with help I appreciated always.
To those who replied with criticisms don't reply at all. Who are you to judge other people. Either help or don't.
Thanks!|||Now look here. I posted some help when you asked this question 2 times ago. . In fact several fine solutions were suggested to your problem each time you posted this.

I like helping people, but it gets a little fustrating answering the same question from the same person all of the time.

If you do not understand the answers, say so. We will explain further but don't keep posting the same question. It's annoying.|||You may have seen the post more than once someone may not.
The possible solutions may not be the one One is seeking for.
Its probably annoying or frustrating what you think is the problem. No one should be publicly humiliated.|||YOU (alicejwz) need to quit posting the same d@.mn question over and over again.

Very knowledgeable, very intelligent, very patient, and very generous people have already given you the ONLY ANSWER YOU WILL GET.

SEVERAL TIMES!

And frankly, it is INSULTING that you just keep posting the same question hoping somebody new will give you a better answer.

You think the people on this forum aren't smart enough to know the answer to such a simple question? Then go find some other forum to pester.

Bleh!|||Hi,

To those who replied with help I appreciated always.
To those who replied with criticisms don't reply at all. Who are you to judge other people. Either help or don't.
Thanks!

Ummm...do you know the difference?

And lighten up Francis|||YOU (alicejwz) need to quit posting the same d@.mn question over and over again.

Very knowledgeable, very intelligent, very patient, and very generous people have already given you the ONLY ANSWER YOU WILL GET.

SEVERAL TIMES!

And frankly, it is INSULTING that you just keep posting the same question hoping somebody new will give you a better answer.

You think the people on this forum aren't smart enough to know the answer to such a simple question? Then go find some other forum to pester.

Bleh!

Yo dude...who replied with help?

EDIT: And where's Karolyn Been?

I think that's her login|||You may have seen the post more than once someone may not.
The possible solutions may not be the one One is seeking for.
Its probably annoying or frustrating what you think is the problem. No one should be publicly humiliated.If you just want to bring the thread back to the top of the list, then "bump" it. Add a new posting at the end and simply comment that you are still looking for another answer, or even just the word "bump" by itself. That way the folks who've already responded will easily recognize both that they've already answered the question, and that you weren't satisfied with the answers you've gotten so far.

The people who reply to questions are a scarce resource... Well over 90% of the people that visit will never post, and another 9% will only post questions. The remainder is all that we've got to provide answers, so anything that irritates them is a danger to the forum itself. I'm not trying to tell you to bow and scrape to the posters, but please consider that they volunteer to help with problems... If you want that resource available quickly, easily, and for free, you need to husband it carefully!

Nobody is trying to humiliate you (yet), you'll know much more clearly when that happens! The repeated posting of the same question is like repeatedly asking the same question at a party... It is often ignored the first time it is repeated, sets people to whispering after that, and gets a rather stern lecture if it goes on too long. Right now you're well into the whispering stage with this question.

-PatP|||The possible solutions may not be the one One is seeking for.

I posted something like that on the Pagan forum! (It seemed to be the right place for it.)

:)|||I posted something like that on the Pagan forum! (It seemed to be the right place for it.)

:)

Do you mean the Oracle forum?|||If you just want to bring the thread back to the top of the list, then "bump" it. Add a new posting at the end and simply comment that you are still looking for another answer, or even just the word "bump" by itself. That way the folks who've already responded will easily recognize both that they've already answered the question, and that you weren't satisfied with the answers you've gotten so far.be very careful when doing this

if you capriciously just "bump" for no stated reason, your bumping post might be deleted by a moderator

in other words, your thread will be left alone, but the last "bump" will be removed|||be very careful when doing this

if you capriciously just "bump" for no stated reason, your bumping post might be deleted by a moderator

in other words, your thread will be left alone, but the last "bump" will be removed

Why is this?

You got a rule book?|||'cause Sheriff Rudy says so, that's why.

Though up there I guess they call them "Mounties".

Re: How can you encrypt a column in SQL Server?

Hi everyone,

How can you encrypt a column in SQL Server?? I have a text box in Access when user types in his/her password I would like the field to display something like **** in the text box. The password field is a field in a table on SQL Server.
I'm using AC2K and SQL Server 2K.

Thanks in advance.Pick an encryption method, and handle it on the client. ROT13 is fine for most casual stuff, BlowFish is good for the really hairy stuff.

-PatP|||In access, right click on your textbox and go to properties. on the data tab, put Password in the input mask field.

this how ever is not encryption. There are third party dll available that use the RSA cypher and other methods to encrpyt data with public key encryption and you can write the encrypted data to SQL server but you can not really encrypt a column per se.|||You may want to look into SQLShield, but as it was noted before, - the encryption should be done in the front-end code, so that clear-text passwords are not travelling the network.|||sql server 2k gives you the ability to set permissions on a single column in a table if you wish.
however, you could give users access to the table through a view and not include the pwd column in the view definition.

just an alternative.