Automatic sql 2005 logins created?

  • Juanita

    SSCertifiable

    Points: 5300

    HI, I noticed when I finsihed my very first sql 2005 installation I have 3 logins in security that were automatically created. They are as follows:

    \SQLServer2005MSFTEUser$Servername$MSSQLSERVER

    \SQLServer2005MSSQLUser$Servername$MSSQLSERVER

    \SQLServer2005SQLAGENTUser$Servername$MSSQLSERVER

    Can someone explain what these are for or direct me to a document where I can read about this? Are these my service accounts? I am setting up seperate domain accounts for my sql agent and sql service account

    Thanks,

    Juanita

  • Jeffrey Williams

    SSC Guru

    Points: 88654

    These are actually local windows groups that are created during the install. When configuring your system you could just add your domain user (or local user) to these windows groups and they will have all of the privileges necessary to run that service.

    If you specified the domain user during the install - it would have already been added to these groups.

    Jeffrey Williams
    Problems are opportunities brilliantly disguised as insurmountable obstacles.

    How to post questions to get better answers faster
    Managing Transaction Logs

  • Juanita

    SSCertifiable

    Points: 5300

    Thank you so very much !!!

    Juanita

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply