How to Resolve Error "Login Failed for User .." When Trying to Run Sage 300 Intellgence Report

Less than one minute read time.

The following error message may occur when running a Sage 300 Intelligence Report : 

[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'sa'. 

Viewing the Tenant Cache you can see that the DB Pswd field is blank:

To resolve this message, you will need a Connector Module entitlement.

Launch the Sage Intelligence Connector 

Select the Sage Accpac (Auto Connect) connection.

Uncheck the "Use Auto Connection System" checkbox and click the Apply Button

Enter the following:




Password <enter your SQL password>

then click Apply

Click the Check/Test button to ensure the connection succeeds.

If necessary - repeat the same steps for the Sage Accpac Consolidation connection

Close the Connector.

You will now be able to run any report in Report Manager.

<NOTE: if you do not have a Connector license, please contact Customer Support and we can have a temporary Connector License created with an expiry date of 30 days>