SQL: Export tables across servers

[Lisa]

Here is a question from a Train Signal customer who is training with our SQL Server 2008 Administration course:

I’ve been enjoying your DVD on SQL 2008 administrator DVD.

On video 13: Performing Data Management Tasks, you mentioned how to do exporting tables.

I was able to export tables from one server to another, however when I put the SSIS in job/step, it has error of: unable to determine if DEV1/administrator has server access.

I don’t know where to set up the server access. The expert table task can be done at both directions manually, why it complains when put into jobs?

[Mel]

Simply based on the names you used I would guess that DEV1 is a computer and not a domain. If that's the case then the account you are using would not be viable on the network. When dealing with multiple SQL servers communicating across a network you are typically in a domain environment and working with domain accounts. Also of course make sure that logins for the domain accounts (or domain group containing the domain accounts) have been created in each SQL server instance.