Post reply

Migrating logins from SQL 2000 to 2005

  • January 12, 2007 at 6:53 am

    #153382

    Hello,

    I have migrated logins in the past from one SQL 2000 server to another.

    However, we now have our first server with SQL 2005 64-bit.  I have read that security has changes in 2005.

    What is the best way to transfer logins from a SQL 2000 server over to this SQL 2005 server?  Or does anybody have a script to do this?

    I have been serching the web, as well as, sqlservercentral to no avail.

    Thank you in advance for any help / information you can give.

    Al

  • January 12, 2007 at 8:13 am

    #682918

    I am beginning to wonder if this is even possible?

  • January 12, 2007 at 11:55 am

    #683022

    if you search someone had a script here. otherwise you can do so via SSIS but the passwords won't get transfered

  • January 12, 2007 at 12:04 pm

    #683024

    How to transfer logins and passwords between instances of SQL Server

    http://support.microsoft.com/kb/246133

     

    MohammedU
    Microsoft SQL Server MVP

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

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