Admin password reset MS SQL

so I just moved to sql db, imported my users and now I can not ogin to the admin console.

I have tried rerunning setup and it allows me to go all the way through, I put in admin password and then new password and it says ok, but then it takes me to admin console and I can not login.

I have tried setting password in sql table but that doesn’t help.

the last thing I did during configuration before I restarted openfire was change the name from 127.0.0.1 to imserv

nvrmnd, I just trashed it and started over.