Also available at

Also available at my website http://tosh.me/ and on Twitter @toshafanasiev

Wednesday, 22 January 2014

SQL Debugging Gotcha

While trying to debug a table trigger (shudder) in SQL Server Management Studio I encountered the following error message:

Unable to start T-SQL Debugging. Could not connect to computer '.'. This is usually a temporary error during hostname resolution and means that the local server did not receive a response from an authoritative server.

It's actually as simple as the fact that you used '.' to mean 'this machine'. Using your actual machine name, or even 'localhost' will have the same effect as the dot but will also let the debugger connect to the server instance.

This wasn't obvious from the error message and hopefully this will help someone else.