Do I need this server to be connected to or be part of the Exchange Server in order for DB Mail to work?

You're sending an email from an address not authorised on your mail server. You will need to speak to our mail server admin to identify a valid email address for your domain.

relaying is forwarding/sending to email addresses that are not administered by the specific server you are conecting to...for example, if my server is the google's gmail, then emails to @sqlservercentral-com would be relayed from gmail to SSC; emails @gmail.com are on that server, and just go thru standard spam filtering before being delivered.

the default settings of any mail server are designed to prevent the server from being able to relay "spam"

to avoid all those viagra and male enhancement pills and stuff like that, a mail server is set up typically only allows relaying in two situations.

1. If using anonymous authentication, only mail coming from IP addresses already placed in the white-list get to relay; this is typically where the IP address of the webserver(or in this case, a SQL Server) has been added to the list of permitted machines. That's where you get with the administrator of the mail server, to add your IP.

A lot of times the server allows any machine on the internal LAN to relay by default.

2. instead of anonymous authentication, you use basic authentication, and provide a username and password. Because you are an actual user, In that situation, the mail server usually allows relaying. some servers require both...an account and also the IP address to be on the "white-list" of allowed machines

try switching to use a valid account first, instead of anonymous authentication. if that fails, get with your mail admin.

i tried the googlemail way and got this error message.

The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 2 (2012-10-22T14:47:52). Exception Message: Could not connect to mail server. (A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond 173.194.79.16:587). )

So why is the googlemail way still erroring out? i made sure the login credentials were correct.

now, what i failed to mention about is even though this server is for one company, the mail server is on one domain while this is on a different domain. Could that be the reason why I can't send out DB mails from this server? I have not contacted anyone from tech support to see if they can include this server IP on the white list.

Hi everyone, i'm still trying to resolve this issue. I submitted a ticket to my mail server admin but have not heard back from them. Do I really need to get this server synced up with the mail server in order for it to work? I thought DB Mail in SQL 2008 can function independent without having to interact with the Outlook Exchange server?

As mentioned above using the gmail SMTP server resulted in an error for me.

No, the google mail server will not relay mail for your domain.

Db mail merely moves the mail profile from the mail server to the sql server. You still need to route through a mail server that is authorative for your domain.

give server name as smtp.gmail.com and check the ssl.

Try the below link.

http://blogs.msdn.com/b/suhde/archive/2009/07/12/how-to-configure-sql-server-database-mail-to-send-email-using-your-windows-live-mail-account-or-your-gmail-account.aspx

You can only route your mail through google mail or windows live if you have a gmail or live account. You will not be able to route email for dbaalerter@Fredblogs.com through the Live or Gmail servers, they will actively reject it!!!!

After speaking with the help desk they informed me that they set up this server differently than all the others in the domain. Even there's no local firewall on the server, there put a block on certain ports from from the global firewall. They asked if using the company's SMTP server name will resolve the issue and it did.