migrating logins 2000 -> 2005 | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

migrating logins 2000 -> 2005

Hi all,
I have detached/attached a sql 2000 db to a sql2005 db.
The db contains one db user who is dbo in that db.
With sp_change_users_login I was able to create the missing sql login on sql 2005 server but the mapping between the login and the db was not made and cannot be made manualy -> user already exists in db ???
I even cannot drop user in db -> owns shemas How to get around this ?

read this article :http://support.microsoft.com/kb/246133 Madhu
What was the specific error you are getting when trying to?
I beleive Madhu’s link should get you what you are looking. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.