DTS won't copy permissions
-
"Login already has an account under a different name" is the error I get when I try to DTS a complete database to a backup database. It's on the same server.
Note that all objects are being copied. Also, we use ROLE and also public permission on some items.
What is causing this error?
-
Using NT or SQL logins? Using the Copy DB Wizard or actually DTS'ing the tables?
Andy
-
Andy, I'm on SQL2000 doing TRANSFER OBJECTS (all). It works on all other databases but this one and I wonder if it's because it has some PUBLIC permissions.
-
I dont think role membership matters. Do you already have users in the db you're transferring too? If so you need to remove them or just not move them the next time copy.
Andy
-
On exporting all objects, I don't see where you'd mark where NOT to copy users. Actually, I'd want to transfer user perms too. In the backup database, I created a new database with nothing in it. So, no, there's nothing preexisting in permissions. The tables copy, etc but no data..and that's when I get the error message.
-
NT LOGINS are used. I'm still getting the errors on this one database. HELP!
-
Ok, it still gets errors when I unmark all permissions under Security options.
-
OK, I think I found the problem. This database creates user-owned tables and if I de-select them, do the DTS without any perms, add perms later as a script, then it copies. Thanks for advising to not include perms.
Viewing 8 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply