I am trying to debug an app on my machine which is running Windows 7 64, MS SQL 2008 Developer Edition and Visual Studio 2008.
When I try to make a connection through VB to the SQL database I kept getting a timeout error. After trying a number of things I then tried to make an ODBC connection to the SQL DB and got the same timeout error - HYT00.
I have checked that all SQL and associated services are running, "Shared Memory", "TCP/IP" and "Named Pipes" are all enabled but I am out of ideas. I have tried calling the machine by its name, its IP address and '.' none of which make any difference.
I use SQL Server authentication to log into my DB and am happily able to log in and to work on my db through SQL Management Studio using the same login I am trying for ODBC.