Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 1234»»»

SQL 2000 and Setting up SQL Mail Expand / Collapse
Author
Message
Posted Tuesday, July 3, 2001 11:10 AM


SSChasing Mays

SSChasing Mays

Group: Moderators
Last Login: Wednesday, July 23, 2014 1:21 PM
Points: 609, Visits: 407
I am at my wits end with this. I know mail setup is easy. I setup the mail profiles and operators the test run everytime but when a scheduled job or backup is suppost to email me it won't. I get mapi errors and nothing comes down to me. Anyone else having mail problems?





http://www.sqlserverio.com
http://www.cactuss.org
http://www.salssa.org
Post #500
Posted Tuesday, July 3, 2001 1:54 PM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: Moderators
Last Login: Tuesday, August 12, 2014 10:53 AM
Points: 6,783, Visits: 1,876
What about if you try to send using xp_sendmail, does that work?



Andy
SQLAndy - My Blog!
Connect with me on LinkedIn
Follow me on Twitter
Post #19722
Posted Tuesday, July 3, 2001 2:28 PM


SSChasing Mays

SSChasing Mays

Group: Moderators
Last Login: Wednesday, July 23, 2014 1:21 PM
Points: 609, Visits: 407
Yep... Its a known bug with sql 2000 I applied sp1 to my dev box and all is well now. It wasn't sending reports from backups but not failing the final step ether. I did some digging about a month ago on it and didn't see anything about it. Oh well.





http://www.sqlserverio.com
http://www.cactuss.org
http://www.salssa.org
Post #19721
Posted Tuesday, July 3, 2001 6:07 PM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: Moderators
Last Login: Tuesday, August 12, 2014 10:53 AM
Points: 6,783, Visits: 1,876
I will have to look at the fixlist - kinda big to remember it all! I haven't had much problem with email.

Andy



Andy
SQLAndy - My Blog!
Connect with me on LinkedIn
Follow me on Twitter
Post #19720
Posted Thursday, July 5, 2001 11:31 AM


SSChasing Mays

SSChasing Mays

Group: Moderators
Last Login: Wednesday, July 23, 2014 1:21 PM
Points: 609, Visits: 407
It is friggin HUGE. its like 300 fixes rolled into sp1. I did fix alot of little things I was worried about in our test lab.



http://www.sqlserverio.com
http://www.cactuss.org
http://www.salssa.org
Post #19719
Posted Thursday, July 5, 2001 11:51 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 3:06 PM
Points: 33,169, Visits: 15,304
No problems here. I get notifications from job failures as well as xp_sendmails that I schedule.

What is your mail setup? Do you have Exchange (version?), Outlook (version). Is this in a domain, what accounts are SQLAgent and SQL Server running under (local, rights, etc.).


Steve Jones
steve@dkranch.net







Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #19718
Posted Friday, July 6, 2001 12:40 PM


SSChasing Mays

SSChasing Mays

Group: Moderators
Last Login: Wednesday, July 23, 2014 1:21 PM
Points: 609, Visits: 407
All my mail problems went away after applying sp1. we run exchange2000 fully patched the mapi client is outlook2000 sp1 and the account it a domain account with full mail rights. Scheduled jobs send mail but backup reports never made it and never generated an error. One problem I do have is when I try to use the contacts list instead of a regular email address i get a mapi resolution error from sqlserveragent. i.e. in outlook you can just use a name like john doe that doesn't resolve but john.doe@mynetwork.com does. I haven't setup reporting to groups yet ether so I don't know if it will send to outlook list yet or not.





http://www.sqlserverio.com
http://www.cactuss.org
http://www.salssa.org
Post #19723
Posted Thursday, July 12, 2001 8:58 AM


SSChasing Mays

SSChasing Mays

Group: Moderators
Last Login: Wednesday, July 23, 2014 1:21 PM
Points: 609, Visits: 407
Ok here we go again. After applying sp1 to the test server it sends mail fine. I applied sp1 to three servers last night all of them configured the same and they still only send mail from xp_sendmail,job alerts but not from backup notifications. The Q article said that this was fix in sp1 and did seem to fix it in test but not production. Any other ideas what could be wrong? I've got a mapi client outlook2ksp1 on every box they all use the same domain account to start sqlserver/sqlagent and use the mail profile in outlook to send mail. When I do go to operator -> properties and select a name from the contacts list I get a mapi error of -2147219712 I can't find this error anywhere on MS's site. I don't know what else to do but maybe put a call into ms support at this point. I've run sqldiag and compared the dumps to the only machine that does run against the others that don't and they all look identical.

Wes



http://www.sqlserverio.com
http://www.cactuss.org
http://www.salssa.org
Post #19731
Posted Thursday, July 12, 2001 11:54 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 3:06 PM
Points: 33,169, Visits: 15,304
If you can, log into the production boxes iwth the SQL Agent account and verify you can send and recieve mail. something may have been lost.
Then log out and restart the SQL Services (or reboot) and then try it again.
BTW: Is the SQL Server and SQL Agent account the same?

Steve Jones
steve@dkranch.net







Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #19732
Posted Thursday, July 12, 2001 1:41 PM


SSChasing Mays

SSChasing Mays

Group: Moderators
Last Login: Wednesday, July 23, 2014 1:21 PM
Points: 609, Visits: 407
Ok, I can send and recive mail from the outlook client. I stopped and restarted the services I attempted to send mail via xp_sendmail and get this

Server: Msg 18025, Level 16, State 1, Line 0
xp_sendmail: failed with mail error 0x80070005

I'm at win2k sp2 sql2k sp1 outlook2ksp1. I'm rebuilding the test box now to see if there is something diffrent with the test and production configs. I don't think so though.





http://www.sqlserverio.com
http://www.cactuss.org
http://www.salssa.org
Post #19729
« Prev Topic | Next Topic »

Add to briefcase 1234»»»

Permissions Expand / Collapse