August 22, 2002 at 12:40 pm
This should be an easy one for someone.
1. Go to Query Analyzer
2. Pick a stored procedure
3. Right Click and choose debug.
I'm getting an error message:
"SP debugging may not work properly if you log on as 'Local System Account' while SQL Server is configured to run as a service. You can open Event Viewer to see details."
I found the Event Viewer in the Control Panel, but not exactly sure what I'm looking for.
Anyone know what's going on?
Steve
Steve Miller
August 22, 2002 at 1:23 pm
I think the service account for SQL Server needs to be an account other than Local System.
Steve Jones
August 23, 2002 at 8:47 am
Steve,
That seems to be the answer. After getting a bit of an education on Windows Services I changed the service account. The message doesn't come up anymore.
Steve
Steve Miller
August 23, 2002 at 10:37 am
Glad it worked. I think this took me awhile to get working on one server, but was flawless on another. I don't use the debugger often, but it seems to be stable for me when I do.
Steve Jones
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply