Microsoft Dynamics RMS (Archived)

removal of id and password

(0) Share

Report

Posted on by Community Member

Hello

I tried to log in with ID and Password when i opened store last week.

but I couldn't log in at all. I log in previous day without any problem.

and I finally knew that all ID and Password was gone away. nothing ID and Password.

Is there anybody who experienced this kind of problem?

I'm not sure but I think it can be kind of virus or system problem.

In short, all ID and Password was removed automatically.

Could you let me know what situation it is?

Best regards,

Peter

*This post is locked for comments

I have the same question (0)

All responses (6)

Answers (0)

simon@rsg on at

Like (0)

Report

Hi Peter

This is unusual as RMS will not let you delete yourself as the logged in cashier so it is difficult to remove all cashiers via the UI.

Have you tried to log on using the default credentials user ID = 1 and password = Password (note the capital P in the password)?

Cheers

Simon

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

I tried with ID=1 password=Password

but it didn't work at all. T..T

Was this reply helpful? Yes No
simon@rsg on at

Like (0)

Report

Hi Peter

Okay in that case you need to see which cashiers RMS knows about. Launch SO Admin and connect to your database. Select New - Query and then type

SELECT * FROM CASHIER

This will list all the cashiers, this should help prompt you which cashiers you have available to log in with.

Thanks

Simon

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

I tried like above. but nothing is in there.

No ID and No Password at all. I do not know why?

It can be happened sometimes?

You think somebody interrupt me?

I mean somebody access my server and delete all of them? is there any other way that this kind of thing can be happened?

Anyway I copied some ID and Password from other DB that i used before and pasted those to current DB. so i recover register somewhat. but it is deleted again completely after one day!

Was this reply helpful? Yes No
Suggested answer

Antonijo Todorovik 4,025 on at

Like (0)

Report

Hi Peter.

This is very strange, as the Cashiers (or other records in the RMS tables) can't be deleted just like that. There must be something or someone deleting the records from the database.

I would suggest this next (depending on what version of SQL you are using): repeat the process of copy an user (ID and password) from another DB and create an SQL Server Profiler Trace over that particular db and/or table "Cashier" (You can use the standard SQL Server Profiler, I'm also using the AnkLab.SqlProfiler). The next time you notice that this happens again, stop the Profiler trace and filter it down to find out who is deleting the cashier records. Please remember not to close the profiler trace, not to stop it, not to turn off the PC and similar...

Hope this helps.

Kind regards, A.

Was this reply helpful? Yes No
Suggested answer

Jeff @ Check Point ... 13,382 on at

Like (0)

Report

Could be lots of things.

virus

SQL injection

bad spot/block on hard drive

bad index within SQL

one cannot delete all cashiers from within the program, but can with a SQL script

Was this reply helpful? Yes No