?
Solved

SP debugging not working properly

Posted on 2006-06-29
8
Medium Priority
?
931 Views
Last Modified: 2008-01-09
Hi Experts,

I am not able to debug stored procedures from Query Analyzer. If I try then it gives the following error:
SP debugging may not work properly if you log on as 'Local System account'while SQL Server is configured to run as a service.

How to solve this?

Regards
Suman Ghosh
[Massoftind]
0
Comment
Question by:SumanGhosh
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
8 Comments
 
LVL 75

Expert Comment

by:Aneesh Retnakaran
ID: 17007914
goto start -> run
Services.msc
Find the service named 'MSSqlserver' -> right click and select propertis
Select the Log On tab.
Check whther Service Startup is selected as the 'Local account'  Choose the other option and put the user with you lodgon and the password ..restart the service
0
 

Author Comment

by:SumanGhosh
ID: 17007944
I used the user account and password and the message above has stopped appearing. But I am still not able to debug, as I get this error:


Server: Msg 508, Level 16, State 1, Procedure sp_sdidebug, Line 1
[Microsoft][ODBC SQL Server Driver][SQL Server]Unable to connect to debugger on USSERVER (Error = 0x800401f3). Ensure that client-side components, such as SQLLE.DLL, are installed and registered on USSERVER. Debugging disabled for connection 59.

What do I do?
0
 
LVL 75

Accepted Solution

by:
Aneesh Retnakaran earned 800 total points
ID: 17008191
0
 

Author Comment

by:SumanGhosh
ID: 17499892
Hello Administrator,

Its not that I dont want to give points to the expert who has come up with a proper solution, but I have not yet got the time to test whatever has been reccomended here because of my current project deadline. I intend to do so very soon, till then I request you to keep this question open.

Regards,
Suman Ghosh
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Ready to get certified? Check out some courses that help you prepare for third-party exams.
This month, Experts Exchange sat down with resident SQL expert, Jim Horn, for an in-depth look into the makings of a successful career in SQL.
Via a live example, show how to shrink a transaction log file down to a reasonable size.
Viewers will learn how the fundamental information of how to create a table.

650 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question