Facing Problems while connect Axapta Client with SQL Server DB

(0) Share

Report

Posted on by Vasanth Arivali

Hi,

I connect sql server db(not a default one it is a another db) from Dynamics Axapta 2009.
I used odbc to connect and retrive data.

It was work fine in the server.
but when i was woked in ax client it show an error like this:

1) ODBC operation failed.Unable to log on to the database.

2) [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'ASCENDERS\vasanth'.

3)Object 'OdbcConnection' could not be created

i am also given the user name as sqlserver username "sa" but it take my window authentication.
i don't know how to solve the problem.plz help me with your valuable ideas..

Thanks in advance

Vasanth.A