Hi,
I am doing a server move for a client. We installed the same version of Sage 300 (V2012) on the new server with Intelligence. We then ran the intelligence workstation setup and moved over the applicable files (templates, etc). When we try and check test the Sage Accpac Auto connect connector, it gives us a login error for the SQL user. Both the ODBC that is setup and the database setup for Sage work just fine with that user. Not to mention we are using the auto connect settings. We have already checked the SQL instance name in the ODBC and the regions on both the Accpac server and the SQL server. Any ideas as to what it could be?
Error:
---------------------------
Sage 300 ERP Intelligence Reporting : An Unexpected Error Occurred
---------------------------
Error Number : [-2147217843]
Description : [[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'sage'.]
Source : [Microsoft OLE DB Provider for ODBC Drivers]
---------------------------
OK
---------------------------