• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 934
  • Last Modified:

SP debugging not working properly

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
SumanGhosh
Asked:
SumanGhosh
  • 2
  • 2
1 Solution
 
Aneesh RetnakaranDatabase AdministratorCommented:
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
 
SumanGhoshAuthor Commented:
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
 
Aneesh RetnakaranDatabase AdministratorCommented:
0
 
SumanGhoshAuthor Commented:
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

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now