Repeating logins

  • Hi,

    I need to know why there are null users names and passwords are there and why sa logins are repeating in sysxlogins.

    User                                    Password

    anath                           <Password>

    bmssa                          <Password>

    BUILTIN\Administrators      NULL

    epg\instworkflow              NULL

    epg\ytgd                         NULL

    sa                               <password>

    NULL                               NULL

    sa                             0x63D2BDC1DF638C6B

    sa                             0x63D2BDC1DF638C6B

    NULL                                  NULL

    NULL                                NULL

    NULL                                 NULL

    Thanx for ur time and help

    from

    Killer.

  • Hi,

    BUILTIN\Administrators is a GROUP, so password is controlled for the users at OS level, hence it is NULL in sysxlogins. I guess the two epg\ domain entries are also groups?

    The multiple sa accounts are probably for linked servers - if you check the srvid column for each you should see a different value - NULL for local system, and a value (from sysservers) for the linked accounts.

    The NULL users could be logins that were set up, but the users domain account has now been deleted. Check syslogins to see what is currently valid.

    Hope that is some help.

  • Hi,

    Thanx for ur help.

    from

    Killer

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

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