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.
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.
- If the above test failed, then in a Windows Command Prompt (cmd.exe) ping the server name to test address resolution and connectivity.
- If the ping test is not successful, try using the IP address directly for the ping.
- 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.
- 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.