Sage Intelligence Report Manager error: "[Microsoft] [ODBC SQL Server Driver][SQL Server]Login failed for user 'sa'.

Question

I have just Installed Sage 300 ERP 2018 on a Server running Windows Server 2012 and MS SQL Server 2014. But when I try to run reports for the live company in Report Manager I get the following error: "[Microsoft] [ODBC SQL Server Driver][SQL Server]Login failed for user 'sa'. 
 
 To try and resolve this, I only ran the workstation setup for Sage Intelligence and double checked my DSN ODBCs. 
 
 How can i fix this. Is there a patch i can run

Prof · Answer

Hi Isaac, 
 I trust you're well. 
 You could try manually entering the connection details in the connector to directly access the SQL server from the workstation. It could be the autoconnect acting up on the workstation side of things. 
 If you still have an issue I'd suggest contacting your support team to assist.

Sage 300

Sage Intelligence Report Manager error: "[Microsoft] [ODBC SQL Server Driver][SQL Server]Login failed for user 'sa'.

Top Replies

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING