July 22, 2009 at 10:01 am
After upgrading from sql server 2000 to 2005 sp2, I have a login called "name1" linked to user called "name1". In the application database security node i have user called "dbo" that is suppose to have login name as "name1" but the login name is blank. Does anyone know how to set the login name of user dbo to name1.
When in the application db I try to change the username "name1" of login "name1" to dbo, it fails because there's already a username in the database called dbo. And of course I cannot delete dbo from the database.
Has anyone seen this or can offer a way to remove dbo from the application database.
I really need your help!
Thanks!
July 22, 2009 at 10:14 am
This is due to orphaned user name1.
check out for sp_change_users_login in BOL.
Following example from BOL Should help you.
USE YourDB;
GO
EXEC sp_change_users_login 'Auto_Fix', 'Name1', NULL, 'New_Password';
GO
July 22, 2009 at 10:39 am
I tried that but it didn't find any orphaned users. Is there another way to update the loginname for the user dbo in the app db? right now its blank.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply