June 11, 2003 at 4:23 am
Hi There,
I've started in a new company and have been left to be the only DBA. Not much of a handover - great! Anyway... SQL Mail is not working on the production server. A profile has been set up on the server (using an internet email server). It all looks to be correct but when you click on the 'test' button through ent manager, it hangs.
I'm pretty confused! I have heard that you have to log onto the server as the exact account which the SQL Agent Service runs on. On the properties, it says the server startup account is .\SQLUSER with password. I have never seen anything where it starts with .\ before. I dont know if this is causing me the problem or not... would anyone imagine it would??
Also, I am connecting through terminal services, would it be likely to cause me problems??
If anyone has any advise, I would be extremely grateful!
MH
June 11, 2003 at 9:20 am
I would try changing the startup to be <domain>/SQLUSER. Make sure this connection has rights to the email feature. This would allow you to "log on" and perform the tests.
HTH
Guarddata-
June 11, 2003 at 10:53 am
.\ is the local machine, so it is using an account on that machine as opposed to the domain.
Steve Jones
June 12, 2003 at 1:24 am
SqlMail works with MAPI 1.0
http://support.microsoft.com/default.aspx?scid=kb;EN-US;311231
June 12, 2003 at 2:21 am
Try loading MS Outlook on the server (Outlook 2000 for SQL Server 2000), and set up an Mail Profile for the login which the Server Service uses. You can then test the MAPI separately. Now select that Mail Profile and test. Remember that if any changes are made to the MAPI settings you must restart the SQL Services to activate.
If you are still struggling, and only require out-going mail, you could try using SMTP through CDO. See Clinton Herring's SMTP Mail Stored Proc at http://www.sqlservercentral.com/scripts/contributions/510.asp.
June 12, 2003 at 2:43 am
Thanks for all your help with this one. I finally got it working. I logged on as the same account running SQL Service directly on the server. Created a new Internet Email profile using Outlook. Then restarted the server, and restarted SQL Mail, did the test, and it worked... it only took me all day!! Thanks again, MH
June 23, 2003 at 8:38 am
FYI -
We don't install Outlook on our servers because of the associated security patch problems, but I ran across some freeware a little while back that sends e-mail without using Outlook or SQL Mail.
Here is a link to the site:
http://sqldev.net/xp/xpsmtp.htm
Jon
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply