Copying databases between 2 ms sql servers via tcp/ip

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.

All Forums

SQL Server 2000 Forums

Import/Export (DTS) and Replication (2000)

Copying databases between 2 ms sql servers via tcp/ip

Author

Topic

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2002-09-17 : 13:18:18

Martin writes "Whenever i want to copy ms sql server databases between to ms sql servers on different machines to adapt the database state i get the error message:

Step Error Source: Microsoft Data Transformation Services (DTS) Package
Step Error Description:Unbekannter Fehler

Step Error code: 80004005
Step Error Help File:sqldts80.hlp
Step Error Help Context ID:1100

Has anybody an answer - idea what the problem is?

Thx
Martin"

Page47
Master Smack Fu Yak Hacker

2878 Posts

Posted - 2002-09-17 : 13:31:16

Ah, yes, the classic "Unbekannter Fehler" ...

You likely have the destination SQL Server started under a domain account that does not have local administrator privileges on the source computer. Read more from MS

Jay White
{0}

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources