jobs and packages failing

[Jesus4u]

I am finished with my project and all I need is to figure out this error so please help.

We have 2 servers. One webserver with sql2000 at a remote location accessed thru VPN and another on the local network with same configuration.

On the local machine I scheduled a package to upload TableA to the remote sql server every hour. BUT when the job runs it FAILS because it says that:

"Error string: Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection. Error source: Microsoft OLE DB Provider for SQL Server Help file: Help context: 0 Error Detail Records: Error: -2147467259 (80004005); Provider Error: 18452 (4814) Error string: Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection. "

Now I know that this means that the remote server it is connecting to is rejecting my login. But this job is executing a package on thje LOCAL machine that in turn is uploading data to the remote machine. The package runs successfully without the schedule but not with a schedule.

Can anyone help me out please?

Thanks


Exams Passed: 70-152, 70-175, 70-176, 70-100

 

[red54]

Not a for 100% sure, but have found that when I get that msg it means that the connection is not using a valid username and password on the remote system. Try setting up the connection using sa and the sa password. This has fixed it for me on several occasions. This is when using Sql Server authentication in the odbc set up.

Hope this helps.

Time flies when you don't know what you're doing...