470,636 Members | 1,365 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,636 developers. It's quick & easy.

SQL Debugger Problem

I can get the debugger to work: I get a message:
"sp debugging may not work if you log as as Local System Account" while
SQL Service is configured to run as a service. You can open Event Viwer
to see details." (Viwer means "Viewer" this is not one of my typos...)

My text book says that this message means there is a problem that can
be fixed in the SQL Server registration node (just under the server
group in Enterprise Manager), Properties dialog, Security tab, Start Up
Service.

The book says to enter a valid user account and password in the Start
Up Service area. However, there is in my case a "LocalSystem" and an
encrypted password entered in this area and and I have no idea how
these got in there.

I assume the latter are default settings from when SQL was
installed...Can I can this to "sa" and no password? I'm afraid to
change the existing setting if I don't understand what it is and where
it came from..

Thank you **very** much for help...I would like to use the debugger.

J.

Jul 23 '05 #1
1 1709

<JJ****@hotmail.com> wrote in message
news:11**********************@g14g2000cwa.googlegr oups.com...
I can get the debugger to work: I get a message:
"sp debugging may not work if you log as as Local System Account" while
SQL Service is configured to run as a service. You can open Event Viwer
to see details." (Viwer means "Viewer" this is not one of my typos...)

My text book says that this message means there is a problem that can
be fixed in the SQL Server registration node (just under the server
group in Enterprise Manager), Properties dialog, Security tab, Start Up
Service.

The book says to enter a valid user account and password in the Start
Up Service area. However, there is in my case a "LocalSystem" and an
encrypted password entered in this area and and I have no idea how
these got in there.

I assume the latter are default settings from when SQL was
installed...Can I can this to "sa" and no password? I'm afraid to
change the existing setting if I don't understand what it is and where
it came from..

Thank you **very** much for help...I would like to use the debugger.

J.


As the message says, you cannot use the debugger (remotely, at least) when
MSSQL is running as LocalSystem:

http://support.microsoft.com/default...b;en-us;280101

Your book is correct that you need to change LocalSystem to a Windows domain
account using EM (this is an operating system account, and nothing to do
with the sa account within MSSQL itself) - the default is to use
LocalSystem, but this means that some functionality will not work, so a
domain account is generally preferred. See "Setting up Windows Services
Accounts" and "Changing Passwords and User Accounts" in Books Online.

If you're not familiar with service accounts, this article may be useful:

http://www.databasejournal.com/featu...le.php/3349561

Simon
Jul 23 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

7 posts views Thread by Piet Van Vlierberghe | last post: by
5 posts views Thread by Tom Edelbrok | last post: by
1 post views Thread by Chris Stiefeling | last post: by
13 posts views Thread by Rainer Queck | last post: by
12 posts views Thread by colin | last post: by
1 post views Thread by Korara | last post: by
???
reply views Thread by Stoney L | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.