Unable to start T-SQL Debugging. Cannot attach to sql server process on SERVERNAME. RPC server is unavailable

I am running VS2005 from my workstation, connecting to SQL2008 Std x64 on a Win2008 server.

After following the instructions for setting up remote debugging (VS2005 to SQLServer2008), I get the following error:

"Unable to start T-SQL Debugging. Cannot attach to sql server process on SERVERNAME. RPC server is unavailable"

*** It all works perfectly if I disable the windows firewall on the server!  ***

I have added FW exceptions as follows:

netsh advfirewall firewall add rule name="Microsoft Visual Studio Remote Debugging Monitor - UDP 137" dir=in action=allow enable=yes localport=137 protocol=udp

netsh advfirewall firewall add rule name="Microsoft Visual Studio Remote Debugging Monitor - UDP 138" dir=in action=allow enable=yes localport=138 protocol=udp

netsh advfirewall firewall add rule name="Microsoft Visual Studio Remote Debugging Monitor - TCP 139" dir=in action=allow enable=yes localport=139 protocol=tcp

netsh advfirewall firewall add rule name="Microsoft Visual Studio Remote Debugging Monitor - TCP 445" dir=in action=allow enable=yes localport=445 protocol=tcp

At the moment I am packet sniffing with wireshark to try and work out the blocked ports....which is my best guess at the cause of the problem.






ben84Asked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
Raja Jegan RConnect With a Mentor SQL Server DBA & ArchitectCommented:
You need to exclude some other ports like TCP 80, 135 and more info here:

http://msdn.microsoft.com/en-us/library/bt727f1t%28VS.80%29.aspx
0
 
Chris MConsulting - Technology ServicesCommented:
Add the SQL ports to the list of exceptions on the server's firewall.
0
All Courses

From novice to tech pro — start learning today.