Solved

SP debugging not working properly

Posted on 2006-06-29
8
898 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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
This query failed in sql 2014 5 31
get column names from table in vb.net 8 28
SQL Server - Set Value of Multiple Fields in One Query 10 23
T-SQL:  Collapsing 9 24
Introduction SQL Server Integration Services can read XML files, that’s known by every BI developer.  (If you didn’t, don’t worry, I’m aiming this article at newcomers as well.) But how far can you go?  When does the XML Source component become …
JSON is being used more and more, besides XML, and you surely wanted to parse the data out into SQL instead of doing it in some Javascript. The below function in SQL Server can do the job for you, returning a quick table with the parsed data.
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

773 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