After upgrading sage from 2021 to 2023 I got error Error HRESULT E_FAIL has been returned from a call to a COM component on accessing web screen.
What would be the reason of this and solution ?
Hi Stacey,
it turns out the problem related to DB connection.
run a RVSpy, and get this error.
Then I found this link that mention the "New implementations and prior version upgrades of Sage 300 may require different database configurations as overall security has been enhanced"
https://support.na.sage.com/selfservice/viewContent.do?externalId=116170&sliceId=1
Previously I direct connect to SQL Server using Server name and SQL Credential.
So I create an ODBC connection, with "ODBC Driver 18 for SQL Server", turn on the "Trust Server Certificate" option under System DSN configuration. select "Optional" on Connection Encryption, and I am able to login web screen.
