Hi Keshen 

Please try the following steps and advise me on the outcome:

1. Open MS SQL Management Studio
2. Access and open the ResolveWEB database that gets created and is used by Resolve WEB
3. Run the following SQL script on it:

            Update TAdministrator

            Set password = ‘xxx’ where loginname = ‘Admin’         (XXX indicates the new password value)

        4. Note that the password field must have a value, and can’t be blank

Kind regards

Bennie 

Hi Bennie,

Unfortunately the reset of the password didn't work as we thought it would and now I am back to square one. The answer you gave is for ResolveWeb and didn't work on the Business Gateway unfortunately. What I did do was delete the Admin user form the dbo.tUser table in the "Gateway" database and then went into the IIS manager and created a new Admin user. This seems to be working for now. Thanks for the help.  

Hi Bennie,

Unfortunately the reset of the password didn't work as we thought it would and now I am back to square one. The answer you gave is for ResolveWeb and didn't work on the Business Gateway unfortunately. What I did do was delete the Admin user form the dbo.tUser table in the "Gateway" database and then went into the IIS manager and created a new Admin user. This seems to be working for now. Thanks for the help.  

Thanks Keshen! And so we learn something new everyday. 

I'll add your solution to our own Knowledge Base so that the next client asking the same will have a quick solution from us :)

Kind Regards

Bennie