Edit Question - KnowledgeHub

Title Body

I have a domain controller installed on virtual Windows Server 2008 x64 . SQL Server 2008 Express x64 is running on Windows Server 2008 x64 and client on Windows 7 RTM x86 . Both have joined the domain. I'm starting both Visual Studio 2008 and SQL Server Management Studio 2008 under domain admin user. This account is a member of group sysadmin on SQL Server . Server has firewall exceptions for both TCP and UDP on ports 135-139 and 1433-1434 . Visual Studio 2008 Remote Debugger services is started on server and Domain Admins group is allowed to debug. Remote DCOM works: I can attach to remote server and list it's processes, can switch to show only managed code, etc. When I'm starting debugging of a query in SMS I'm getting this error: Failed to start debugger Error HRESULT E_FAIL has been returned from a call to a COM component. (mscorlib) Program Location: at System.Runtime.InteropServices.Marshal.ThrowExceptionForHRInternal(Int32 errorCode, IntPtr errorInfo) at Microsoft.SqlServer.Management.UI.VSIntegration.DebugSession.DebugCallbacks.OnSqlInitializeDebuggingEvent(ISqlInitializeDebuggingEvent sqlInitializeDebuggingEvent) at Microsoft.SqlServer.Management.UI.VSIntegration.DebugSession.DebugCallbacks.Microsoft.VisualStudio.Debugger.Interop.IDebugEventCallback2.Event(IDebugEngine2 debugEngine, IDebugProcess2 debugProcess, IDebugProgram2 debugProgram, IDebugThread2 debugThread, IDebugEvent2 debugEvent, Guid& riidEvent, UInt32 attribute) and Unable to access the SQL Server debugging interface. The Visual Studio debugger cannot connect to the remote computer. A firewall may be preventing communication via DCO

Tags (comma-separated) Cancel