2PTTechnology

I’ve restored my database from a different server and all the users in security are set up but when I try to assign the user to that database I get an error that "its already assigned".  When I check the properties for that user and check the User Mapping, my database is unchecked.

Does anyone know how to drop the user or reattach it? Because when I try, it keeps giving me an error "Drop Failed" or

"Create Failed for User 'MyUser'. (Microsoft.SqlServer.Smo)" "User or role 'MyUser' already exists in the current database" error 15023

Thanks

To fix this problem you need access to SQL Query Analyzer or any application that allows you to run SQL scripts.  Follow the steps below to fix you database problem.

1) Login in SQL as administrator

2) Set your database to Master

3)  Run this script (replace YourDatabase and MyUser with the correct information)

sp_configure "allow updates", 1

go

reconfigure with override

update YourDatabase..sysusers set sid = (select sid from master..syslogins where name = 'MyUser' ) where name = 'MyUser'

sp_configure "allow updates", 0

reconfigure with override

In SQL 2005 I get this Msg when i run this script

Msg 259, Level 16, State 1, Line 2

look at this thread

http://2pttechnology.com/Web/forums/thread/112.aspx

The solution I found is

EXEC [sys].[sp_change_users_login] 'UPDATE_ONE', <UserName>, <LoginName>, <Password>

for existing user and login.

Read this for details:
http://sqltutorials.blogspot.com/2008/02/maps-existing-database-user-to-sql.html