migrating db from sql200 to sql2005

• mepefe

  Grasshopper

  Points: 16

  More actions

  August 18, 2009 at 11:46 am

  #132783

  Hello everyone.

  I need to migrate my old SQL Server 2000 to my new SQL2005 Server.

  The migration is fine, but the users can not connect to my Systems.

  Could you help to find any way to my old users works in my new SQL2005 server?

  Regards

  Melvin

  🙂

• Adam Angelini

  SSCrazy Eights

  Points: 8548

  More actions

  August 18, 2009 at 11:57 am

  #1041053

  create all the logins from your old server to your new one. Be sure to fix any orphans too.

• Robert Klimes

  SSCoach

  Points: 17865

  More actions

  August 18, 2009 at 12:31 pm

  #1041085

  here is a proc that can assist in moving logins between servers

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

  Bob
  -----------------------------------------------------------------------------
  How to post to get the best help[/url]