Post reply

2 sa entries in sysxlogins

  • August 28, 2003 at 5:02 am

    #59767

    I came upon a strange problem while looking through the sysxlogins table. I have 2 servers that containt 2 entries for sa in the sysxlogins table. The rest of my servers all have only 1.

    Does anybody have any ideas as to why this is so?

    Regards

    Gert

  • August 28, 2003 at 7:09 am

    #471799

    These two server have remote server setup to other SQL Server with 'sa' login mapping. Go to Security --> Remote Server --> properties to verify that.

  • August 29, 2003 at 8:39 am

    #471997

    Thanx for the info. It is indeed because of the remote servers.

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

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