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.