SQL 2012 password hash
#1
Please include the SQL 2012 password hash; it's identical to 2005, except
0x0200 as an ID instead of 0x0100
SHA-512 instead of SHA1

i.e. a sanitized test version run on SQL Server itself shows the same "convert to unicode, covert that to binary, append the salt to the end, then hash it once and only once and prepend the identifier" algorithm.

-- SQL Server 2012
select pwdencrypt('password')
-- 0x0200^^^^^^^^********************************************************************************************************************************
-- salt hash
select HASHBYTES('SHA2_512', CONVERT(VARBINARY,N'password') + CAST(0x^^^^^^^^ AS VARBINARY(32)))
select HASHBYTES('SHA2_512', CONVERT(VARBINARY,N'password') + CAST(0x^^^^^^^^ AS VARBINARY(32)))


Messages In This Thread
SQL 2012 password hash - by Incisive - 08-17-2012, 11:45 PM
RE: SQL 2012 password hash - by atom - 08-17-2012, 11:48 PM
RE: SQL 2012 password hash - by radix - 08-18-2012, 04:43 PM
RE: SQL 2012 password hash - by Incisive - 08-20-2012, 05:05 PM
RE: SQL 2012 password hash - by radix - 08-21-2012, 11:22 AM
RE: SQL 2012 password hash - by Incisive - 08-21-2012, 11:46 PM
RE: SQL 2012 password hash - by halfie - 08-21-2012, 05:35 PM
RE: SQL 2012 password hash - by atom - 08-21-2012, 08:32 PM
RE: SQL 2012 password hash - by atom - 08-22-2012, 09:48 AM
RE: SQL 2012 password hash - by glugingb - 11-09-2012, 12:09 PM
RE: SQL 2012 password hash - by M@LIK - 11-09-2012, 04:48 PM
RE: SQL 2012 password hash - by glugingb - 11-11-2012, 10:29 AM