Sql Server Agent won't start

#1

Hello,

I had mistakenly deleted the user BUILTIN\Administrators and ever since none
of my jobs are running. I tried restarting the agent but i get the message:
"The SQLSERVERAGENT service on Local Computer started and then stopped.
Some services stop automatically if they have no work to do, for example,
the Performance Logs and Alearts service." How can I bring back the user
BUILTIN\Administrators and restart the agent?

Thanks in Advance.

--
New SQL Server DBA

#2

recreate the login with sa privs

"Newbie" <Newbie (AT) discussions (DOT) microsoft.com> wrote

Quote:

Hello,

I had mistakenly deleted the user BUILTIN\Administrators and ever since
none
of my jobs are running. I tried restarting the agent but i get the
message:
"The SQLSERVERAGENT service on Local Computer started and then stopped.
Some services stop automatically if they have no work to do, for example,
the Performance Logs and Alearts service." How can I bring back the user
BUILTIN\Administrators and restart the agent?

Thanks in Advance.

--
New SQL Server DBA

#3

Hello David,

specifily how do you add "builtin" back. I was reading Microsoft Best
Practices for SQL Server and that is one of the things they suggest: move the
SA role to a DOMAIN login then delete the "builtin". That worked great but
now or Volume Shadow Copy is broken. It seems that it used that login...

Rich

"David J. Cartwright" wrote:

Quote:

recreate the login with sa privs

"Newbie" <Newbie (AT) discussions (DOT) microsoft.com> wrote in message
news:576F5D53-7E3C-4A50-A0F4-6253A93BABF6 (AT) microsoft (DOT) com...
Hello,

I had mistakenly deleted the user BUILTIN\Administrators and ever since
none
of my jobs are running. I tried restarting the agent but i get the
message:
"The SQLSERVERAGENT service on Local Computer started and then stopped.
Some services stop automatically if they have no work to do, for example,
the Performance Logs and Alearts service." How can I bring back the user
BUILTIN\Administrators and restart the agent?

Thanks in Advance.

--
New SQL Server DBA

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Sql Server Agent won't start

microsoft.public.sqlserver.server microsoft.public.sqlserver.server

Sql Server Agent won't start - 12-16-2005 , 11:29 AM

Re: Sql Server Agent won't start - 12-16-2005 , 11:34 AM

Re: Sql Server Agent won't start - 02-24-2006 , 01:45 PM