Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Kazz
Starting Member
2 Posts |
 Posted - 2014-07-14 : 11:10:41
|
| Hi,I am trying to create a SQL script which automatically creates user log on details for an application system which is attached to SQL. Specifically the password and salt hash.I have tried the likes of hashbytes with md5, sha etc but the generated hash is not in the same format of which the SQL saves the password/ salt. The format used is as follows:Password format: nlN7vSWhP9X1/HYCtL9YwInMhgbuVuCgo3hPQ5vOv+0=Salt format: 1prLdWlbS5WelxPA |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2014-07-14 : 11:47:13
|
Password format is MIME format.
Microsoft SQL Server MVP, MCT, MCSE, MCSA, MCP, MCITP, MCTS, MCDBA |
 |
|
|
Kazz
Starting Member
2 Posts |
Posted - 2014-07-15 : 04:36:54
|
| If the password is in MIME format, is it possible to hash a password field in this format on SQL. |
|
|
|
|
|
|
SQL Password and Salt hash creation