Change in SQL functionality between 7 and 2k

From: James (James_at_south.africa)
Date: 09/26/03 

Date: Fri, 26 Sep 2003 11:48:06 -0700

Hi,

Does anyone know why MS changed the way that the ENCRYPT
('message') function works? I am in the process of
replacing an old authentication method which uses this
function because it works differently between SQL 7 and 2K.

Here's an example: on my computer I have SQL 7 running
alongside a SQL 2K instance. I execute exactly the same
statement against both instances. SELECT CONVERT(VARCHAR
(20), encrypt('mysecret'))

In SQL 7 I get what I expect: bSLL’v4
In SQL 2K I get a unicode translation in clear text:
mysecret or something similar.

I have found no info about this in technet or in the
product info for 2000. I am in the process of replacing it
with more secure methods (if I can get the rest of my
company on-board) but I still want to know what changed
and why the chage wasn't documented.

Relevant Pages

  • Change in SQL functionality between 7 and 2k
    ... replacing an old authentication method which uses this ... function because it works differently between SQL 7 and 2K. ... product info for 2000. ... I am in the process of replacing it ...
    (microsoft.public.sqlserver.security)
  • Re: Migrating Clusters
    ... Uninstall SQL from the "other" node, evict the node, ... needs replacing. ... We have a new cluster ready and waiting in our data centre that is ... · Configuring all the applications to the new Cluster Name / IP ...
    (microsoft.public.sqlserver.clustering)
  • Re: Change in SQL functionality between 7 and 2k
    ... Thanks Dan, ... >> with more secure methods (if I can get the rest of my ... >SQL FAQ links: ... >replacing an old authentication method which uses this ...
    (microsoft.public.sqlserver.security)
  • RE: I can only connect via Windows Auth - WHY?
    ... Did you recently changed the Authentication method used by SQL? ... Did you restart MSSQLServer? ... This posting is provided AS IS with no warranties, and confers no rights. ...
    (microsoft.public.sqlserver.security)
  • SQL 2000 restore
    ... I'm replacing the drives on our server that has SQL 2000 on it running on ... The current setup resides on a RAID 5 backplane. ...
    (microsoft.public.sqlserver.setup)