June 23, 2012 at 7:53 am
Hello All,
I tried to debug on a remote machine via SSMS 2008R2 and got some messages like
TCP port 135 has to be enabled(add to exception list), UDP ports 500 and 4500, and the ssms.exe to be enabled in the firewall.
I did all this things, I also enabled/started some RPC services (maybe more than necessary), and now the message is the following:
"
TITLE: Microsoft SQL Server Management Studio
------------------------------
Failed to start debugger
------------------------------
ADDITIONAL INFORMATION:
Error HRESULT E_FAIL has been returned from a call to a COM component. (mscorlib)
"
Then i turned off the firewall and the message changed to
"
Unable to start T-SQL Debugging. Could not attach to SQL Server process on 'servername'. The RPC server is unavailable.
"
I have checked the DCOM settings on the client machine. On Win7: Start -> Run -> dcomcnfg.exe -> Component Services -> Computers -> My Computer -> Properties -> COM Security -> Access Permissions -> Edit Limits, and set ANONYMOUS LOGON to 'Allow' for 'Remote Access'.
Again, the same error.
Can anyone advice something that i'm maybe missing, or there should be done some things on the remote machine where i don't have access.
Regards,
IgorMi
Igor Micev,My blog: www.igormicev.com
June 25, 2012 at 1:12 pm
Dear all,
Just to remember you on this issue, I still haven't resolved it ...
Any advises are welcome ...
Regards,
IgorMi
Igor Micev,My blog: www.igormicev.com
June 25, 2012 at 1:20 pm
Assuming you are using a linked server...in the linked server setup, under server options, did you set the remote procedure calls to true?
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
June 25, 2012 at 3:37 pm
MyDoggieJessie (6/25/2012)
Assuming you are using a linked server...in the linked server setup, under server options, did you set the remote procedure calls to true?
No, I'm not using linked server, however i checked the remote connections to the server, and it is set to true.
Thanks anyway
IgorMi
Igor Micev,My blog: www.igormicev.com
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply