Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics NAV (Archived)

SQL State HYT00. Timeout expired proplem

(0) ShareShare
ReportReport
Posted on by 4,548

Hi guys when i open dynamic nav 2009r2 this error show to me " the following odbc error occurred error [Microsoft ][odbc sql server driver] timeout expired state id hyt00

why and how i solve

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: SQL State HYT00. Timeout expired proplem

    In the "Server" insert sql server name with instance: exampleserver\exampleinstance

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: SQL State HYT00. Timeout expired proplem

    Hello, Is it done or not?

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: SQL State HYT00. Timeout expired proplem

    Please check the port with command netstat -a 

    Your named instance is probably not listening on port 1433.  By default named instances listen on a "random" port and the SQL Browser Service is used to resolve the instance name to its current port.

    So first try removing the Port= specification.  Also you can select a fixed port for your named instance using SQL Server Configuration Manager. 

  • Verified answer
    keoma Profile Picture
    keoma 32,675 on at
    RE: SQL State HYT00. Timeout expired proplem

    today i had the same error.

    the reason was a vpn client using the same port(s) as nav 2009. i deactivated the vpn client (checkpoint) and all was ok again.

  • Mohana Yadav Profile Picture
    Mohana Yadav 59,194 Super User 2024 Season 2 on at
    Re: SQL State HYT00. Timeout expired proplem

    You can try by adding Server IP Address in host file of Client and try..

  • ahmed barbary Profile Picture
    ahmed barbary 4,548 on at
    Re: SQL State HYT00. Timeout expired proplem

    OK but i using sql authentication not windows authentication

  • Paul Cunniffe Profile Picture
    Paul Cunniffe 95 on at
    Re: SQL State HYT00. Timeout expired proplem

    Another suggestion is to delete all instances of the account from SQL, and delete the NAV account. Then recreate the NAV account and re add the permissions and then syncronise the single login. We had a similar issue when users were renamed in Active Directory.

  • Paul Cunniffe Profile Picture
    Paul Cunniffe 95 on at
    Re: SQL State HYT00. Timeout expired proplem

    User dsn, add, SQL server. Accept the defaults.

  • ahmed barbary Profile Picture
    ahmed barbary 4,548 on at
    Re: SQL State HYT00. Timeout expired proplem

    OK good but create odbc datasource from system dsn or user dsn or file dsn please can you tell me answer by detailes if possible

    thanks

  • Paul Cunniffe Profile Picture
    Paul Cunniffe 95 on at
    Re: SQL State HYT00. Timeout expired proplem

    We had the same issue - I managed to fix by adding a SQL Server ODBC data source on the local machine. Could be a local permissions issue - but adding the ODBC data source fixed it for us.  (ODBC data source, add, SQL Server, type in a name, description, select the server, and keep clicking next and finish)

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,391 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,445 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans