Re: deleting the service account

From: Jasper Smith (jasper_smith9@hotmail.com)
Date: 04/17/03 

From: "Jasper Smith" <jasper_smith9@hotmail.com>
Date: Thu, 17 Apr 2003 15:43:11 +0100

Win2000/SQL2000

1) Yes it will still run until restarted
2) It won't cause a problem until the service/server is restarted
3) The service won't start that's all - no issues with data integrity
4) Yes, the service runs as normal intil restarted then it doesn't
start - there is no risk. I'm not sure what you are getting at ?

Best practice is to not delete you service accounts :-)
Strict control of access to AD to limit the number of people who
can manage accounts (certainly add/delete anyway). 

-- 
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Emmanuel Nanchen" <Emmanuel.Nanchen@TAKEMEOFF.manpower.ch> wrote in message
news:OO1ruEMBDHA.2044@TK2MSFTNGP10.phx.gbl...
> Hello,
>
>  this is a translation of a post on a national newsgroup.
> For those reading the original newsgroup, please forgive me.
>
>  My following (theoretical) question is the following:
> suppose that my SQL Server Service runs under the domain account
> MYDOMAIN\MyUser. For any reason (ranging from dumbness to pure
> hacking), suppose that this account is deleted from the domain
> while the service is running.
>
>  What will then happen? More precisely:
> 1. Can the service continue to run, even without warranty about
>   data integrity, and if yes, how long (until the restart of the
>   service for other reasons)?
> 2. how long does is take until the service crashes (or which
>   internal events need authentification of the service account)?
> 3. are the exceptions raised by this cause gracefully handled,
>   i.e. are there warranties from Microsoft concerning data
>   integrity or coherence?
> 4. when the situation will eventually be corrected (by having the
>   service running under another account -- yes, I know it is not
>   straightforward) are the data in a coherent state after startup?
>   i.e. are there any warranties from Microsoft?
>
>  What are the best practices recommended by Microsoft to
> minimize this kind of risk (at the level of SQL Server, of course,
> not of the Windows DCs), knowing that the service must access network
> ressources?
>
>  Thank you in advance for your enlightning comments, and have
> a nice Easter
>
> Sincerly
>
>     Emmanuel
>
>
>

Relevant Pages

  • Re: windows live mail problems
    ... After a week of emails from microsoft and attempts at everything that was ... sent,i have finally fixed the problem.All I had to do was restart wlm,on ... tools menu click accounts,from mail section select your wlm account and hit ... remove and ok.then close your wlm. ...
    (microsoft.public.windowsxp.newusers)
  • Re: SOS - WINDOWs WONT BOOT UP
    ... Log into safe mode as the administrator and create a new account for yourself. ... Restart and log into the new account. ... I have a Windows XP used on Dell Inspiron 510m Laptop. ...
    (microsoft.public.windowsxp.basics)
  • Re: Backup Exec service fails on startup
    ... I run secedit and I can't restart the service till I reset ... > insure that the account you name has the necessary rights. ... >> services will not start until I manually reset password. ...
    (microsoft.public.windows.server.general)
  • intermittent error in asp.net
    ... intermittently - and I can only get it to restart after restarting my ... request failure can be found in the application event log of the web server. ... This error can be caused when the worker process account has ... Process Model of machine.config has administrator account already configured ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Administrator account
    ... Do so until the Windows Advanced Options menu appears. ... Using the arrow keys on the keyboard, select Safe mode and then press Enter. ... When you are asked to restart the computer, ... the account under different username and password), but it doesnt work, it ...
    (microsoft.public.windowsxp.general)