Sending Email Through SQL Server
I am trying to use the example at http://support.microsoft.com/default.aspx?scid=kb;en-us;312839 to send email from SQL Server (2000) using CDOSYS. I have no idea what CDOSYS is, but in the example, it says to replace 'cdoSMTPServerName' with the name or IP address of my smtp server. I did that and received an error message that 'The server rejected the sender address. The server response was: 530 authentication required - for help go to...'
Is there a way that I can add the authentication required? In my email account settings, I have checked that the server requires authentication and to use the same settings as my incoming mail server if that helps.
Is there a way that I can add the authentication required? In my email account settings, I have checked that the server requires authentication and to use the same settings as my incoming mail server if that helps.
ASKER
nito8300: I installed it and ran a test. It returs 1, indicating an error...
>>indicating an error...<<
And the error is ...
Hint: When executing this stored procedure from SQL Query Analyzer, you can see the error message (if any) in the Messages tab.
And the error is ...
Hint: When executing this stored procedure from SQL Query Analyzer, you can see the error message (if any) in the Messages tab.
ASKER
Duhh. Sorry, temporary brain-freeze. Same message as CDOSYS:
Error: sending message
Server response: 530 authentication required - for help go to http://help.yahoo.com/help/us/sbc/dsl/mail/pop/pop-11.html
Error: sending message
Server response: 530 authentication required - for help go to http://help.yahoo.com/help/us/sbc/dsl/mail/pop/pop-11.html
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Is mail relay enabled on your email server ... ?
ASKER
I don't know. How would I find out. I have AT&T DSL service. the mail server is through yahoo.com.
ASKER
Well, everything looks fine. I have Outlook up and running. I have the right account information entered for the email account. I am using my AT&T (sbcglobal.net) userid as the FROM: address in SQL. The error does not say anything about relaying, it says authentication is required. The error refers to this location (http://help.sbcglobal.net/article.php?item=6239). It deals with authentication. I do not know what needs to be done to support authentication from within SQL Server. As I stated earlier, in the account setup, there is a checkbox that indicates my server requires authentication and to use the same settings as my incoming mail server. But I do not know what is happening there 'behind the scenes' and if it is something that can be mimicked within xpsmtp. As far as I know, my isp is yahoo.com so there is no one else I can contact.
Ok. Let's try again: Since you require that your SMTP mail be authenticated "You will not be able to use XPSMTP for this purpose"
>>The error does not say anything about relaying, it says authentication is required.<<
My point was that, if and when you find a tool that you can use from SQL Server that offers authentication, than your next roadblock to overcome MAY be relaying mail.
>>The error does not say anything about relaying, it says authentication is required.<<
My point was that, if and when you find a tool that you can use from SQL Server that offers authentication, than your next roadblock to overcome MAY be relaying mail.
ASKER
I would like to readdress this topic. All the testing I was doing and comments I was making was on my home system. I have had to drop this for awhile but am back to playing with it again, now at work. When I attempt to run xp_sendmail, I get the message:
Server: Msg 17985, Level 16, State 1, Line 0
xp_sendmail: Procedure expects parameter @user, which was not supplied.
I was unable to find a @user parameter in the documentation. The query I was running was:
EXEC master.dbo.xp_sendmail @recipients=N'xxxx@someone
@message=N'The master database is full.',
@copy_recipients=N'whoever
@subject=N'Master database status' ;
I did read that in order for xp_sendmail to run, the sql mail session must be started. I went ahead and ran xp_startmail with userid and password. I get the following message:
Server: Msg 18035, Level 16, State 1, Line 0
xp_startmail: Your SQL Server Service is running under the local system account. You need to change your SQL Server Service account ro run under a domain account in order to complete this operation
I am not a DBA so not really certain what this is saying, but before I try to excalate this up the ladder and see if the necessary changes can be made to run under a domain account, is this something that can be done without much trouble and without affecting the current operation of our server? If it cannot be done easily, am I just out of luck completely with being able to send mail within T-SQL?
Server: Msg 17985, Level 16, State 1, Line 0
xp_sendmail: Procedure expects parameter @user, which was not supplied.
I was unable to find a @user parameter in the documentation. The query I was running was:
EXEC master.dbo.xp_sendmail @recipients=N'xxxx@someone
@message=N'The master database is full.',
@copy_recipients=N'whoever
@subject=N'Master database status' ;
I did read that in order for xp_sendmail to run, the sql mail session must be started. I went ahead and ran xp_startmail with userid and password. I get the following message:
Server: Msg 18035, Level 16, State 1, Line 0
xp_startmail: Your SQL Server Service is running under the local system account. You need to change your SQL Server Service account ro run under a domain account in order to complete this operation
I am not a DBA so not really certain what this is saying, but before I try to excalate this up the ladder and see if the necessary changes can be made to run under a domain account, is this something that can be done without much trouble and without affecting the current operation of our server? If it cannot be done easily, am I just out of luck completely with being able to send mail within T-SQL?
I am afraid I have no idea. I have never used xp_sendmail as it requires a MAPI client, such as Outlook installed on the server and that is very rarely a good idea, especially when there is such a simple alternative (XPSMTP) using the SMTP protocol.
In any case, good luck with SQL Mail.
In any case, good luck with SQL Mail.
Just download and install xp_smtp_sendmail from SQLDev.Net. ... Information about how to install and use xp_smtp_sendmail can be found at the SQLDev.net .. it doesnt require a mapi profile and is very robust and reliable "and free"
TAB8,
I suspect if you re-read the thread you will find that has already been suggested more than once.
I suspect if you re-read the thread you will find that has already been suggested more than once.
Hope it helps.