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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-11-05 : 07:42:04
|
| Gary writes "I get the following error when using the Copy Database Wizard from a 7.0 server to 2000. I figure this is some kind of authentication error but I just can't figure out where. EM is registered under the SA account for both servers and the SQL Server and Agent are running under Administrator.Any Ideas?Thanks!Gary Failed to created the share OMWWIZEStep Error Source: Microsoft Data Transformation Services (DTS) PackageStep Error Description:Unspecified errorStep Error code: 80004005Step Error Help File:sqldts80.hlpStep Error Help Context ID:1100" |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-11-05 : 12:18:01
|
| This is one of the reasons why I try to avoid DTS and the copy database wizard. They don't provide very helpful error messages. It could be a number of things. But probably it is just that the service accounts for your SQL Servers is using the local system account. They should be using domain accounts that also have local admin rights on the boxes.Why are you using the copy database wizard? Why not use BACKUP/RESTORE or DETACH/ATTACH methods? These methods are very fast and reliable as compared to the copy database wizard.Tara |
 |
|
|
|
|
|
Copy Database Wizard