Regarding Logins...

  • Hi,

    I have a question regarding the logins in sql server 2005.

    We have installed sql server 2005 in QA and Production. In QA Iam seeing the logins:

    SQLabcQA\SQLServer2005MSFTEUser$SQLabcQA$abcQA

    SQLabcQA\SQLServer2005MSSQLUser$SQLabcQA$abcQA

    SQLabcQA\SQLServer2005SQLAgentUser$SQLabcQA$abcQA

    But these does not exist in production? why this difference and what these logins do?

    Thank you

    Mani

  • How did you install it, was this a VM machine 🙂

  • Different services perhaps. Those users are for full text search and sql agent. I think the default service user is different as well and you might not have noticed it.

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

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