Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
kirkeby
Yak Posting Veteran
57 Posts |
 Posted - 2001-11-28 : 09:36:10
|
| I am trying to copy a complete database (SQL7) to a new database on the same server so I can do some testing of new tables, sprocs, etc. The problem I am having is that when I do my export or import using the DTS wizard I get the following error (after a few minutes of nothing happening):[ODBC SQL Server Driver][SQL Server]User or role 'webview2' does not exist in this database.Now, webview2 is an old (and long since gone) user on this SQL server. It doesn't exist anymore. Why is it still looking for that user when it's been gone for months? I ran the DTS wizard (to do the same thing) a couple of weeks ago with no problem at all. Now, every time I try to do the exact same thing, I get the above error. Do I need to reboot my SQL server? I haven't tried doing it by command line because I simply do not know how. I have administrator rights on the server.Thanks for any help you can provide! |
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2001-11-28 : 14:29:30
|
| For some reason, it is finding an object that still references that old login, typically in its permissions. Rebooting your server might get rid of it. In the meantime, a work-around would be to create a dummy login with named webview2 on the destination server, do the DTS, and then remove the login.Another option is to check the OPTIONS in your DTS transformation. There is a place to un-check the option for transferring all of the users and permissions. Of course you would then have to re-apply all permissions on the new server.By the way, is this also a problem if you just do a backup of the database, copy the backup file to the destination, and then Restore From Device?-------------------It's a SQL thing... |
 |
|
|
kirkeby
Yak Posting Veteran
57 Posts |
Posted - 2001-11-28 : 16:05:33
|
| I re-created the logins and it finally worked! Thank you so much! |
|
|
|
|
|
|
|
|
DTS fails with ODBC error