I have a SQL Job running in SQL 2005. This job has 6 steps. In one of the steps, I SELECT from a View. This View is pulling data from a different server. When we login as sa and run queries manually, we can pull the data just fine. When we try to do this in a job, it fails, because of the authentication to the other server. Have you done anything with trying to run a job that connects to a different server?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
SQL 2005 job connecting to remote
- Thread starter jepatte
- Start date
Similar threads
- Locked
- Question
- Locked
- Question
