Facing Problem while connection Remote Sqlserver DB with Dynamic AX Client using ODBC

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

Hi Vasanth,

How you are creating this connection?

If you are doing this through class, check ‘RunOn’ property. If it is not already, try setting RunOn property to server.

Regards,