SMTP and Email Subscriptions
-
I've searched high and low for an answer to this and haven't found anything that is of real help. I'm not an Exchange/SMTP guru so I'll just lay out my configuration and problem. I run SSRS 2005 Standard from a Windows 2K box w/IIS 5 (I believe) and a local SMTP service all on its own machine and domain. I'm aware that SSRS needs an SMTP service to relay emails. Our department has a group inbox on our Exchange server (Exchange 5.5) on a separate machine and domain. I've set the local SMTP service to relay to the Exchange server and be sent using our group account. Everything is set up as default (anonymous access everywhere, port 25, etc) and the email subscriptions are sent and receieved just fine w/in our domain (i.e. 'user@domain.com'). I cannot - however - get messages to go outside of the domain (i.e. 'user@gmail.com', 'user@yahoo.com', 'user@foreigndomain.com', etc). The messages just sit in the 'mailroot/queue' folder on the SQL server machine and the system event log has a bunch of event 4000 errors where the message says "...the remote server did not respond to a connection attempt" and I did notice 'Delay' emails from 'postmaster@ ' in our group inbox on Exchange. I have the local SMTP service set to send messages to a 'SmartHost' and have the IP of what I think should be the smarthost in brackets to avoid DNS lookup errors/time lag. I apologize - I do realize this is probably somewhat vague, but to me - the problem is vague. I'm hoping someone smarter than me can point me in the right direction and if you need more specifics, I'll do my best to provide them. Thanks in advance!
-
As usual - I seem to have fixed it myself and to help others - here'ss what I did. I simply checked the box that says "Attempt direct delivery before sending to smart host" check box in the SMTP properties box. LOL. I think my problem was I was assuming the mail item was created locally and relayed to our exchange server only to be relayed again using the group mailbox. With this in place - I'm not even sure I need the Exchange host listed in the 'Domains' but it's working now so I'm not gonna' touch it. Hope this helps!
-
chuggin, I know it's an old post but I hope you're still around.
I want to set up database mail. I have SQL Server 2008 running on Windows Server 2008 and an internet connection. That's it. (i don't have a mail application like Outlook installed on my server, for example.)
All I want is to get Database Mail working and I know I need to install SMTP. After that, is it all about getting the configuration right, in order to get Database Mail working?
Hope you're still on the forum. Thanks.
-
Yeah - it's deceptively straightforward. I'd NEVER done anything with SMTP and DB Mail (other than send test messages from an already built server) but I found myself having to set it up from scratch. It's actually very easy and the account setup in SSMS will help out a lot too.
-
it's very easy to set u, and you don't need your own SMTP server...just a valid email box somewhere that has SMTP/POP3 access...you can set up with a gmail account if you want. you just have to have the account and password so you don't get rejected for anonomous mail/spamming:
here's some info from gMail on setting up a client as an example so you can see the server name and port, which is different than the default 25.
http://mail.google.com/support/bin/answer.py?hl=en&answer=180189
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible! -
Bear with me please.... SMTP services are installed on the OS.
I have gone to Database Mail -> Configure Database Mail and put in these settings:
Account Name: TestAccount
Description: Test Account
E-mail Address: aitchk.candoo@gmail.com (a working gmail account)
Reply Email: aitchk.candoo@gmail.com
Server name: imap.gmail.com
Port number: 993
checked box: This server requires a secure connection (SSL)
Is this right so far and do I need Basic authentication? If so, which user name and password is needed here?
Thank you very much.
-
i think it needs to be smtp.googlemail.com, and port 465:
you need an account to send with(outgoing smtp);
the imap is to pickup/receive email.
i set up an account to confirm, registered "sqlnotifications@gmail.com":
this is a snapshot of my working settings: the only thing you should need to change is the gmail account/name.
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible! -
Thanks for hanging in there with me and for the snapshots.
Here are my settings:
Email address: aitchk.candoo@gmail.com (working gmail address)
Reply email: aitchk.candoo@gmail.com
Server Name: smtp.gmail.com
Port number 465
Basic authentication
Username: aitchk.candoo
Password: ********(password for gmail account)
I sent a test message from my comcast email account and it delivered to gmail just fine.
All 5 test emails from SQL Server 2008 on the Windows 2008 Server have failed.
Background:
1. I have enabled database mail using sp_configure 'Database Mail XPs', 1...etc.
2. Run this statement to determine the status of the last test email
SELECT * FROM msdb.dbo.sysmail_allitems
WHERE mailitem_id = 5 ;
returned a row which included the following info:
profile_id = 1
recipients = aitchk.candoo@gmail.com
copy_recipients = NULL
blind_copy_recipients = NULL
subject = Database Mail Test
body = "This is a test...."
body_format = TEXT
importance = NORMAL
sensitivity = NORMAL
file_attachments = NULL
send_request_date = 2010-06-28 09:07:04.817
send_request_user = <MY INSTANCE>
sent_status = failed
last_mod_user = sa
3. The Database Mail Log shows that the DatabaseMail process is started, but for each attempt to send an email there is a corresponding message: "The mail could not be sent to the recipients because of the mail server failure."
Will you please advise if the username/password combo is supposed to be from gmail. Additional advise would be appreciated. Thanks.
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply