August 23, 2010 at 11:14 am
I Installed sql server 2008 on my system and getting this error when trying to execute a query.
The windows firewall on this machine is currently blocking remote debugging. Remote debugging also requires DCOM (TCP PORT 135 and IPSEC (UDP 4500 /UDP 500) be unblocked.
August 23, 2010 at 11:53 am
Is there a question here?
August 23, 2010 at 2:14 pm
Sorry about that. I Installed sql server 2008 r2 on my system and when I query I am getting this error...
August 23, 2010 at 3:33 pm
Disable debugging on the query (alt+f5...you might have mistakenly hit alt while you were executing with f5 and turned debugging on. Check the debug menu to see if it is).
Your server should also be behind a true network firewall/appliance..you shouldn't really be relying on the windows integrated firewall for anything remotely important.
August 23, 2010 at 4:19 pm
Or if this is your local machine and you need debugging, or it's a dev server, enable those ports in the firewall.
August 24, 2010 at 6:59 am
This is on my laptop, I am still a learner. I did enable the ports, but still the same error.
August 24, 2010 at 7:44 am
Did you check if you have debugging enabled? And do you need it to be, if so?
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply