RE: Qry Analyzer Debug broken: XP SP2

From: Mingqing Cheng [MSFT] (v-mingqc_at_online.microsoft.com)
Date: 09/15/04 

Date: Wed, 15 Sep 2004 10:42:00 GMT

Hi Tom,

Thanks for your detailed information and descriptions!

First of all, The reason for Error 508 and Error code 0x80070005 is
permission issue. As you said it works fine before upgrading to XP SP2,
have you tried disable the Firewall os XP SP2. Close the firewall and then
tell me whether it works. Checking the following documents to make sure
your SQL Server in XP XP2 is correctly configured

How to configure Windows XP Service Pack 2 (SP2) for use with SQL Server
http://support.microsoft.com/?id=841249

Secondly, The error 0x800706ba generated is a Distributed COM communication
error when using RPC. The error code 0x800706ba translates to "RPC server
unavailable". DCOM uses Remote Procedure Call (RPC) dynamic port
allocation. By default, RPC dynamic port allocation randomly selects port
numbers above 1024, so the problem seems to be the firewall blocking the
rpc communication. Do the folloing things to make sure DCOM is running
fine.

* On the client machine
--run dcomcnfg.
--Go to the dcom config properties under default properties, there is a
check box stating "enable Distributed COM on this computer", if this was
unchecked on the client machine, this is a default setting that is checked.
make sure it is checked.

*Then copied the new sqldbg.dll and sqldbreg.exe from the SQL Server CD,
replcaed the old ones with these on the client machine and then ran the
regsvr32 sqldbg.dll for re-resgistering the dll and sqldbreg.exe
/RegServer on the client machine and rebooted the box and everything
started to work like a charm.Customer was able to debug the stored proc on
the server using SQL QA and t-sql debugger from his client machine.

Thank you for your patience and cooperation. If you have any questions or
concerns, don't hesitate to let me know. We are here to be of assistance!
 

Sincerely yours,

Mingqing Cheng

Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
---------------------------------------------------------------
Introduction to Yukon! - http://www.microsoft.com/sql/yukon
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!

Relevant Pages

  • Re: Cannot generate SSPI context and Windows 2000 service pack 4
    ... This happens because of a Kerberos authentication protocol issue, ... Enable Kerberos logging on the client machine (documented at ... connect to the remote SQL Server, if you get the same error message then ... having some error messages on the APPLICATION eventlog of the SQL Server ...
    (microsoft.public.sqlserver.connect)
  • RE: Problem:fail to invoke remote RPC method
    ... > distributed transaction on the sql server machine, both machines have the sp2 ... > the rpc services are running, msdtc service are running, ... > Firewall Port Settings: ...
    (microsoft.public.sqlserver.connect)
  • Problem:fail to invoke remote RPC method
    ... I have two xp sp2 machines(one desktop with sql server running, ... Firewall Port Settings: ... RPC server is ready ...
    (microsoft.public.sqlserver.connect)
  • Re: Regional settings - decimal separator
    ... SQL Server has no knowledge of the Windows setting that the client machine has which is connected ... through a connection. ...
    (microsoft.public.sqlserver.programming)
  • Re: Cube View Problem
    ... Try to use the SQL Server Profiler in order to get more details about ... Business intelligence development studio from the client machine. ... the cube and deploy the cube from the client machine. ... further error information" ...
    (microsoft.public.sqlserver.olap)