Post reply

Copy logins through Database Copy Wizard

  • November 22, 2013 at 8:48 am

    #1668447

    Trying dropping the user from the db and recreated it and still same error.

  • November 22, 2013 at 9:12 am

    #1668463

    SQL_Surfer (11/22/2013)

    Trying dropping the user from the db and recreated it and still same error.

    Then it is may be not your problem?

    Igor Micev,My blog: www.igormicev.com

  • November 25, 2013 at 9:39 am

    #1668876

    With SQL Logins the copy wizard does not migrate the password if I remember correctly, although I think there is a setting to specify what password to set when creating the user on the new instance.

    I would always recommend using the sp_helprevlogin stored procedure (and don't forget sp_hexadecimal) for migrating SQL User accounts as this does the password as well

Viewing 3 posts - 16 through 17 (of 17 total)

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