I have set up a DTS package. When I ran the package manually, it went well. But when I schedule it, it had this error. I read some postings and articles about SQL agent account. So I have set SQL agent account as a local system admin in that Win2k3 box and system admin in SQL Server 2k. It does not help as all. By the way, I also tried agent proxy account also.
Step Error Source: Microsoft OLE DB Provider for SQL Server
Step Error Description:[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.
Step Error code: 80004005
Step Error Help File:
Step Error Help Context ID:0