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 |
|
learntsql
524 Posts |
 Posted - 2011-04-12 : 01:40:40
|
| Hi All,I have created linked server from A to B.I have written SP in Server A and fetches data from Server B.Well i am executing This SP from Server A SSMS but when i create the as SQL Agent Job and run Job is gettinh fail and says error message as"Cannot initialize the data source object of OLE DB provider "SQLNCLI10" for linked server".Please guide me.TIA. |
|
|
learntsql
524 Posts |
Posted - 2011-04-13 : 01:16:02
|
| Guys any ideas please |
 |
|
|
sagitariusmzi
Posting Yak Master
113 Posts |
Posted - 2011-04-13 : 04:59:49
|
| try to make string of your query and then execute that query using EXEC or EXECUTE sp_executesql |
|
|
|
learntsql
524 Posts |
Posted - 2011-04-13 : 05:06:11
|
| Thanks for your reply..what is the difference between those? |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2011-04-13 : 11:51:13
|
| Seems the SQL Agent service account doesn't have permission. |
|
|
|
Jahanzaib
Posting Yak Master
115 Posts |
Posted - 2011-04-17 : 08:20:07
|
| what is the service account of sql server agent and check this rights of this service account in sql serverRegards,Syed Jahanzaib Bin HassanMCTS,MCITP,OCA,OCP,OCE,SCJP,IBMCDBAMy Blogwww.aureus-salah.com |
|
|
|
|
|
|
linked server problem from SQL Agent