Post reply

Automatic sql 2005 logins created?

  • April 24, 2009 at 2:20 pm

    #131521

    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

  • April 24, 2009 at 3:30 pm

    #983853

    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
    “We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”

    ― Charles R. Swindoll

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

  • April 24, 2009 at 3:38 pm

    #983858

    Thank you so very much !!!

    Juanita

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

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