Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / SQL Server Connectivit...
Finance | Project Operations, Human Resources, ...
Suggested answer

SQL Server Connectivity Issue: Connection not open. Login timeout expired

(0) ShareShare
ReportReport
Posted on by M Anas Khan 1,424

Hi Community!

I am investigating performance issues with a Dynamics AX 2012 instance and getting the following errors in Event Viewer on the AOS server. Ping to DB server is running fine. However, the client freezes over and over again. Has anyone else faced this issue ever and how can it be resolved?

Kernel version: 6.2.2000.14
Application version: 6.2.1000.1437

8713.Event-viewer.png

Object Server 05:  The database reported (session 24 (erosanaw)): [Microsoft][ODBC Driver Manager] Connection not open.

Object Server 05:  SQL diagnostics: [Microsoft][SQL Server Native Client 10.0]Login timeout expired. 

Object Server 05:  Fatal SQL condition during login. Error message: "[Microsoft][SQL Server Native Client 10.0]Login timeout expired" 

Object Server 05:  SQL diagnostics: [Microsoft][SQL Server Native Client 10.0]Login timeout expired. 

Object Server 05:  Fatal SQL condition during login. Error message: "[Microsoft][SQL Server Native Client 10.0]Login timeout expired" 

Object Server 05:  The database reported (session 4 (oarowolo)): [Microsoft][ODBC Driver Manager] Connection not open.

  • M Anas Khan Profile Picture
    M Anas Khan 1,424 on at
    RE: SQL Server Connectivity Issue: Connection not open. Login timeout expired

    IT was restarting the SQL service without communicating! Please disregard this issue.

  • Suggested answer
    Gunjan Bhattachayya Profile Picture
    Gunjan Bhattachayya 35,421 on at
    RE: SQL Server Connectivity Issue: Connection not open. Login timeout expired

    Hi Muhammad,

    Could you please check the following?

    1. Is the SQL Browser service running?

    pastedimage1599552385648v1.png

    2. Go to SQL server configuration manager and check if protocol TCP/IP is enabled as shown -

    pastedimage1599552467279v2.png

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 293,278 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 232,011 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156 Moderator

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans