• Thanks everyone for your help. I found that we cannot restore the Master db from SQL server 2000 to SQL Server 2008 R2. Therefore I restored other databases except system databases. After that I deleted all the users that came from the previous databases restore and created all the users exactly the same as it was in the SQL 2000. This was because the GUID in the old database was not exactly the same in new 2008 database.

    Puskal
    Removalists Sydney[/url]