Locked out of admin on v2.2

This topic was automatically closed 365 days after the last reply. New replies are no longer allowed.
12 anni tempo fa
I am locked out of my admin account on v2.2.

I have tried a password recovery but get "The credentials provided are incorrect"

Is there a way to reset/manipulate the account in SQL. I have seen the post for other versions but not for v2.2
12 anni tempo fa
I have fixed it.

In SQL Express Management Studio open the database and the tables, right click on dbo.customer and select edit top 200 rows . I had somehow managed to delete the account so I just had to set the  "deleted" field to false.
12 anni tempo fa
I always have 3 Admin accounts (2 Emergency) in case you get the stiffie.

Using SQL MS just right click and edit the dbo.customer tables.

I entered a user name and replaced "NULL" I was able to get in.

My guess is that there a password lockout number of tries on SQL.

All this does it resets it so you can get in.

I'll have to dig deeper as to why lockouts occur frequently. Security problem?

Hope this helps

Mike
This topic was automatically closed 365 days after the last reply. New replies are no longer allowed.