AX Server problem

I am facing the following problem.

Object Server 01: Fatal SQL condition during login. Error message: “[Microsoft][SQL Native Client]Login timeout expired”
After this command AX get hang and misbehaves.

It is very difficult for working in AX.

Please guide me for this situation.

Hi,

The issue is - AOS server is not able to connect to SQL Server. Make sure the AOS service account has got required security privileges in SQL Server.

You can get details of security privileges from AX installation guide.

Check this link it might help you,

http://us.generation-nt.com/answer/login-failed-service-dynamics-server-02-fuji-test-help-204632931.html

This issue is coming on ON and OFF basis. I mean sometimes coming and sometimes working fine. Sometimes connection gets hang and we have to restart the AOS. We have noticed that when system gets hang then it gives the error like that connection with SQL server is already open with the credentials details like UserId, ODBC etc…

Hi Parag,

Have you managed to resolve the issue already?

I’m facing the same right now, such a headache!

Riksa