login problems

After migrating SQL Server 2000 from NT to 2003, I have a login failure for
one user when trying to access a database.When I go to the user's login
properties, Database Access, I check the Permit box for the database for the
user and click OK.
I get an Microsoft SQL-DMO error message:
Error 21002:[SQL-DMO]User 'MW_DBA' already exists.
How can I fix this?
Antonin
Antonin
It sounds like your logins and User ID's have got out of synch. Try running
the following on the master database
EXEC sp_change_users_login 'Auto_Fix', 'MW_DBA'
Hope this helps
John
|||Hi John,
Thanks for your reply. I tried it and got this:
The number of orphaned users fixed by updating users was 0.
The number of orphaned users fixed by adding new logins and then updating
users was 0.
Antonin
"John Bandettini" <JohnBandettini@.discussions.microsoft.com> wrote in
message news:D9637F5C-58DF-4940-8E0F-9E4D2A507B51@.microsoft.com...
> Antonin
> It sounds like your logins and User ID's have got out of synch. Try
> running
> the following on the master database
> EXEC sp_change_users_login 'Auto_Fix', 'MW_DBA'
> Hope this helps
> John