<div class="Section1"><p class="MsoNormal">I have a database that has a “process” user. I need to move the database to
anadditional server. When I restore it gave me a “user not found” error. So I am trying to recreate this user, but no
oneknows what the password is supposed to be. The processes connecting to it have encrypted versions of the password.
Andwhat I can find in the database uses md5. Is there some way to find out or copy over the users password? Trying to
findevery process that uses this login will be very time consuming and we are guaranteed to miss some and generate a
lotof frustration and confusion as processes that always worked cease. Not to mention that some stuff may be failing
fora while before someone catches it.<p class="MsoNormal"> <p class="MsoNormal">I was thinking of just taking the md5
frompg_authid:rolpassword and using it to update the new server. Will this work? Or is there another way to retrieve a
forgottenpassword?<p class="MsoNormal"> <p class="MsoNormal">Edward W. Rouse<p class="MsoNormal">Comsquared System,
Inc.<pclass="MsoNormal">770-734-5301<p class="MsoNormal"> </div>
