Re: SQL2k debugging broken/problem

Hello,

Many factors can cause the issue. For example,

1. DCOM Component is disabled.
2. Firewall existing between the client and the server.

I suggest that you perform the following steps:

1. Test to see if you can use Transact-SQL Debugger to debug the stored
procedure in another local SQL instance installed on another local
computer. Please make sure both computers locate in the same domain and no
firewall between them.

2. Install a new SQL instance on another Windows 2003 SP1 machine then
check if it can debug the stored procedure on another local computer.

3. Turn off any firewall installed on the client computer and the server.
Check the issue again.

4. Run dcomcnfg both on the client machine and the server when firewall is
turned off. Go to the Dcom Config properties under default properties.
Locate the check box stating "enable Distributed COM on this computer" and
check it if it isn't checked.

5. Refer to steps in the "Incorrect DCOM Permission Settings" in the
"Troubleshooting the Transact-SQL Debugger" topic in BOL to allow remote
users to attach the debugger to a process on the database server.

6. Follow these steps to manually install and register missing debugger
components when the server and client are running on different machines:

On the client:
1. Copy file sdiclnt.dll from the \x86\binn folder of your SQL Server 2000
CD-ROM to c:\program files\microsoft sql server\mssql\80\tools\binn, then
register it:
regsvr32 sdiclnt.dll

2. Create folder c:\program files\common files\microsoft shared\SQL
Debugging.
3. Copy the following files from \x86\other\sdi to c:\program files\common
files\microsoft shared\SQL Debugging:
sqldbg.dll
sqldbreg.exe

then, register the files:

regsvr32 sqldbg.dll
sqldbreg /RegServer

On the server:
1. Create folder c:\program files\common files\microsoft shared\SQL
Debugging.
2. Copy the following file from \x86\other\sdi to c:\program files\common
files\microsoft shared\SQL Debugging:

sqldbg.dll
then, register the file:
regsvr32 sqldbg.dll

3. Copy file mssdi98.dll from \x86\other\sdi to where sqlservr.exe resides
(e.g. c:\program files\microsoft sql server\mssql\binn)
4. Restart the SQL Server service

Reboot the computer.


7. If the issue still exists, disable the firewalll, then run
netstat -ano 5

while running the debugger.

Check the port is used by QA. Then open these ports on firewall.

Some customers resolved their issue by performing above steps. I hope the
information is helpful.

Sophie Guo
Microsoft Online Partner Support

Get Secure! - www.microsoft.com/security

=====================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.


.

Relevant Pages

  • RE: OWA page not displayed Outside
    ... Open ISA 2006 management console. ... Expand the server node and highlight 'Monitoring'. ... Click 'Configure Firewall Logging'. ... |> internal client as both the web proxy client and firewall client? ...
    (microsoft.public.windows.server.sbs)
  • Re: Small business thinking about backing up data, having a server and 2-3 users - is SBS200
    ... is networked to the Master with a crossover network cable. ... Master on the Master PC and Client on the Slave pc. ... Since this machine is a server is should handle the requests ok ... Most real firewall appliances have HTTP and SMTP proxy services that allow ...
    (microsoft.public.windows.server.sbs)
  • Re: ISA firewall block outgoing email.
    ... I cannot send/receive email to the POP3 account unless I turn off the firewall in the CEICW. ... (This server is behind a router so I felt the test was safe enough to turn off the firewall). ... As I said, there is no need to add a hole for port 110, If the ISA client is installed on the workstation, Outlook will deliver the email. ...
    (microsoft.public.windows.server.sbs)
  • Re: SBS VPN setup?
    ... And I'm reviewing if I need to do client notifications at that point. ... You purchase 2k3 PREMIUM and that comes with ISA to handle the firewall duties. ... SBS plugs into a switch with the other computers and the switch is plugged into a firewall appliance with 2-nics. ... To compare apples to apples, let us assume there is a network setup as I outlined above...and the firewall appliance is an ISA server, such as those available from Celestix. ...
    (microsoft.public.windows.server.sbs)
  • RE: VBScript: Remote Desktop Disconnected
    ... I have a client with the same exact scenario. ... Rdp via RWW works fine from ... On the SBS 2003 Server open the Server Management console. ... When navigating to the Firewall page, ...
    (microsoft.public.windows.server.sbs)