Database User Migration Issue

• CDBA

  Hall of Fame

  Points: 3266

  More actions

  February 20, 2007 at 11:52 am

  #175264

  Hi

   

  I am copying one database from a 2000 instance to 2005 and following the below steps:

  1. Recovered the database on 2005

  2. Dropped the impersonated user who are copied while restoring as they did not   have any login id

  3. Executed a SSIS login transfer

   

  Now the SSIS fails with the following error:

   

  [Transfer Logins Task] Error: Execution failed with the following error: "The database 'TestDB' does not exist. Supply a valid database name. To see available databases, use sys.databases. ".

   

  But ‘select * from sys.databases’ shows TestDB in the row.

  As the users are not copied [With the SID], eventually application is failing,

   

  Could any one please advice on how to proceed in this case? Thanks in advance.

   

  Regards

  Utsab Chattopadhyay

  
  CDBA

• htt

  SSCertifiable

  Points: 5242

  More actions

  February 20, 2007 at 1:04 pm

  #690737

  I do this way and it always works for me:

  1. transfer logins using KB http://support.microsoft.com/default.aspx/kb/246133.

  2. restore the db.

  hth,

   

• MohammedU

  SSCoach

  Points: 19644

  More actions

  February 20, 2007 at 11:27 pm

  #690818

  I use the same article rthan mentioned article to transfer the logins...

  Make sure you set default dbs correctly after moving logins...

  MohammedU
  Microsoft SQL Server MVP

• CDBA

  Hall of Fame

  Points: 3266

  More actions

  March 2, 2007 at 1:06 pm

  #692928

  Thank u guys and sorry for reverting back so late..

  Thank for your help

  Regards

  Utsab Chattopadhyay

  
  CDBA