How to encrypt a column(field in a table) in MS SQL 2000

Hi,
I want to store user-id and passwords in a table in SQL Server. But as passwords are very secure, I want to encrypt them while storing and may be decrypt them when reqd.
How can I achieve this functionality
Thanks
-Sudhakarpublic key encryption. it is not built into sql2k. google it.|||It is unnecessary to decrypt passwords.
Store the encrypted string in the database. When someone submits a passwords for authentication, encrypt it using the same algorithm and compare the results with what is stored in the database.
This is called one-way encryption, and is both much simpler and much more secure than two-way encryption. I have a one-way encryption algorithm you can use if you want it.sql

How to enable SSL for HTTP endpoint?

Hi,

I'd like to know how can I setup the SSL so I can secure my HTTP Endpoint.

I saw in the documentation that some settings such as SSL_PORT and PORTS should be set to SSL port number and SSL but I did not find out anywhere where they explain how to enable SSL.

Do we enable SSL the same way we enable it or SQL Server 2005 or does that have to be done through the MMC - Certificates.

I don't have any IIS server running on this server, so I was wondering if IIS is a requirement to generate and import the certificate.

I appreciate your help and comments.

Bruce.

Bruce,

You can use the same SSL certificate as IIS if you like. Once the SSL certificate is setup for the IPAddressort combination, all you need is to configure the ENDPOINT to support SSL.

For additional information on how to configure a SSL certificate for use by the ENDPOINT, please refer to the "Configuring Certificate for Use by SSL" topic in Books Online (http://msdn2.microsoft.com/en-us/library/ms186362.aspx)

Jimmy

|||

Thanks Jimmy,

It's now working. I thought that was much more complicated than that to enable SSL on the HTTP endpoint.

Thx.

Bruce

How to enable SSL for HTTP endpoint?

Hi,

I'd like to know how can I setup the SSL so I can secure my HTTP Endpoint.

I saw in the documentation that some settings such as SSL_PORT and PORTS should be set to SSL port number and SSL but I did not find out anywhere where they explain how to enable SSL.

Do we enable SSL the same way we enable it or SQL Server 2005 or does that have to be done through the MMC - Certificates.

I don't have any IIS server running on this server, so I was wondering if IIS is a requirement to generate and import the certificate.

I appreciate your help and comments.

Bruce.

Bruce,

You can use the same SSL certificate as IIS if you like. Once the SSL certificate is setup for the IPAddressort combination, all you need is to configure the ENDPOINT to support SSL.

For additional information on how to configure a SSL certificate for use by the ENDPOINT, please refer to the "Configuring Certificate for Use by SSL" topic in Books Online (http://msdn2.microsoft.com/en-us/library/ms186362.aspx)

Jimmy

|||

Thanks Jimmy,

It's now working. I thought that was much more complicated than that to enable SSL on the HTTP endpoint.

Thx.

Bruce

How to download a file from a secure website

We need to download a file from a secure website using either DTS or Visual basic.Any idea??Q1 We need to download a file from a secure website using either DTS or Visual basic.Any idea??

A1 A suggestion would be to gather additional specifications (available from the website host?); generally that should constrain the possibilities somewhat and make different options easier to evaluate in relation to the local environment and local security requirements.

For example: (Is this a rare or one time event, or an hourly, daily, or weekly event? May one use / choose among vpn, ssl methods, etc.? How large a file is to be transferred and what is to be done with it?)|||use OpenURL method, it can do https

Inet1.URL = "https://www.mysecuredserver.com/myfile.txt"
bValidate() = Inet1.OpenURL(Inet1.URL, icByteArray)
Open "c:\myfile.txt" For Binary Access Write As #1
Put #1, , bValidate()

;-)
jiri