SQL Debugger Problem

[JJ_377]

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.

[Simon Hayes]

<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