December 18, 2003 at 7:54 am
Hi,
I tried to setup SQLagentmail on a SQL2K with SP3a box. That SMTP account works in Outlook, however not in SQL. It says the notification has been sent successfully, but I never received it. Anyone has any ideas?
Thanks
December 18, 2003 at 10:04 am
When you say the account works in Outlook, are you logged in with the same domain account as SQL? In Outlook, are you seeing the message bounce back as undeliverable?
Brian
December 18, 2003 at 12:42 pm
Yes. I logged in as the same account. When I sent a test message in SQLagentmail, it didn't go out until I stopped SQLagent service.
Thanks
December 18, 2003 at 1:06 pm
Xujohn, Just a few questions...
1. One you have under the SQL Server Agent properties tab have you set the default mail profile to be used?
2. Did you stop and restart your services?
3. Also is Outlook Defined as your Default for IE?
4. Next I assume you are able to run xp_sendmail command and get the results?
Jim Babington
Jbabington
Jbabington@hotmail.com
December 18, 2003 at 2:07 pm
Jim,
The answer is Yes to your questions 1-3. When I used xp_sendmail,I got the following message:
SQL Mail session started.
Server: Msg 18025, Level 16, State 1, Line 0
xp_sendmail: failed with mail error 0x8004011d
Thanks
December 19, 2003 at 8:49 am
Xujohn,
A tad confused but also are you running Outlook for Office 2000 (2003, XP) when you attempt to start the mail service with xp_startmail? Have you attempted to start the mail service it self with the xp_startmail option? I had a Admin install Outlook from a Office Xp CD and man it was a @#$&@… Also what version of Outlook ( I use MS Outlook 2000 SR-1 (9.0.0.3821) ?
-- This start mail option will use the agent profile information
USE master
EXEC xp_startmail
-- This start mail option will use your profile information (if you have it)
USE master
EXEC xp_startmail 'xujohn', 'xujohn!'
If the first xp_startmail option works then the connection / profile isn’t the issue. If the second option works then it’s the primary (first) profile… Again I assume that the Mail profile is a Domain Account etc?
FYI info: http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q263556
Jim Babington
Jbabington
Jbabington@hotmail.com
December 19, 2003 at 9:35 am
Jim
I installed Outlook2003 professional on that box(I used to use Outlook2000 with any issue). Also, the interesting is that, after I start SQLAgent service, I couldn't open Outlook any more, saying pst file is in use; When I stop SQLagent service, then I can open it, and the test message that got stuck there is sent out. BTW, the XP_startmail works for me.
Thanks again for your time.
December 20, 2003 at 1:23 pm
xujohn,
I have had similar problems before setting up mail with SQL. There are some really good support papers at support.microsoft.com if you use SQL 2000 and mail.
Also, you may want to read up on SQL 2K with Exchange. There are additional setting changes that have to be made on the Exchange server to allow SQL 2k to send mail (If you also use Exchange).
Good Luck!
AJ Ahrens
Good Hunting!
AJ Ahrens
webmaster@kritter.net
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply