Post reply

Problem while transferring logins from SQL 2000 to SQL server 2008

  • September 13, 2011 at 2:52 am

    #257165

    Hi,

    I am migrating my SQL Server from 2000 to SQL 2008.When i transfer login through BIDS or through revlogin script all logins gets created.But logins with weak password in SQL Server 2000 becomes disabled inSQL server 2008.So We set strong passsword manually & then we enble the login.

    Because we have more than 400 logins,doing this each time is not possible.Please suggest.

    Thanks in advance.

    Regards,

    Akshay G.

  • September 13, 2011 at 3:13 pm

    #1380938

    I don't think there is an easy to do this.

    Here is my 2 cents:

    1) SET CHECK_POLICY = OFF -- so, the uses can still use their old password, (but weak).

    2) From the generated login script, you can use search/replace to set the CHECK_POLICY = ON, and manually change the password ....(very tedious...), and send every user his/her new strong password.....

  • September 13, 2011 at 5:37 pm

    #1380998

    I don't think there is a direct way to do this. Wild Cat gave good recommendation.

    Sometimes SQL 2000 passwords cause lot of issues due to the Case Insensitive collations.

    Thank You,

    Best Regards,

    SQLBuddy

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

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