• durai nagarajan (8/31/2012)


    as the user specified select * from sys.sql_logins datas are matching on both the servers.

    is it matching due to master DB mirroring?

    The same except for the two columns mentioned.

    No, master cannot be mirrored.

    @rarara, are your two instances running under the same domain account?

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato