How to recover username and password of Nav database.

Nav_il

Hi All

I have a customer who have an older DB which they have forget the username and password of. The problem is now they have to get access to the DB, what can they do?? I really don't know how to help them, especially not since it's a new client and we don't have any super username to the DB.

Does anyone know how we can help them?

THANKS.

lvanvugt

Is the DB on SQL Server?

Nav_il

It is classic and Native database, not sql.

lvanvugt

Ouch, that's long time ago. Don't know the tricks there anymore.

Nav_il

Thanks lvanvugt for your intention to help. It looks like it is impossible to solve. Does any other person remember having this issue and remembers how to solve it? Any other idea.

bbrown

I believe they are basically out of luck if they cannot recall the login information. Back several versions ago, you could send the database to the vendor (pre Microsoft days) and they would unlock it for you. For a fee of course. However that ability was discontinued as it was considered a security hole.

The only option I can see would be if they have a backup (FBK) available. You could try to restore it to SQL. Provided it does not encounter any data errors that cause the restore to fail. Which, by the way, is highly unlikely to succeed. If it is successful, you'd then have access to the security tables via SSMS.

mdPartnerNL

if they have obsolete windows users (with super right) in the db, there is an option to emulate those login by hacking the OS.

Nav_il

Thank you bbrown and mdPartnerNL. I am afraid, they don't have any backup as that was the first thing i asked them for. mdPartnerNL, their login is database authentication not windows, so they don't have such chance.

Albertvh

Hi,
Try putting ? , I think 20, to fill the user id field it should come back with a number - you must then contact MS and ask them for the unlock code.
Don't know if this still works.

bbrown

Albertvh wrote:

Hi,
Try putting ? , I think 20, to fill the user id field it should come back with a number - you must then contact MS and ask them for the unlock code.
Don't know if this still works.

That "feature" has not been available for quite sometime. I want to say since like version 4, but not totally sure on the timing.