?
Solved

SP debugging not working properly

Posted on 2006-06-29
8
Medium Priority
?
925 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

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

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

In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
In part one, we reviewed the prerequisites required for installing SQL Server vNext. In this part we will explore how to install Microsoft's SQL Server on Ubuntu 16.04.
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.
Suggested Courses

800 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