SQL State HYT00. Timeout expired proplem

(0) Share

Report

Posted on by ahmed barbary

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

I have the same question (0)

All responses (10)

Answers (1)

Paul Cunniffe 95 on at

Like (0)

Report

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)

Was this reply helpful? Yes No
ahmed barbary 4,548 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Paul Cunniffe 95 on at

Like (0)

Report

Re: SQL State HYT00. Timeout expired proplem

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

Was this reply helpful? Yes No
Paul Cunniffe 95 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
ahmed barbary 4,548 on at

Like (0)

Report

Re: SQL State HYT00. Timeout expired proplem

OK but i using sql authentication not windows authentication

Was this reply helpful? Yes No
Mohana Yadav 60,949 Super User 2025 Season 2 on at

Like (0)

Report

Re: SQL State HYT00. Timeout expired proplem

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

Was this reply helpful? Yes No
Verified answer

keoma 32,729 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: SQL State HYT00. Timeout expired proplem

Hello, Is it done or not?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: SQL State HYT00. Timeout expired proplem

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

Was this reply helpful? Yes No