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
Solved

SP debugging not working properly

Posted on 2006-06-29
8
908 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
  • 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 200 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

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

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

Let's review the features of new SQL Server 2012 (Denali CTP3). It listed as below: PERCENT_RANK(): PERCENT_RANK() function will returns the percentage value of rank of the values among its group. PERCENT_RANK() function value always in be…
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

840 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