Re: Logins created by default

From: Kevin McDonnell [MSFT] (kevmc_at_online.microsoft.com)
Date: 02/25/05 

Date: Fri, 25 Feb 2005 00:03:48 GMT

I think the confusion may be in that the account specified to start the
services is added to the logins.

If you specify in setup that a local windows account or domain account
should be used to start the services, (MSSQL and SQL Agent)
then this account is added to the logins.

If you selected to start the service with 'localsystem' which I don't
recommend, then only the Builtin\admin and sa account is
added to the logins.

Hope this helps.

Kevin McDonnell
Microsoft Corporation

This posting is provided AS IS with no warranties, and confers no rights.

Relevant Pages

  • Re: Changing security authentication type.
    ... i'm thinking that yes in time the sa account will ... Create one or more logins for the applications. ... for each database. ... , you really have no security for your ...
    (microsoft.public.sqlserver.security)
  • Re: Server 2003 Group Policies - Affecting Administrative Profile
    ... If I was you I would remove TS Access rights from the Administrator account ... office" logins as well as remote logins. ...
    (microsoft.public.windows.server.general)
  • Re: SQLDTS Transfer File Task
    ... E.g. 20 logins. ... run the logins expire in 5 days. ... Can anyone confirm whether SQLDTS transfer File task uses a single ... I would like the account to last as long as possible (its not actually ...
    (microsoft.public.sqlserver.dts)
  • sshd authentication via pam with ldap
    ... I tried to enforce passwd expiration and account lockout via the ... Then I logged in with a user ID whose account would expire soon and the ... Telnet logins work as expected but we would really like to have ssh ... logins work correctly with password expiration and account lockout. ...
    (comp.unix.solaris)
  • Re: Account Login
    ... > account. ... I have found several logins that were preceeded by login ... can get into a computer running any operating system. ...
    (microsoft.public.windowsxp.security_admin)