October 22, 2002 at 3:01 pm
We have a job that runs XP_sendmail procedure and sends me result of query. SA owns this job and it used to run fine.
Few days ago we moved our mailbox which sends mail for sqlserver. I had to create and reassign new mail profile to user which starts sql server and I also changed profile to be used in sql server. All server seems fine but just this one where we have this job doesn't use xp_sendmail anymore. Comes with message "Access denied". I can still send test email to operator and also when any other job copletes.
I tried giving full path of Database and tables in query still didn't work.
Does anyone know what could have happened?
Thanks.
October 22, 2002 at 3:18 pm
Ensure that the service account running the SQL Server Agent service on the server you are having trouble with has permissions to select data from the tables you are attempting to access through the job.
Sincerely,
Mark Cudmore, MCP
Sincerely,
Mark Cudmore, MCDBA
October 22, 2002 at 3:38 pm
Do I really need that? I don't even have this service account as DB user for Db that I am selecing from. It was always like that and never had problem in selecting this data. Thanks.
October 23, 2002 at 12:32 am
Go to Support Services from EM and check if the mail profile is configured as the SQL Server uses sqlmail rather than the SQLagentmail which you have been checking. Ensure that it is running under the right a/c. And then your problem must be done.
Arvind
Arvind
October 23, 2002 at 6:51 am
Checked Support service, it's using same profile as the one in startup account. I tried to TEST from there and test was successful also. Don't know what else could be wrong!
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply