Sage 300 ERP Database Error 49153

Start Sage Database Setup & the Company and System Database Profiles. Verify what Data Source or Server name, Login ID and Database names are set. Open the 32-bit version of ODBC Data Source Administrator, either from Control Panel > Administrative Tools > Data Sources (ODBC), or from C:\Windows\SysWOW64\odbcad32.exe on 64-bit PCs.

sage 300 erp error code 49153

On the System DSNs tab find the Data Source name or Server name (if Server name is used a 32 is appended to it).

Confirm the name of the SQL server in the DSN entry. Enter the User ID and password in the SQL Authentication, and confirm that the remaining settings are left as default.

Test the database connectivity from the DSN.

    1. If the above test failed, then in a Windows Command Prompt (cmd.exe) ping the server name to test address resolution and connectivity.
    2. If the ping test is not successful, try using the IP address directly for the ping.
    3. If successful, enter the IP address in the DSN entry and test the database connectivity again.If the database connectivity is not successful with the IP address:
      • The User ID being used may not have permission to access the SQL Server.
      • The SQL Server may not be prepared to service the connection.
    4. If none of the above tests are successful, then continue troubleshooting using the article KB 33287:
      Sage 300 Error: “Cannot access database Error=49153” with a newly installed server to further test the SQL Server.

Fix Sage 300 Error Code 49153 [Easy Steps]

fixfaster
User Query: I am getting error message when trying to open my Sage 300 ERP “Cannot access database (error=49153). Answer: This is due to the network connection error with your database when you are trying to access in to Sage 300 ERP company files. Read This: Sage Could Not Start the Database Engine Error - How to Fix? What does Sage 300 Database Error 49153 Mean? Whenever a user tries...
Read More

Fastfix247.com Disclaimer

We don’t represent the brands & products as shown on the website, we’re 3rd party company and do not have any direct connection. (1) | (2) | (3) | (4) | (5) | (6) | (7) | (8)

DMCA.com Protection Status