I am trying to attach the process from Visual Studio 2005 and getting 'Unable to attach the process. You do not have permission to debug he process'.
I found that the process type is X86 for a windows service.
The same windows service is installed on other machine with same configuration but there it is showing T-SQL Manged, X86 as the process type. System configuration: Windows Server 2003 R2, Visual Studio 2005 team edition.
Please if you can tell how to get the process type as T-SQL Manged, X86 in the attach to process window with automatic setting.