May 9, 2002 at 6:33 pm
I re-install the SQL Server in my server.
When I try to debug, I got the following message: SP debugging may not work properly if you log on as "Local System account" while SQL Server is configured to run as a service." Does anybody know what should I do to correct this problem?
Thank you.
May 10, 2002 at 6:13 am
CHeck this out http://support.microsoft.com/default.aspx?scid=kb;en-us;Q281649 should be related and your explination.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
May 12, 2002 at 2:42 pm
I found the real problem is that when I re-install the SQL Server, for some reasons, the debugger is not installed correctly/completely in my server. When I tried to use the debugger from the server, I got the following 2 errors:
1. The debugger interface is not installed. Please re-run setup, select 'add components to your existing installation' and make sure you select 'Development tools'\'Debugger Interface'.
2. 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 MY_SERVER_NAME(Error = 0x8007007e). Ensure that client-side components, such as SQLDBREG.EXE, are installed and registered on MY_SERVER_NAME. Debugging disabled for connection 57.
However, here is what I found. First, neither the file SQLDBREG.EXE, nor the entire directory 'C:\Program Files\Common Files\Microsoft Shared\SQL Debugging' are installed in the server. Second, when I tried to re-run the setup as it recommended and select 'add components to your existing installation', I found both the 'Debug symbol' and 'Development tools'\'Debugger Interface' are already marked as installed. I am not able to re-install them.
Currently, my client machine has the debugger installed successfully. So I tried to copy the entire 'C:\Program Files\Common Files\Microsoft Shared\SQL Debugging' directory to the server manually. But it apparently does not solve my problem.
Any idea for this rare problem? I use the same CD and choose 'Typical installation' for both my server and my client machine. why one installed the debugger, but not the other one. I need to resolve this problem soon.
So if anybody can give me a hand, I would appreciate it. Thank you in advance.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply