0

I need to automate reset password of database application role. Password must be encrypted or hash form due to security reason.

I tried to convert password into hashbytes form and reset application role password but didn't work.

SELECT  HASHBYTES('SHA2_256','PASSWORD')
GO
USE <DATABASE NAME>
GO
ALTER APPLICATION ROLE [approle_name] WITH PASSWORD= 'password hash value'
GO

Can someone kindly help how can reset the password of application role with hash value or encryption form?

Thanks in Advance

SQLHoncho
  • 27
  • 6

0 Answers0