Showing posts with label authentication. Show all posts
Showing posts with label authentication. Show all posts

Saturday, February 25, 2012

Database Mail SMTP authentication

I am trying to configure my database mail. It gives me this error when ever I try to send an email out of my domain:

The mail could not be sent to the recipients because of the mail server error.... Mailbox unavailable: The server response was: 5.7.1 unable to relay....

Any suggestions on how to fix this issues. I have read other posts here but not a definitive solution.

Thanks,

Hi Rob - You'll probably get more and better responses from another forum or newsgroup. This one is dedicated to SQL Server Notification Services, which despite the similar name, is not the same technology as Database Mail.|||

Thanks Joe,

Do you know which forum might I try to get an answer to this issue.

|||

Hi Rob. Did you ever get an answer to this question? I'm experiencing the same issues.

Thanks!

|||Relaying is not allowed at the most SMTP servers. It will have to be allowed for either an IPAdress as a source of relaying or as destination domains. These settings can be configured on the remote SMTP server. If its an external one, rather than an internal you are probably out of luck as most providers that only host mail addresses will not allow it.

Jens K. Suessmeyer.

http://www.sqlserver2005.de

Database Mail SMTP authentication

I am trying to configure my database mail. It gives me this error when ever I try to send an email out of my domain:

The mail could not be sent to the recipients because of the mail server error.... Mailbox unavailable: The server response was: 5.7.1 unable to relay....

Any suggestions on how to fix this issues. I have read other posts here but not a definitive solution.

Thanks,

Hi Rob - You'll probably get more and better responses from another forum or newsgroup. This one is dedicated to SQL Server Notification Services, which despite the similar name, is not the same technology as Database Mail.|||

Thanks Joe,

Do you know which forum might I try to get an answer to this issue.

|||

Hi Rob. Did you ever get an answer to this question? I'm experiencing the same issues.

Thanks!

|||Relaying is not allowed at the most SMTP servers. It will have to be allowed for either an IPAdress as a source of relaying or as destination domains. These settings can be configured on the remote SMTP server. If its an external one, rather than an internal you are probably out of luck as most providers that only host mail addresses will not allow it.

Jens K. Suessmeyer.

http://www.sqlserver2005.de

Database Mail SMTP authentication

SS 2005 Standard 64bit

I configured database mail and I suspect the SMTP authentication credentials are not being sent. Here are the two scenarios I have tried:

1) Use a local exchange server with basic authentication passing network credentials that have access to use the exchange service. I have a SS 2000 machine that is configure this way. Sending email to an address outside the domain fails with

"mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 1 (2006-08-25T14:02:23). Exception Message: Cannot send mails to mail server. (Mailbox unavailable. The server response was: 5.7.1 Unable to relay for ...."

I can send emails within the domain no matter what the credentials specified in basic authentication are, including invalid users.

2) Use a remote smtp server with basic authentication passing username (email address) and password, which fails with "The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 1 (2006-08-25T12:56:22). Exception Message: Cannot send mails to mail server. (Transaction failed. The server response was: 5.7.1 myaddress@.me.com: Sender address rejected: Access denied)."

any idears?

Hi,

I have the same problem, I can't even send emails within the domain.

Help Please!!!!

|||

You'll probably have more luck in another forum or newsgroup. This one is dedicated to SQLNS.

But for starters, try this link:

http://groups.google.com/group/microsoft.public.sqlserver.server/browse_frm/thread/fc3ca8d7d6589a0f/8c9a329972d2feeb?lnk=st&q=database+mail+sql+server+authentication&rnum=1&hl=en#8c9a329972d2feeb

HTH...

Joe

Database Mail SMTP authentication

SS 2005 Standard 64bit

I configured database mail and I suspect the SMTP authentication credentials are not being sent. Here are the two scenarios I have tried:

1) Use a local exchange server with basic authentication passing network credentials that have access to use the exchange service. I have a SS 2000 machine that is configure this way. Sending email to an address outside the domain fails with

"mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 1 (2006-08-25T14:02:23). Exception Message: Cannot send mails to mail server. (Mailbox unavailable. The server response was: 5.7.1 Unable to relay for ...."

I can send emails within the domain no matter what the credentials specified in basic authentication are, including invalid users.

2) Use a remote smtp server with basic authentication passing username (email address) and password, which fails with "The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 1 (2006-08-25T12:56:22). Exception Message: Cannot send mails to mail server. (Transaction failed. The server response was: 5.7.1 myaddress@.me.com: Sender address rejected: Access denied)."

any idears?

Hi,

I have the same problem, I can't even send emails within the domain.

Help Please!!!!

|||

You'll probably have more luck in another forum or newsgroup. This one is dedicated to SQLNS.

But for starters, try this link:

http://groups.google.com/group/microsoft.public.sqlserver.server/browse_frm/thread/fc3ca8d7d6589a0f/8c9a329972d2feeb?lnk=st&q=database+mail+sql+server+authentication&rnum=1&hl=en#8c9a329972d2feeb

HTH...

Joe

Database Mail SMTP authentication

SS 2005 Standard 64bit

I configured database mail and I suspect the SMTP authentication credentials are not being sent. Here are the two scenarios I have tried:

1) Use a local exchange server with basic authentication passing network credentials that have access to use the exchange service. I have a SS 2000 machine that is configure this way. Sending email to an address outside the domain fails with

"mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 1 (2006-08-25T14:02:23). Exception Message: Cannot send mails to mail server. (Mailbox unavailable. The server response was: 5.7.1 Unable to relay for ...."

I can send emails within the domain no matter what the credentials specified in basic authentication are, including invalid users.

2) Use a remote smtp server with basic authentication passing username (email address) and password, which fails with "The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 1 (2006-08-25T12:56:22). Exception Message: Cannot send mails to mail server. (Transaction failed. The server response was: 5.7.1 myaddress@.me.com: Sender address rejected: Access denied)."

any idears?

Hi,

I have the same problem, I can't even send emails within the domain.

Help Please!!!!

|||

You'll probably have more luck in another forum or newsgroup. This one is dedicated to SQLNS.

But for starters, try this link:

http://groups.google.com/group/microsoft.public.sqlserver.server/browse_frm/thread/fc3ca8d7d6589a0f/8c9a329972d2feeb?lnk=st&q=database+mail+sql+server+authentication&rnum=1&hl=en#8c9a329972d2feeb

HTH...

Joe

Friday, February 17, 2012

Database Login fails

Hi

I can logon to my Sql server using the SSMS management tool, I am using Windows Authentication to logon to SSMS. Create a database OK, with all the necessary tables.

However when I start a VB Express app and try to connect to this database I get an error that login filed for user AMD\Larry, AMD is my PC name and my login (Larry) is the computer Administrator logon. The PC is a standalone ie not part of a domain etc.

Can anyone help?

Regards.

Larry.

Hi Larry,

to solve you problem: in SSMS, connect to your database, go to Security, Logins, New Login, Add new login as AMD\Larry and give it right to access your database.

good luck

mario

|||Are you also using integrated Authentication in VB Express. Make sure that you don′t really *type* in the user as this will be recognized as a SQL Server login. Integrated login is done in the background and don′t have be typed in somewhere (I also mention that becasue many people are always confused about that)


HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

|||Thanks for these I wil try them and get back.