Configure SQL Server 2008 R2 for database mail

I've never done this before and am having difficulty getting it to work.

I've gone into msdb and added my login to the DatabaseMailUserRole ensured that I have Execute permissions to the sp_Send_dbmail stored procedure.

I then went into the Management => Database Mail and tried to configure the account, but I think this is where I screwed up.  I'm not the Exchange manager in our office and he is unavailable this week, so I would appreciate it if someone could provide me with instructions for how to fill in the various fields on this form.email accountI'm honestly unsure how to  fill in the Outgoing SMTP fields.  Should I enter my (sqladmin) email address and display name?  
Where do I get the "Server name" field?
How do I verify whether Port number 25 is open

I'm assuming that I would check the Windows Authentication, which is what the SQL Server uses, but don't know for sure.
LVL 50
Dale FyeAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

RantCanSr. Systems AdministratorCommented:
The main problem that you are going to have is whether or not the exchange server is configured with a receive connector that can take mail traffic from your database server. Concomitantly, you need to know if your exchange server is configured for anonymous relay from internal IPs or not, as this will determine the connection credential (or lack thereof)

The rest of the fields are going to be environment specific for your domain, so I doubt the experts will be able to provide valid values for these.
0
RantCanSr. Systems AdministratorCommented:
Let me try these questions individually.
I'm honestly unsure how to  fill in the Outgoing SMTP fields.  Should I enter my (sqladmin) email address and display name?
Outgoing email address can be a mailboxed account in the domain, or not. It could simply be "DBServer@yourdomain.com" with no mailbox attached.

Where do I get the "Server name" field? This is the name of your exchange server. Check your outlook settings on your desktop. It might be there.

How do I verify whether Port number 25 is open I assume you mean on the database server? Use the command prompt. Type telnet "server ip" 25

if it is working you will get a 250 OK response. Here is a more detailed explanation: http://dbatasks.blogspot.com/2012/11/troubleshooting-database-mail-part-ii.html

I'm assuming that I would check the Windows Authentication, which is what the SQL Server uses, but don't know for sure.
WIndows Auth allows domain credentials to authenticate and manipulate a SQL instance. IF YOUR EXCHANGE SERVER allows anonymous authentication, use that.

Your exchange admin would be able to answer all of these questions very quickly.
0
ZberteocCommented:
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Cloud Class® Course: CompTIA Healthcare IT Tech

This course will help prep you to earn the CompTIA Healthcare IT Technician certification showing that you have the knowledge and skills needed to succeed in installing, managing, and troubleshooting IT systems in medical and clinical settings.

Dale FyeAuthor Commented:
OK, I was able to get ahold of my Exchange guy and he gave me what he thought were the appropriate settings.  But when I run the test message and check the sysmail_event_Log, I get error message:

The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 1 (2015-10-27T12:20:45). Exception Message: Cannot send mails to mail server. (Mailbox unavailable. The server response was: 5.7.1 Unable to relay).

So the question is, what mailbox is unavailable?  The email the Exchange guy told me to put in to the outgoing email address is the Outlook email account associated with my server login.  Is that correct?
0
ZberteocCommented:
You tried to send an email outside of your company domain. The exchange guy has to add your SQL server IP to the exchange server, I don't remember in what setting feature, in order to be able to send "outside" emails.

We had exactly the same issue at our company last week.
0
Dale FyeAuthor Commented:
Thanks, this was a great help.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2008

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.