How do I reset the admin password for myQA 2022-001?

Question:

How do I reset the admin password for myQA 2022-001?

Answer:

Step 1

Run Microsoft SQL Server Management Studio, log in the to server you want to query

Step 2

Click New Query

Step 3

Use below codes:

UPDATE [SEC_User]

SET [HashedPassword]=N'BD9CE404927104BCAA84939876A83D77E125B705',

[Salt]=CONVERT(VARBINARY(MAX), '0xDFCB1DECF1F4AD44C02D7175FEBC25FDD033E22AE348AEB5', 1)

WHERE [Name]=N'admin'