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 |
|
jgn1013
Starting Member
24 Posts |
 Posted - 2009-08-27 : 16:28:42
|
| I'm exporting a database from one SQL 2005 server to another 2005 server located on a different domain. I'm getting permission errors."The current user is not an owner of the selected database. This might cause some operations with this database to fail."Tried using 'SA' on the DataSource server and using a designated login for the destination server. Don't know the SA pwd for that server because it's a off site client. TIA |
|
|
Peter99
Constraint Violating Yak Guru
498 Posts |
Posted - 2009-08-27 : 16:31:26
|
| Backup the database on source and restore on destination |
 |
|
|
jgn1013
Starting Member
24 Posts |
Posted - 2009-08-27 : 16:32:34
|
| I figured it out, I'm going to export it to a new db in the destination server, or I could use your suggestion. |
|
|
|
|
|
|
Export Wizard help