Login failed: make sure your username and password are correct and that you're an admin or moderator

Hi,

I am using Centos 6.6 with Openfire 3.9.3 using MSSQL Database .

we are using test database which is synced with live SQL database. during installation we skip the admin password step because we are already using Live database where admin password is already set.

Now I am getting error to login in to Admin Console with admin user. Many things i tried from sql data base like, changed the password in to Offuser table in plain text , but no luck.

still i am getting “Login failed: make sure your username and password are correct and that you’re an admin or moderator”

**Can anyone please help on this. **

Thanks

pramod

pramod.ratnakar@continuum.net