How do I change SA password for Everest 4?

[jaromewi...@gmail.com]

Have an old system I need to migrate. Don't have the SA password for SQL 2000. If I change it, Everest breaks. How do I change the sa password in the Everest to the new password of the SQL?

[Info Akute]

Hi,

Hope below may help you to change password

https://blog.sqlauthority.com/2009/08/04/sql-server-forgot-the-password-of-username-sa/

Best Regards,

AKUte Team

Open ticket for quick tracking http://www.akutesoft.com/support/open.php

in...@akutesoft.com | www.akutesoft.com | Skype -  info.akute

On Thu, Dec 20, 2018 at 11:07 AM <jaromewi...@gmail.com> wrote:

Have an old system I need to migrate. Don't have the SA password for SQL 2000. If I change it, Everest breaks. How do I change the sa password in the Everest to the new password of the SQL?

--
--
Email sent to Google Groups: "Everest (Icode/Versata) ERP Users Group" group.
 
- Post: evere...@googlegroups.com
- Unsubscribe: everest-erp...@googlegroups.com
- More options: http://groups.google.com/group/everest-erp?hl=en
---
You received this message because you are subscribed to the Google Groups "Everest (Icode/Versata) ERP Users Group" group.
To unsubscribe from this group and stop receiving emails from it, send an email to everest-erp...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[Info Akute]

Hi William,

To change SA password on the Everest follow this. Go to Everest installation folder (D:\Program Files (x86)\Icode\Everest\Client\Utilities) change drive as per your location.

See ChangeLoginPassword.exe and run this and you can change password.

That's it .. If you still need any assistance please let me know

John

Best Regards,

AKUte Team

Open ticket for quick tracking http://www.akutesoft.com/support/open.php

in...@akutesoft.com | www.akutesoft.com | Skype -  info.akute

[Info Akute]

Attaching screenshot.

John

Best Regards,

AKUte Team

Open ticket for quick tracking http://www.akutesoft.com/support/open.php

in...@akutesoft.com | www.akutesoft.com | Skype -  info.akute

[jarel nomeh]

That worked. Thank you! However, now that I've restored the company to the new server, I cannot log into it. The migration process finished successfully. I can see the database mdf file in the data folder of Everest. But it's only giving me option to log into the sample company.

Can't find anything in the help file for this issue. 

[MARTEC360]

You are missing an entry for your company in the COMPANIES table of the EVEREST_SYSTEM database. 

The company name must exactly match your registered company name / the value in the company name field of the division field. 

The company code in the in the COMPANIES table must match the company code in the division table. 

The database name should be the name of your SQL database name in SQL "EVEREST_COMPANYNAME" vs "EVEREST_SAMPLE" for the ASC database. 

If you need any additional help, let us know. 

Happy Holidays from MARTEC360 

Regards // A

[Info Akute]

Since you have restored it on the new server. My way to work on this is to create a new company after login to sample company with your live company information (hope you have saved that info) trade name , Legal name and company code is more important and once you created company followed by company setup wizard you will have balance company and now you can restore your database using either SQL management or via dB migration utility.
Hope this will save your time and if you still need help let me know.

John

Sent from iPhone
John

[jaromewi...@gmail.com]

Thank you for your help. I've done as instructed. But this is what I get when I try to log in now

[jaromewi...@gmail.com]

Got it! My SQL query was wrong. NULL != 'NULL'

[Info Akute]

Hope Everest login is working?

Best Regards,

AKUte Team

Open ticket for quick tracking http://www.akutesoft.com/support/open.php

in...@akutesoft.com | www.akutesoft.com | Skype -  info.akute

[jaromewi...@gmail.com]

Yup, it works now.