Professional Web Applications Themes

Transact-SQL Debugger - Microsoft SQL / MS SQL Server

I am using Windows 2003 Server and SQL Server 2000 Personal Edition. While using Transact-SQL Debugger, it gives me the error Unable to communicate with debugger on EMXDB (Error = 0x80070005). It was working fine before upgrading the system from Windows 2000 Server. Any suggestions would be greatly appreciated. Thanks...

  1. #1

    Default Transact-SQL Debugger

    I am using Windows 2003 Server and SQL Server 2000
    Personal Edition. While using Transact-SQL Debugger, it
    gives me the error Unable to communicate with debugger on
    EMXDB (Error = 0x80070005).
    It was working fine before upgrading the system from
    Windows 2000 Server. Any suggestions would be greatly
    appreciated. Thanks
    Neeraj Guest

  2. #2

    Default Re: Transact-SQL Debugger

    Sethu,
    I tried setting the security for DCOM components after
    refering BOL. It does not help. i get the same error
    message. Thanks for your reply.

    Neeraj
    >-----Original Message-----
    >Hi Neeraj,
    >Please make sure that there are appropriate DCOM
    security permissions for
    >sqldbgreg application ( use DCOMcnfg.exe)
    >For additional details, search sql 2000 booksonline
    for "Troubleshooting the
    >Transact-SQL Debugger"
    >
    >Thanks
    >sethu
    >
    >--
    >This posting is provided "AS IS" with no warranties, and
    confers no rights.
    >Use of included script samples are subject to the terms
    specified at
    >[url]http://www.microsoft.com/info/cpyright.htm[/url].
    >
    >
    >"Neeraj" <to_neerajhotmail.com> wrote in message
    >news:070101c3459a$573c5e00$a101280aphx.gbl...
    >> I am using Windows 2003 Server and SQL Server 2000
    >> Personal Edition. While using Transact-SQL Debugger, it
    >> gives me the error Unable to communicate with debugger
    on
    >> EMXDB (Error = 0x80070005).
    >> It was working fine before upgrading the system from
    >> Windows 2000 Server. Any suggestions would be greatly
    >> appreciated. Thanks
    >
    >
    >.
    >
    Neeraj Guest

  3. #3

    Default Transact-SQL Debugger

    Hi,

    We have upgraded from SQL 7 to SQL 2000 and would like to
    use the debugger tool. I can use the degugger immediately
    after installing the client tools on a windows 2000
    workstation. Next time I log onto the workstation I get
    the 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 LR-COM-SQL (Error = 0x8000401a).
    Ensure that client-side components, such as SQLDBREG.EXE,
    are installed and registered on LR-COM-C. Debugging
    disabled for connection 70."

    If I re-install the client tools on the workstation, I can
    use the debugger again. Next time I log onto the
    workstation I get the error again.

    I seem to be caught in an endless loop....

    Any ideas greatly appreciated.

    Thanks,
    Phil

    phil Guest

Similar Threads

  1. #979 [Opn->Bgs]: [PEAR] Openmarket Transact support
    By pajoye@php.net in forum PHP Bugs
    Replies: 0
    Last Post: December 12th, 12:36 PM
  2. debugger
    By Eric Walker in forum PERL Beginners
    Replies: 2
    Last Post: December 23rd, 01:48 AM
  3. debugger for AIX
    By Egor Yu. Shkerin in forum UNIX Programming
    Replies: 0
    Last Post: August 1st, 06:53 AM
  4. resource low - Transact-SQL
    By Otto Naesset in forum Microsoft SQL / MS SQL Server
    Replies: 1
    Last Post: July 10th, 01:31 PM
  5. Transact-SQL syntax question
    By Rajan Murthy in forum Microsoft SQL / MS SQL Server
    Replies: 2
    Last Post: July 1st, 03:36 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139