Re: Service Account Changes

From: Jasper Smith (jasper_smith9_at_hotmail.com)
Date: 05/06/04


Date: Thu, 6 May 2004 18:36:25 +0100

Did you also change the service account for SQL Server Agent ?
Anything in the SQL Agent error log ?

-- 
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Sunil" <anonymous@discussions.microsoft.com> wrote in message
news:2D3E84E1-AF8F-40A4-84E0-1A46CA6103E0@microsoft.com...
> Hi,
>
> We recently changed the service account to one of a domain login through
Enterprise Manager.
> Then we removed the Builtin\Administrators group from the list of logins.
This is because we do
> not want any other Admin User of our domain have access to the database.
> We tried this in one test server and successfully removed
Builtin\Administrators group.
>
> But in Production Server we could not able to restart the SqlAgent
services. This lead into a situation of
> all jobs are not executing now.
>
> Pls help me.
> Thanks in Advance
> Sunil