July 26, 2010 at 2:55 pm
inherited a sql 2008 server that was setup already. Trying to get database mail to work. The account that the database mail is setup is a domain and admin of the sql 2008 box and instance. I configured my mail the same as my other 2008 boxes, but when I try to run a test through the GUI or through QA it tells me the mail is queued but when I look at the log I get
The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 1 (2010-07-26T15:42:35). Exception Message: Cannot send mails to mail server. (Mailbox unavailable. The server response was: 5.7.1 Client does not have permissions to send as this sender).
)
July 26, 2010 at 3:19 pm
Looks like an Exchange setup issue. Are you sure that the account being used for DB Mail has an Exchange mailbox created? You can't do anything without that if the Exchange server requires authentication/a mail-enabled account.
July 27, 2010 at 7:42 am
It is the same account my other 2008 and 2005 servers use, the difference is I used this exact account for the service accounts for sql server on myohter boxes. This one is using a different account for the service account
July 27, 2010 at 8:34 am
timscronin (7/27/2010)
It is the same account my other 2008 and 2005 servers use, the difference is I used this exact account for the service accounts for sql server on myohter boxes. This one is using a different account for the service account
So is this the same account or a different account? You just said both things in this post.
July 27, 2010 at 8:38 am
On this box the service and mail accounts are different
July 27, 2010 at 11:12 am
Are you sure that the mail account is set up in the mail server correctly? You're getting a mailbox access error; if this were Exchange, I would assume that the account doesn't have a mailbox created or doesn't have access to it or something like that. It's not an error on the SQL end if you have the setup done correctly.
July 27, 2010 at 11:51 am
Yes because this account works for all the other servers we use it on
July 27, 2010 at 11:55 am
OK, you are not making any sense to me. You say "same account" and "different account" in the same breath, you say that the setup on this server is different yet it is the same on all of the other servers. Can you be very precise as to what is different on the server that is not working? Obviously something has to be different or it would not be failing. At this point you have been so non-specific as to what is "account" in your descriptions that I don't think I can understand your situation enough to offer any advice.
July 27, 2010 at 11:59 am
All previous servers I setup used service account "A" for the SQl Server Services. This account also had an exchange account and has always worked. The new server that the vendor setup is also on our domain but used a different account for the sql server services. THis account, let's call it "B" does not have an exchange account. When I setup the the DB mail on this new server I used account "A" which is both sysadmin and admin on the box. This is the account I can't get DB mail to work on
July 27, 2010 at 12:21 pm
So I assume then that you are using Basic Authentication with the user name and password? If you use Windows Auth it WILL use the SQL Server service account.
Can't find any documentation on Exchange with basic authentication, but I am pretty sure that this isn't Kerberos-based authentication. Could be that the user isn't set up to hit Exchange without Kerberos, but that is pure speculation. Hard for me to say as it is pretty clearly an Exchange error. You probably will need to work with the Exchange group to resolve it. You may well have it all set up in SQL correctly and Exchange needs to be configured.
Viewing 10 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply