[Microsoft][ODBC SQL Server Driver]State ID: HYT00

I don’t know about you, but I have a lot of problems on my local computer to have Navision connect to a SQL2005 with Windows Authentication when my computer is not in the domain. It takes a lot of time for the login and in the end I generally an error : —————————
 Microsoft Dynamics NAV
 —————————
 The following ODBC error occurred:
 
Error: [Microsoft][ODBC SQL Server Driver]Timeout expired
 State ID: HYT00
 
—————————
 OK
 —————————
 
I finally found a method to avoid it!
 
Instead of using the name, I use 127.0.0.1 to connect. And after a few seconds I am in Navision!
 
This method works (at least for me) in case you have a default installation (not a named instance). I don’t know what to do in case of named instances.
 
I think it is worth to check the “SQL Server Configuration Manager”. Then “SQL Server Network Configuration”=>”Protocols for MSSQLSERVER”. Doubleclick on “TCP/IP” (it needs to be enabled) in the right pane. A new window opens, go to tab “IP Addresses”. I think you can use any TCP/IP address that is enabled in there to connect to your DB