I've been using xp_smtp_sendmail (http://www.sqldev.net/xp/
Unfortunately, we recenly changed or T1 provider and their SMTP server reguires authentication. xp_smtp_sendmail does not support these paramters. I need another solution to send these files in a hurry! I've done some searching and seen other potential solutions but none seem to support authentication of they require more coding than I have time to do right now.
Right now I simply have environmental variables I can set for the packages and then use one simple call to xp_smtp_sendmail passing it the parameters. Does anyone else know of a comparable solution that has LOGIN and PASSWORD parameters?
Thanks
David
This Question has been solved and asker verified All Experts Exchange premium technology solutions are available to subscription members.
Experts Exchange has been collecting answers to technology questions since 1996…3 million and counting! If you have a question, chances are we already have your answer.
If you can't find the exact answer you're looking for, ask our exclusive community of 50,000 experts. You’ll get a personalized answer from a trusted professional.
Thousands of free tech tips, tricks, how-to’s and tutorials are available in our peer reviewed articles section. See for yourself how smart our experts are, no login required.
Save solutions to your questions, answers you’ve discovered through searching plus helpful articles in your personal knowledgebase for easy future access.
Access the answers to your technology questions today.
30-day free trial. Register in 60 seconds.
Members of the expert community talk about why the experience at Experts Exchange is different than what you will find anywhere else.
Try it out and discover for yourself.
30-day free trial. Register in 60 seconds.
Join the community of experts here and help other tech pros by answering question in your area of expertise. You can earn FREE access to all Experts Exchange's premium features and resources.
Looks like you'll need to uncomment and hard code/parameterise these lines in the referenced SP:
--EXEC @iHr = sp_OASetProperty @iMessageObjId,
--'Configuration.Fields("h
--EXEC @iHr = sp_OASetProperty @iMessageObjId,
--'Configuration.Fields("h
Thanks. I haven't forgotten y'all. I've been on the road and haven't had the chance to test this. I had seen this sproc before but was just hoping there was an extended sproc out there to replace xp_smtp_sendmail (or even better swtill an update to xp_smtp_sendmail). I will try to get to these today.
I modified the [sp_SQLSMTPMail] code for dynamically adding SendUserName & SendPassword, which plugs the values, but when executing the proc from sql server I get this error
===
Error updating Message configuration fields.
ADODB.Fields
Fields update failed. For further information, examine the Status property of individual field objects.
===
If you log into VS.NET for example and execute the proc it works perfectly ...
I figured you might want this heads up before plunging into the code
I guess you'll need to do exactly that.... alter sp_SQLSMTPMail to display the status property of each field. Also maybe inspect the errors collection.
Often when it works one way (VS.Net) and not through SQL Server, its because the SQL Server and/or SQL Agent service account doesn't have sufficient privileges. To verify this you can ~temporarily~ set both of these accounts to domain admins and see if that helps.
Yes, as domain administrator executing the program there is not a problem, but of course, at that point, the SMTP Mail configuration is still being completely ignored.
I will post as soon as I work out exactly what the minimum security requirements are for this solution to function. If anyone else happens to have already do this, please let us all know what they are. One client may also be switching up to SQL Server 2005, so I may end up with a new problem/solution for them, but I still have a good many clients running on SQL Server 2000, most of them with 7.0 compatible databases... more later.
Business Accounts
Answer for Membership
by: cs97jjm3Posted on 2008-01-11 at 02:27:26ID: 20635235
http://binaryworld.net/Mai