For some reason, I cannot get my remote debugging to work. The server with the database instance is running on Windows Server 2008 R2 with SQL Server 2008 R2.
I am logged into the database with sysadmin privilege. Whenever I try to hit run with debug, it gives me the following error:
Failed to start debugger Error HRESULT E_FAIL has been returned from a call to a COM component. (mscorlib)
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 DCOM to the remote computer. Please see Help for assistance.
Unable to start program MSSQL:://{IP ADDRESS}/master/sys/=0
After googling, I found out this had to do with port 135-139 not being opened. Well I opened them and still no good, so I went ahead and temporarily disabled the firewall on both ends. Still the same error.
Honestly I'm pretty lost on how to fix this error. Assistance would be most appreciated.
