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
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.
Filed under: SQL