SQLMail & SQLServerAgent mail problem
-
I have a machine where MSSQLServer and SQLServerAgent services both run under the local Administrator account. I have a mailadress for this login, which works fine when using Outlook 2000 to send mail. Setup SQL Mail using the MS Exchange profile and this works fine as well, I can send mail using xp_sendmail.
Now I wish to setup the SQLAgentsMail. Again I choose the MS Exchange profile, but now the test results in:
Logon Failed: MapiLogonEx Failed due to MAPI error 273: MAPI Logon
Failed.
I have Googled the Internet and came up with a few similar questions, but no answer. What is wrong here? Have I missed something?
Any help apreciated,
Greetz,
Hans Brouwer -
You'll need to alter the service-accounts for sqlagent and sqlserver to a windows-account that has access to your mail-server and mailbox.
afaik local administrator has no network authority
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data/code to get the best help[/url]- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
-
But it has. SQLMail works fine.
Greetz,
Hans Brouwer -
did you stop and restart sqlagent ?
(should not be an issue, but you never know)
btw, I mostly use smtp-mail (http://www.sqldev.net)
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data/code to get the best help[/url]- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
-
I did stop&restart the agent. Even had the server rebooted
I have looked at other smtp ways of sending email, but the ppl I have to work with are very conservative/carefull and will not allow unproven(!) technology on their servers.
And, ofcourse, it does not tell me why this problem occurs.
Greetz,
Hans Brouwer -
Does sqlmail also work when you have a remote sql-connection (not on the server itself) ?
What 's the sql-version (and sp / hotfix) ?
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data/code to get the best help[/url]- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
-
SQL2K with sp3a, W2K OS with the latest patches.
If you mean with remote-sql: does xp_sendmail work when I have opened QA on my pc and exec it, yes, it does work.
We have 2 SQL Servers configured for emailnotifications, both are identical in config.
We can work with just SQLMail running, but it is a nuisance to add a exec xp_sendmail in every job when something goes wrong.
Greetz,
Hans Brouwer
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply