How to find forgotten admin password

Version 4
1

Hi Everyone Good Day;

How to find out forgotten admin password
I am using sql server 2012 database…pls help

2

Connect to the SQL Database using MS SQL Management Studio (or similar)…

SELECT PinCode FROM Users WHERE Name = 'Administrator'

That will give you the PIN

(This works for V5… Not sure if it will work for V4… perhaps some table names, columns or values might be a little different, but this should get you close).

2 Likes
3

Thanks for reply…I checked the above u mentioned but i couldn’t.

4

If nothing else you could just use SQL Manager to brows the database and view to users table.

5

You couldn’t what?

Connect to the DB?
What tables are in the V4 DB, is there anything that looks like a “Users” table?

6

Connected to DB…I did expand the odb.users

7

What do you mean, “expanded”

You either need to write a SELECT query in a new query window, or right-click and use the built-in select 1000…

image

2 Likes
8

Yer, right click and select ‘Select Top 1000’

2 Likes
9

Well ; got it …Thanks alot

1 Like
10

Can you click solution on my reply instead of yours?