|
I forgot my admin login and password and now I cannot login to the administrator interface. Can I get back into my site without erasing my whole database?
|
|
|
Yes, your administrator account login can be reset as long as you have access to the database (either the MDB file or the SQL Server database). To reset the login, you will need to run a SQL Query against your database. If you do not know how to run a query on your database, you should consult the assistance of an experienced Database Administrator (DBA), or contact XCENT support. Warning: Do not try this if you are unsure of what you are doing. Running queries directly against your database can permanently erase data from your database, so you must be absolutely sure of what you are doing.
This will work for all XCENT web server applications version 2.x or later. Once the query is run on the database, the password for the account will be reset to nothing (no password). You should login and set the password to something you can remember right away.
The query below will reset the password if the administrator login was left as "admin". If the login name was changed and you recall what that is, change the text "admin" to the name you used.
UPDATE tblXUDAdmin SET admPHash=0 WHERE admLogin='admin'
If you did change the login name for the administrator account and cannot recall what it is, or if the above query does not seem to work, then you may need to run the two queries shown below to reset the administrator login.
DELETE from tblXUDAdmin
INSERT INTO tblXUDAdmin (admLogin, admPHash) VALUES ('admin',0)
If you have a JET database, you can also open the MDB file in MS Access, open the table tblXUDAdmin, and change the hash code in the admPHash column to 0 (zero). If you have a SQL Server database, you can use SQL Enterprise Manager to do the same.
|
