Lost sysprogress password

M3Fan

New Member
I've "inherited" a Progress 9.1d server for which I do not have the sysprogress password. This is a problem since I can't connect via ODBC until I have this password to either log on as sysprogress or grant rights to another user for ODBC access. I can log on using another user account and see the tables via ODBC (Using MS Access) but I can't open any of the tables without this password. Can I re-create the sysprogress user or do some manual password reset? The password is definately not blank.
 

jeremysimmons

New Member
Sorry to reopen a thread, but I read this and disappointingly didn't find a reply.

I ended up using this quick&dirty .p to fix my issue.

FIND FIRST _user WHERE _userid = "SYSPROGRESS" NO-ERROR.
DELETE _user.
CREATE _user.
ASSIGN
_user._userid = "SYSPROGRESS"
_user._Password = ENCODE("").
 

tamhas

ProgressTalk.com Sponsor
Francoist answer was a reply and is the way to do the same thing without writing any code. In both cases you have to have permission, so don't lose all your passwords!
 
Top