When trying to run the dubugger for T-SQL via SQL Server Managemnt Studio on Windows 7 or Windows 2008 R2 Server connecting to an instance of SQL Server 2008 R2 on the machine you may well get the error message “Unable to start T-SQL Debugging. Could not connect to the computer ‘(local)’. The requested name is valid, but no data of the requested type was found.”, this is if you use (local) as the conenction, if like may you use period ie . as the connection the error will be the same, except for the machine name.
The solution it seems is very simple, so simple it got past me for weeks!
It seems on Windows 7 and Windows 2008 R2 server you have to use the machine name to be able to debug, as simple as that.