Tuesday, March 27, 2012

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

No comments:

Post a Comment