Re: How to hash of the password string for query?

Frediano Ziglio <[email protected]> Fri, 16 Jan 2015 09:52:06 +0000

Newsgroups	gmane.comp.db.tds.freetds
Message-ID	<CAHt6W4dwV=gaP7zvHam87rJHBvwj4u1-r13bVM=qau=d3T=THw@mail.gmail.com>

2015-01-16 7:12 GMT+00:00 Velichko Yuriy <[email protected]>:
> Hello! Sorry if this question is offtop in this list, but I hope that you
> can help me.
>
> I use freetds to communicate with SQL Server.
> To create a server login I should to use query
>
> CREATE LOGIN ... PASSWORD hashed_password HASHED
>
> Advise me, please, how should I get the hashed_password properly? May be
> there is a particular function in freetds for this purpose?
>
> Thanks!

Hi,
  you have to use the server. See
https://social.msdn.microsoft.com/Forums/sqlserver/en-US/f15a1ee1-e1df-4b51-987d-c1b094f2e71e/request-actual-example-of-create-login-with-password-hashed?forum=sqlsecurity.

Regards,
  Frediano