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.
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? |
|
|
|
|
|