Welcome!

This community is for professionals and enthusiasts of our products and services.
Share and discuss the best content and new marketing ideas, build your professional profile and become a better marketer together.

Hide Intro Register
You need to be registered to interact with the community.
Posts People Badges
Tags View all
Software Hardware
About this forum
This question has been flagged
4 Views
Avatar
Jivendra Singh
  1. Open SSMS (SQL Server Management Studio) and log in using an account with super admin privileges.
  2. Once logged in, select the HRVIEW database and click on New Query.
  3. Write the following query to search for the user: “SELECT * FROM employeeprofile WHERE EmpID = '1'” (Replace '1' with the locked user's EmpID[userID].)
  4. Execute the query to view the results. Locate the user and check the column named LockAccount.
  5. Run the following query to update the LockAccount date and time: “update employeeprofile set LockAccount='2025-03-17 00:00:00' where EmpID='1'”

(Replace '2025-03-17 00:00:00' with the current date and time, and '1' with the locked user's EmpID[userID].)

  1. Execute the query. Upon successful execution, the user can try logging in to the webpage.

Note: You are working on a live database. Double-check all changes before executing any queries

Avatar
Discard