February 22, 2010 at 12:47 pm
I'm trying to copy the database. I'm using the copy database from the task manager. If fails for the following reason.
description=Executing the query "CREATE USER [winadmin] FOR LOGIN [test\winadmin] WITH DEFAULT_SCHEMA=[winadmin] "
failed with the following error: "The login already has an account under a different user name.".
Possible failure reasons: Problems with the query<c/> "ResultSet" property not set correctly<c/> parameters not set correctly<c/>
or connection not established correctly. helpFile= helpContext=0 idofInterfaceWithError={8BDFE893-E9D8-4D23-9739-DA807BCDC2AC}
StackTrace: at Microsoft.... The package execution fa... The step failed.,00:09:54,0,0,,,,0
Pl help
February 22, 2010 at 4:30 pm
dosskavi (2/22/2010)
I'm trying to copy the database. I'm using the copy database from the task manager. If fails for the following reason.description=Executing the query "CREATE USER [winadmin] FOR LOGIN [test\winadmin] WITH DEFAULT_SCHEMA=[winadmin] "
failed with the following error: "The login already has an account under a different user name.".
Possible failure reasons: Problems with the query<c/> "ResultSet" property not set correctly<c/> parameters not set correctly<c/>
or connection not established correctly. helpFile= helpContext=0 idofInterfaceWithError={8BDFE893-E9D8-4D23-9739-DA807BCDC2AC}
StackTrace: at Microsoft.... The package execution fa... The step failed.,00:09:54,0,0,,,,0
Pl help
Create user failing because the login is already mapped to different user, Delete the user first then create login should work. Make sure you assign correct\permission role to copy database.
EnjoY!
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply