Viewing 5 posts - 1 through 6 (of 6 total)
right,
limit permission to just Group
Thanks
end of a bad dream
June 17, 2015 at 5:12 am
Resolved with this command
grant execute on sp_send_dbmail to public
I hope it is the correct way
Thanks
June 17, 2015 at 3:55 am
yes,
are the first checks that I run,
for this reason I do not know where to look for the problem
June 17, 2015 at 2:41 am
Yes,
It includes this information,
I did two tests,
with my administrator account and with service account.
Error appears with both account
execute as user: my administrator account
execut user: sql service account
June 17, 2015 at 1:40 am
Thanks
yes, this is the configuration.
I gave permission to SQL Server Agent service account.
Now the error is
The EXECUTE permission was denied on the object 'sp_send_dbmail', database 'msdb', schema 'dbo'. [SQLSTATE 42000]...
June 16, 2015 at 7:03 am
Viewing 5 posts - 1 through 6 (of 6 total)