Issue Resolution:

Steps taken:

  1. Logged in as Windows User with local and domain admin rights, removed Workstation setup via My Computer > Uninstall or change a program
  2. Created and successfully tested a new ODBC DSN using native client 10.
    • If you are using a 64-bit Windows system, the default ODBC Data Source Administrator (available from the Administrative Tools menu) lets you configure only 64-bit data sources.
    • However, Sage 300 ERP is a 32-bit application. To create data sources for Sage 300 ERP, you need to browse for the 32-bit version of the ODBC Administrator. You can find the 32-bit ODBC Administrator in the following location:
    • C:WINDOWSSysWOW64odbcad32.exe
  3. Disabled the Anti-virus/ Firewall.
  4. Re-installed Workstation setup via the WSSetup folder within the Program data folder for Sage 300 ERP on the Server. Ran the setup.exe
  5. Once installed, viewed Database Setup and ensured / edited all databases to use the created datasource connection.
  6. Successfully accessed Sage 300 ERP both as admin and as the user.

 

Resolution for Issue '“Cannot access database Error=49153”' available: Yes (Solved).
Source: Sage Community forums.
Disclaimer: Accounting File Repair Support is an independant provider of database-related services and is not affiliated with Sage or Intuit.

“Cannot access database Error=49153”: this issue or error code is a known issue related to Sage accounting products. Support for this issue is available either by self-service or paid support options. Experts are available to resolve your Sage issue to ensure minimal downtime and continue running your business. First try to resolve the issue yourself by looking for a resolution described below. If you are experiencing too many issues, you may want to convert from Sage 50 to Quickbooks. See also: do a conversion from Sage 50 Quantum to Sage 50 Pro/Premium or convert Sage. If it is a complex issue or you are unable to solve the issue, you may contact us by contacting Sage Repair or by using other support options.

Ad:
Support for Computer
Sage Repair will resolve it efficiently and affordably. Guaranteed resolution of your issue, or you pay nothing!

Additional Support Options: