dbTalk Databases Forums  

Unable to create user error when using copy database task

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss Unable to create user error when using copy database task in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Rob Nicholson
 
Posts: n/a

Default Unable to create user error when using copy database task - 01-19-2009 , 06:13 AM






I'm trying to copy a database from one SQL 2005 server to another using the
copy database task in SSIS. The basic copy of the database appears to be
working fine but after the copy, the following error is displayed:

Error: The Execute method on the task returned error code 0x80131500 (ERROR
: errorCode=-1073548784 description=Executing the query "CREATE USER
[COMPANY\XYZ] FOR LOGIN [COMPANY\XYZ] " failed with the following error:
"User, group, or role 'COMPANY\InforMed - Employee' already exists in the
current database.". Possible failure reasons: Problems with the query,
"ResultSet" property not set correctly, parameters not set correctly, or
connection not established correctly. helpFile= helpContext=0
idofInterfaceWithError={8BDFE893-E9D8-4D23-9739-DA807BCDC2AC}). The Execute
method must succeed, and indicate the result using an "out" parameter.

COMPANY\XYZ is the Windows account used for access to this database. It's
exists as a login on the destination server but looking at the users against
the copied database, the user doesn't exist. In fact, manually running
Create User command on the database as query works fine.

Any ideas?

Thanks, Rob.



Reply With Quote
  #2  
Old   
Rob Nicholson
 
Posts: n/a

Default Re: Unable to create user error when using copy database task - 01-19-2009 , 09:02 AM






Quote:
Error: The Execute method on the task returned error code 0x80131500
(ERROR : errorCode=-1073548784 description=Executing the query "CREATE
USER
Later - this is a bug in the system somewhere fixed with SQL 2005 SP2. I
found a report of a similar problem which said that the "Create User" query
was been run against the master database and not the target database. This
bug was fixed in SP2 and appears to fix my bug as well.

Cheers, Rob.




Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.