I have a quesry which uses linked server calls to another server forretrive information, and send it as an attachment to recepients using xp_sendmail.
After service pack 3, the query doesn't send the info to recepients anymore.
The error says something like"the setuse doesn't have access to the linked server".
This is running as a job in sql server. The account which starts the sql server and agent has a sysadmin permission.
The account which runs this job is the account which starts the linked server as well(from where I am trying to retrive information)
I don't know whether its something to do with the SP3 or SP3 was just a coincidence.
I can get around it by retriveing the info put it into a file and then run xp_sendmail to send the file instead of running the query and sending the attachment...
Any thought.
Any suggestions...
Did anybody have the same problem after sp3..
After service pack 3, the query doesn't send the info to recepients anymore.
The error says something like"the setuse doesn't have access to the linked server".
This is running as a job in sql server. The account which starts the sql server and agent has a sysadmin permission.
The account which runs this job is the account which starts the linked server as well(from where I am trying to retrive information)
I don't know whether its something to do with the SP3 or SP3 was just a coincidence.
I can get around it by retriveing the info put it into a file and then run xp_sendmail to send the file instead of running the query and sending the attachment...
Any thought.
Any suggestions...
Did anybody have the same problem after sp3..