Syncing login and user, sqlserver2005? RRS feed

  • Question

  • Hi All,

    I have an SQL Server 2005 server that had a login defined of, for example, 'User1', which was mapped to a User with the same name on 'Database1'.

    I restored a database ('Database2') from a different server which contained the same User name ('User1'), but it appears the login that already existed with that name doesn't map to the existing User in 'Database2'.

    I don't want to drop and recreate the Logins and Users if I can help it.

    So, I'm wondering if there's another way to sync the existing login against the existing user in 'Database2'?

    Any help appreciated!


    Thursday, January 29, 2009 12:27 AM

All replies