Re: Service Account Changes
From: Jasper Smith (jasper_smith9_at_hotmail.com)
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" <firstname.lastname@example.org> 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