We keep get an user error for SQL credentials whenever we click on parameters. For example choosing period will pop up an error. Error screenshot is attached for reference.
Please try below link and let me know: http://kb.sageintelligence.com/index.php?title=SQL_Login_failed_for...
Unfortunately it didn't work for us. Do you have any other solution or suggestion?
I have error pic I have attached again.
C:\Program Files (x86)\Sage\Sage 300 ERP\BX62A
and got to Report manager and run and this will create a new file for you.
If the error still persists, please change the SQL Server password, you can set a test password, example Test123 and this should defiantly resolve your problem.
If this doesn’t resolve the issue, I would suggest longing into the connector and use manual connection instead of auto connect.
Please let me know if this does help.
if you having an issue after trying an above and you need father assistance please contact our support Team and they will be able to remote in and assist you further.