Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 SSIS and Import/Export (2008)
 Unable to run SQL Server Agent 2008 on Network Ser

Author  Topic 

vick44
Starting Member

1 Post

Posted - 2011-06-17 : 00:16:00
I am trying to schedule a job on SQL Server agent 2008 which fetch the data from the other server through Linked Server. While executing the particular package I am getting exception for authentication.
The package is executing just fine but while trying to schedule the job , SQL-server agent get stopped. I also try using sql server authentication .

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2011-06-18 : 00:22:02
What error messages are u seeing in SQL Server and Event Logs?

SQL Agent acccount is a domain account, able to authenticate with AD?
Go to Top of Page
   

- Advertisement -