May 15, 2003 at 7:48 am
Hi all,
Could you pls Help out what are steps(in detail) to be followed for configuring SQL Mail.
I have a windows 2000 server with exchange server.
I have followed sql server help.But error is throwing when i give profile name in EM-->Support services->sql mail. "failed with mail server".
pls help me on this...
Thanks
May 15, 2003 at 8:04 am
SQL Server service and agent account service should be running under the same account as you have for the email account. Once that is set, logon to the server under the service account and set up your profile. Modify the SQL Server Agent and SQL mail configurations to point to that profile and you should be all set.
A quick sanity check is to launch Outlook while logged on to the server and verify that the profile you established is working through Outlook. I have found if that works, and the above is done, that things will work fine.
Hope this helps.
David
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
May 15, 2003 at 4:32 pm
To clarify DavidB's answer:
Both the SQL Server service and SQL Agent service must be running under a named account (not LocalSystem). It may be the same account for both services, or separate accounts.
If you need to connect to an Exchange server, you'll want to use a domain-based account for both services. If you're using a POP3/SMTP server, then a local account will suffice.
And definitely test the profile(s) via Outlook as DavidB suggested. Once SQLMail and SQLAgentMail are configured, be sure to test via an Operator (SQLAgentMail) and using xp_sendmail (SQLMail).
David R Buckingham, MCDBA,MCSA,MCP
May 15, 2003 at 4:47 pm
One more tidbit I remembered. Keep your profile name short. There is a known bug regarding long profile names. I believe it rears it's ugly head when the profile name is more than 31 characters long (but it may be 30 or 32...can't remember for sure).
For simplicity's sake, I tend to name the profile the same as the account for which it is intended to be used by (as an example: DOMAIN1\SQLAcct03's profile name would be simply 'SQLAcct03').
David R Buckingham, MCDBA,MCSA,MCP
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply