Error ODBC SQL Server Driver - Login failed

From Sage Intelligence Knowledgebase
Revision as of 05:12, 31 January 2017 by Nichola.Soobramoney (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

Products

Sage 300

Description

Error: "[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'sa'"

Cause

Sage Intelligence Auto Connect Server adds 32 at the end of the server name, as the BICORE.exe is 32bit executable.

32.png
321.png

Resolution

Ensure that the correct server name is used.