RE: Cannot Debug Stored Procs from VS.NET
From: Michael Cheng [MSFT] (v-mingqc_at_online.microsoft.com)
Date: 11/19/04
- Next message: Peter Vanopulos: "Re: sp_OACreate, ODSOLE Extended Procedure, The system cannot find the file specified."
- Previous message: Thomas: "RE: Writing record content into somename.sql"
- In reply to: Alex Clark: "Cannot Debug Stored Procs from VS.NET"
- Next in thread: Alex Clark: "Re: Cannot Debug Stored Procs from VS.NET"
- Reply: Alex Clark: "Re: Cannot Debug Stored Procs from VS.NET"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 19 Nov 2004 08:28:05 GMT
Hi Alex,
Thanks for your post and please understand that we will usually response
within 24 hours as we are in East Asian :)
>From your descriptions, I understood that everything was OK before you
applying hotfix of SQL Server 2000, however, you encounter error 0x80070005
for debugging stored procedure in XP after installing the hotfix. Have I
understood you? Correct me if I was wrong.
First of all, would you please let me know what hotfix you had applied?
Secondly, is it possible for your to change the SQL Server startup account
from 'NT AUTHORITY\SYSTEM' to a Domain Account, which has has
administrator authority, and let me know whether this resolve your issue.
Thirdly, check to see if the client and the server do not have any firewall
between them. Disable the firewall and then try again.
Fourthly, on the client machine, make sure DCOM was enabled by the
following steps
--run dcomcnfg.
--Go to the dcom config properties under default properties, there is a
check box stating "enable Distributed COM on this computer", this is a
default setting that is checked.
If all these above does help, please let me know the detailed information
shown in Error Log (System Log and Application Log).
Thank you for your patience and corporation. If you have any questions or
concerns, don't hesitate to let me know. We are always here to be of
assistance!
Sincerely yours,
Michael Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
---------------------------------------------------------------
Get Secure! - http://www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!
- Next message: Peter Vanopulos: "Re: sp_OACreate, ODSOLE Extended Procedure, The system cannot find the file specified."
- Previous message: Thomas: "RE: Writing record content into somename.sql"
- In reply to: Alex Clark: "Cannot Debug Stored Procs from VS.NET"
- Next in thread: Alex Clark: "Re: Cannot Debug Stored Procs from VS.NET"
- Reply: Alex Clark: "Re: Cannot Debug Stored Procs from VS.NET"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
