Only from one workstation getting this error message "Cannot access database (error=49153)". ERP Database setup is server not ODBC. All other machines are connecting without any issue. Only one system is giving this error. And this system has Sage Peachtree installed in it. Is it because of this?
Check that the correct SQL driver is installed.
Do I have to install MS SQL Native Client on that particular workstation?
If that's the correct version, you didn't say which one you're running.
In Server I have MS SQL 2012 version and Sage 300 ERP 2014. Server OS MS Windows 2012 64 bit.
Then you need Native Client. And make sure the firewall is turned off on the PC. 49153 means the client can't see the server.
© 2016 The Sage Group plc, its licensors or its affiliated companies. Sage, Sage logos, and Sage product and service names mentioned herein are the trademarks of The Sage Group plc, its licensors, or its affiliated companies. All other trademarks are the property of their respective owners. For more information, visit www.sage.com.
Community Terms of Service | Community Guidelines | General Data Protection Regulation (GDPR) | Community Help