"David Pendleton" <qnirca@gpd.arg> wrote in message
news:ehkEOZ5mEHA.3900@TK2MSFTNGP10.phx.gbl...
>
> Hello all.
>
> I have several machines participating in a small Workgroup. These are all
> Win2K/Win2KAS/XP/SQL Server 2000. A domain is overkill for my home office.
>
> I have successfully debugged a stored procedure on the server. However,
> when
> I attempt the same on a workstation, I am not able to step through code,
> etc. The Application log on the server indicates that the SQLDebugger
> could
> not communicate with the debugger on whatever workstation I happen to be
> using.
>
> I have configured the SQL Debugger via DCOMCNFG per MSDN/Books Online to
> allow 'Everyone' access to the SQL Debugger, and to log in as the
> interactive user, all to no avail.
>
> Does anyone have this working? Any ideas?
>
> Thanks.
> --
> ROT-13 my email address to reply directly
>

"Gert E.R. Drapers" <GertD@SQLDev.Net> wrote in message
news:ehtD5C9mEHA.3896@TK2MSFTNGP15.phx.gbl...
> Do you have a firewall active? If so you need to enable RPC communication
> to go over your firewall.
> Otherwise try establishing a IPC session first from the client to the
> server like:
>
> net use \\sqlserver\ipc$ /u:sqlserver\adminonsqlserver *
>
> GertD@SQLDev.Net
>
> Please reply only to the newsgroups.
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> You assume all risk for your use.
> Copyright © SQLDev.Net 1991-2004 All rights reserved.
>
> "David Pendleton" <qnirca@gpd.arg> wrote in message
> news:ehkEOZ5mEHA.3900@TK2MSFTNGP10.phx.gbl...
>>
>> Hello all.
>>
>> I have several machines participating in a small Workgroup. These are all
>> Win2K/Win2KAS/XP/SQL Server 2000. A domain is overkill for my home
>> office.
>>
>> I have successfully debugged a stored procedure on the server. However,
>> when
>> I attempt the same on a workstation, I am not able to step through code,
>> etc. The Application log on the server indicates that the SQLDebugger
>> could
>> not communicate with the debugger on whatever workstation I happen to be
>> using.
>>
>> I have configured the SQL Debugger via DCOMCNFG per MSDN/Books Online to
>> allow 'Everyone' access to the SQL Debugger, and to log in as the
>> interactive user, all to no avail.
>>
>> Does anyone have this working? Any ideas?
>>
>> Thanks.
>> --
>> ROT-13 my email address to reply directly
>>
>
>