DTS Execution Error in SQL server 2000..please help asap

Hi,

when i execute a dts to copy one database from one server to another i am getting the following error:

[Microsoft][ODBC SQL Server Driver][SQL Server]OLE DB 'SQL OLEDB' reported an error.Authentication Failed.
[Microsoft][ODBC SQL Server Driver][SQL Server]OLE/DB provider returned message: Invalid authorization specification]
[Microsoft][ODBC SQL Server Driver][SQL Server]OLE DB error trace [OLE/DB Provider 'SQLOLEDB' IDB Initialize: Initiliaze returned 0x80040e4d: Authentication failed.].

Please help me solve it.

DTS questions should be redirected to the DTS group: http://groups.google.com/group/microsoft.public.sqlserver.dts?lnk=sg

DTS execution error

when i execute a DTS to copy a database from one server to another, I am getting the following error:

[Microsoft][ODBC SQL Server Driver][SQL Server]OLE DB 'SQL OLEDB' reported an error.Authentication Failed.
[Microsoft][ODBC SQL Server Driver][SQL Server]OLE/DB provider returned message: Invalid authorization specification]
[Microsoft][ODBC SQL Server Driver][SQL Server]OLE DB error trace [OLE/DB Provider 'SQLOLEDB' IDB Initialize: Initiliaze returned 0x80040e4d: Authentication failed.].

Can somebody please help?

I understand you run DTS Import/Export wizard in SQL 2000; if it is true i think you entered in Windows with an account that can not log on that SQL Server (that windows account have not a login in SQL Server ).
Check this problem|||NO I am not using an import export wizard.it is a copy sql server objects task which is being used

DTS Copy SQL Server

hello all
i have problem with dts copy sql server
error : [Microsoft][ODBC SQL Server Driver][SQL Server]Windows NT user or group 'TCW\Administrator' not found. Check the name again.
thx b 4I think you need to be a wee bit more specific...

But here goes...

sounds like you're trying to copy data to another server from your server, and the other server is set up as windows only security...AND your system account is not on the domain...

sound close?