Home Forums SQL Server 2008 Security (SS2K8) Orphaned Users RE: Orphaned Users

  • August 29, 2012 at 1:55 am

    #1531247

    Suresh B. (8/29/2012)

    SQLSACT (8/29/2012)

    My question is: Will I definately end up with orphaned users whenever I restore a database to another server?

    No. Not necessarily. Orphaned users situation araises only if the login does not exist. If the logins exist, no orphansed users.

    If I create the logins on the new server, will SQL make the link automatically between the DB Users and the logins?

    No/Yes.

    Yes, if you create the logins with same SID.

    Thanks

    Yes, if you create the logins with same SID.

    How do iIcreate the Logins with the same SID?

    Is there a process for this?

    Thanks