Error ODBC SQL Server Driver - Login failed

From Sage Intelligence Knowledgebase
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.