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 |
|
koman888
Starting Member
2 Posts |
 Posted - 2003-05-13 : 03:23:33
|
| Problem:I am using Copy Database Wizard on SQL Server 2000 (running on windows 2000 server) to import a database from SQL Server 7 (running on Windows NT). It creates a 5 step DTS job. Step 1 (copy logins) and step 5 (copy database) failed. The error message from scheduler->job history->detail steps:Executed as user: xxxxx\xxxx. ...Executing... DTSRun OnStart: CDW Logins Task Step DTSRun OnError: CDW Logins Task Step, Error = -2147467259 (80004005) Error string: Unspecified error Error source: Microsoft Data Transformation Services (DTS) Package Help file: sqldts80.hlp Help context: 1100 Error Detail Records: Error: -2147467259 (80004005); Provider Error: 0 (0) Error string: Unspecified error Error source: Microsoft Data Transformation Services (DTS) Package Help file: sqldts80.hlp Help context: 1100 DTSRun OnFinish: CDW Logins Task Step DTSRun OnStart: CDW Master Task Step DTSRun OnFinish: CDW Master Task Step DTSRun OnStart: CDW MSDB Task Step DTSRun OnFinish: CDW MSDB Task Step DTSRun OnStart: CDW Errors Task Step DTSRun OnFinish: CDW Errors Task Step DTSRun OnStart: CDW Databases Task Step DTSRun OnError: CDW Databases Task Step, Error = -2147467259 (80004005) Error string. The step failed.I am unsure why it is failingBackground:The machines are on the same network but do not belong to a domain. They are stand alone computers just configured as workgroup.SQL Server on both machines are running under a NT account which has full system admin privilidges. The same account has also been created in both SQL Servers and given full system admin privilidges.Andrew |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2003-05-13 : 10:12:02
|
| Can you restore a backup instead?==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
koman888
Starting Member
2 Posts |
Posted - 2003-05-13 : 20:30:03
|
| hi nr,I could use backups/restore or detach/attach but I want to get 'Copy Database Wizard' to work because the process is suppose to be simpler and it transfers logins and server stored procedures which the other methods don't do.I have done some research and found this article.http://support.microsoft.com/default.aspx?scid=kb;en-us;305365This article explains to me why the first step fails. It appears that I won't be able to use the 'Copy Database Wizard' unless I'm in a Domain. Can anyone advise??AndrewEdited by - koman888 on 05/14/2003 01:22:40 |
|
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2003-05-14 : 11:58:35
|
| You could try sql-dmo to do the transfers - I don't know if it will copy logins but probably will.There is an example script atwww.nigelrivett.comDMO transfer==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-05-14 : 14:20:33
|
quote:
I have done some research and found this article.http://support.microsoft.com/default.aspx?scid=kb;en-us;305365This article explains to me why the first step fails. It appears that I won't be able to use the 'Copy Database Wizard' unless I'm in a Domain. Can anyone advise??
If the article says you can't do it, then you can't do it. Are your servers in workgroups? Why don't you just create a very simple domain with the two servers in it?Instead of using the copy database wizard, use the backup/restore or attach/detach as nr suggested. Then you can run a stored procedure that I wrote to transfer the password (search the forums on isp_Transfer_Passwords, one of the threads will explain what to modify), then run chadmat's sp_change_users_login script (in the script library section of sqlteam). This is so much better/flexible than the copy database wizard, and you won't get that error that you keep getting because you aren't in a domain.Tara |
|
|
|
|
|
|
Copy Database Wizard