September 22, 2005 at 4:46 am
I'm having problems debugging a stored procedure on a remote server.
i keep getting the following error:
Server: Msg 504, Level 16, State 1, Procedure sp_sdidebug, Line 1
[Microsoft][ODBC SQL Server Driver][SQL Server]Unable to connect to debugger on remote_servername (Error = 0x80070005). Ensure that client-side components, such as SQLDBREG.EXE, are installed and registered on mymachine. Debugging disabled for connection connectionnumber.
i was trying to debug the stored procedure on the server using service pack 3 but it didn't work. i installed service pack 4 locally and still no luck.
the following files appear their respective directories and have been registered :
sqldbg.dll + sqldbreg.exe (program files\common files\microsoft shared\sql debugging)
When others (running on SP 3) try debugging it works fine.
any help is appreciated.
regards,
shabhana
September 26, 2005 at 12:15 pm
Apply SQL Hotfix 944 on Server.
Turn off your Firewall. Or add exception (add ports) to it which are related to your machine/remote machine using Stored Proc.
Also in the Firewall Settings exclude the program C:\Program
Files\Common Files\Microsoft Shared\SQL Debugging\sqldbreg2.exe and Port 135. Make sure it works when Firewall off.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy