Just trying out xp_smtp_sendmail for the first time.
I get the error:
Error: connecting to server smarthost
OK, so I don't have the server parameter for SMTP server set up
correctly.
I don't even know what an SMTP Server is! Is this an e-mail provider
that provides SMTP functionality, or an application I need to install?
Hi,
I have RS 2000 running on windows 2003 server. I want user to subscribe to reports and receive reports via email. Initially SMTP was not installed for IIS 6.0, so I installed it and the right way (I had done it on different machine before and was succefull in that) but on this particular machines ...I don't see "Default SMTP Virtual Server" node when I open IIS manager.
This is the third day I am working on this issue ..please help me out guys,
prashant
Hello dear
i am using windows 2003 server where i have installed smtp server
now i want to configure with remote stmp so i can send an email to any domain.
So pls tell me how it will be done.
Thanks
I wish to send e-mail from my SQL Server, however, I do NOT want to use Exchange or MS Mail. I am looking for a very simple SMTP component that I can call from SQL.
What are my options?
Thanks in advance,
-JohnN
Have anyone been able to set up mail using a SMTP server successfully?
Is it necessary to have a mailbox for outgoing mail on the SMTP server?
Thanks
Lystra
Hi
How to create SMTP notifications using SQL Server 2000?
could you please gimme some usefull URLs.
Thanks & Regards
Hello,Does anyone know how I can set SQL Server up so that after it hascompleted a backup sucessfully it will send the completion report toan e-mail address via SMTP.Unfortunatly we cannot install MS OUTLOOK Express or similar.Is this possible?Many thanks in advance,Allan Martin
View 2 Replies View RelatedAny idea when this extended stored procedure gets installed in SQL 2000 as I get just the error message below when I try to run it:
Could not find stored procedure 'master.dbo.xp_smtp_sendmail'.
Help with query: I currently cannot be alerted by SQL Mail so I would like to take the script that was generated by SQL server and using the store procedure sp_sqlsmtpmail to generate a email using smtp server to alert me. The store procedure does work. I would like to know if this is possible.
Thanks
Lystra
-- Script generated on 1/21/2005 10:04 AM
-- By: MAMSIsa
-- Server: (local)
IF (EXISTS (SELECT name FROM msdb.dbo.sysalerts WHERE name = N'Demo: Full tempdb'))
---- Delete the alert with the same name.
EXECUTE msdb.dbo.sp_delete_alert @name = N'Demo: Full tempdb'
BEGIN
EXECUTE msdb.dbo.sp_add_alert @name = N'Demo: Full tempdb', @message_id = 9002, @severity = 0, @enabled = 1, @delay_between_responses = 10, @include_event_description_in = 5, @database_name = N'tempdb', @category_name = N'[Uncategorized]'
Then
Exec sp_sqlsmtpmail
@vcTo = 'lwilliams@Huc.com',
@vcBody ='Check out problem Immediataly.',
@vcSubject ='DOCSITE01FDK - Full Tempdb Log'
END
SSIS dynamic SMTP mail server
Hi All,
I'm trying to make my SEND MAIL TASK in SSIS dynamic, by retrieving SMTP Server name (amongst other email message information) from a table.
I've got an SP that is getting the information into package variable's, and when I don't try and have a dynamic server name (i.e. I use a specified SMTP server in my SMPT Server connection), then the email get sent off.
I'm trying to use an expression to build alter the send mail to use the server name I have in a user variable.
I've tried using the expression for the property:
SmtpConnection set to: RTRIM( @[User::MailServer])
I also tried without the RTRIM - I only added it because the error messages seem to include a full 'string' length, and there doesn't seem to be a 'varchar' data type for SSIS variables.
so:
a> Is SMTPConnection the property I need to be setting? None of the others seem correct
b> If SMTPConnection IS the property I need, does the value give the SMTP Server Name, or just the Name of the connection from the Connection Manager's?
Thanks
Part-Answer to:
b> The SMPTConnection property sets the name of the CONNECTION to be used. That Connection needs to set the name of the server. So n ow, the question becomes, how do I configure that from SQL (I know how to use package configurations from XML files).
Hello,
I am trying to create standard subscriptions using local SMTP server. When i create a subscription with no parameters, the reports and delivered via email. If I try to subscibe to a report with parameters and setting the parameter values , the subscription fails. The Data Source credentials are stored., The same report without parameters is delivered.
Here is the log.
ReportingServicesService!library!10!10/17/2007-12:10:07:: i INFO: Initializing EnableExecutionLogging to 'True' as specified in Server system properties.
ReportingServicesService!emailextension!10!10/17/2007-12:10:07:: Error sending email. Microsoft.ReportingServices.Diagnostics.Utilities.RSException: An error has occurred during report processing. ---> Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing. ---> Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Query execution failed for data set 'DS1'. ---> System.InvalidOperationException: ExecuteReader: CommandText property has not been initialized
at System.Data.SqlClient.SqlCommand.ValidateCommand(String method, Boolean async)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
at Microsoft.ReportingServices.DataExtensions.SqlCommandWrapperExtension.ExecuteReader(CommandBehavior behavior)
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeDataSetNode.RunDataSetQuery()
Please help !!
Hi,
When i try to send an email from SQL 2000 reporting services, i get error "The underlying connection was closed: Unable to connect to the remote server" . In a different environment the same settings is working.
The only difference is that in first case, SMTP server and SQL 2000 reporting server are in different domain. But i have tested SMTP server connectivity from the reportserver using DOS command. It works good.
Please help me
Regards,
Shakeela
my package requires a send mail task and i must use a secure non-windows smtp server. can someone please tell me how to configure the smtp connection manager so i can do this? thanks.
View 6 Replies View Relatedi want to check.. Report Server Windows service has Send As permissions on the SMTP server.
how can i do this..
does anyone knows if there is such xp_smtp_sendmail with 64-bit version?
View 1 Replies View RelatedHi!
I am using SQL Server 2000. I wanted to send MIME type mail through SQL Mail. So I downloaded xpsmtp80.dll and copied to C:Program FilesMicrosoft SQL ServerMSSQLBinnDLL. Then I registered it by exec sp_addextendedproc 'xp_smtp_sendmail', 'xpsmtp80.dll'. I granted permission to public by grant execute on xp_smtp_sendmail to public.Now when I am executing this
declare @rc int
exec @rc = master.dbo.xp_smtp_sendmail
@FROM = N'MyEmail@MyDomain.com',
@TO = N'MyFriend@HisDomain.com',
@subject = N'My first HTML mail',
@message = N'<HTML><H1>This is some HTML content</H1></HTML>',
@type = N'text/html'
select RC = @rc
go
An error generating stating
ODBC: Msg 0, Level 16, State 1
Cannot load the DLL xpsmtp80.dll, or one of the DLLs it references. Reason: 126(The specified module could not be found.).
(1 row(s) affected)
Please anyone help me to sort out this problem.
I am trying to use this code to send an emaildeclare @rc int,@invjournal intset @invjournal = 2222exec @rc = master.dbo.xp_smtp_sendmail@FROM= N'matt@hasta.se',@FROM_NAME= N'Matt Douhan',@TO= N'inventering@hasta.se',@replyto = N'Reply to NONE',@CC= N'',@BCC= N'',@priority= N'NORMAL',@subject= N' TEST TEST TEST Inventeringsjournal '+@invjournal+'klar för integration till redovisningen TEST TEST TEST',@message= N'Vänligen uppdatera denna inventeringsjournal tillredovisningen',@messagefile= N'',@type= N'text/plain',@attachment= N'',@attachments= N'',@codepage= 0,@server = N'mandarin.internal.hasta.se'select RC = @rcgobut it fails with the following with the following error msgServer: Msg 170, Level 15, State 1, Line 14Line 14: Incorrect syntax near '+'.the problem seems to be when I want to use the @invjournal variable inthe subject, if I take it away and only send text it works just fine.Any ideas would be much appreciatedrgdsMatt
View 1 Replies View Related
(Apologies if this is in the wrong section.)
I'm been using xp_smtp_sendmail in SQL2000 for firing off task assignment emails from a ASP.NET website which uses Integrated security to connect.
Everything has been fine in the past but now these EMail have stopped being sent. (Can't give an accurate date as to when)
The same thing is now happening on my local machine as well, everything appears to run fine - xp_smtp_sendmail does not send back an error code it's just that the EMail is not sent. The unusual thing is that if I run the exact same code (lifted from Profiler) in SQL Analyser then the mail is fired off no problem.
Things I have tried...
Set Chaining in Calling DB.
Set Website conn string from integrated to use sa login.
Opened up permissions for ASPNET user.
Created sproc in master to do call to xp.
Reloaded xp_smtp_sendmail and set permissions.
I'm now at a dead end and would be grateful for any helpideas.
How to send email using asp.net 2.0 and how to find the smtp mail server name?
View 1 Replies View RelatedI'm having trouble in configuring Yahoo's SMTP for Database Mail. Here is my current settings:
Email Address: xxx@yahoo.com
Server Name: smtp.mail.yahoo.com
Port Number: 465
This server requires a secure connection (SSL) - check
Basic Authentication
Username: xxx@yahoo.com
Password: xxx
When I tried sending a test email, it didn't work. But when I changed my SMTP to use Gmail, it worked!
Hello All.
I sent a HTML file as text message using xp_smtp_sendmail from my SQL server but the test email that I received doesn't look like the HTML file I have originally. Below are my codes:-
exec @rc = master.dbo.xp_smtp_sendmail
@FROM = N'xxx@yyy.com',
@FROM_NAME = N'Mr XXX',
@TO = N'www@yyy.com',
@CC = N'kkk@yyy.com',
@priority = N'HIGH',
@subject = N'Weekly Sales To Thirds',
@type = N'text/html',
@messagefile = N'D:WSTWeeklySalesToThirds.htm',
@server = N'999.99.999.99',
@attachments = N'D:WST4weeksWST.xls'
select RC = @rc
The problem I have is the email doesn't display the HTML correctly. Spaces appeared and some of wording have wrapped.
I have attached partial screen shots of my original HTML file and email.
Please help if you have similar problem and solution. Thank you.
Best regards
Teck Boon
Hi all. Iv'e tryed out xp_smtp_sendmail, and I like what I can see sofar. The thing I wonder about is if the xp supports sending both htmlAND plain text in the same mail. I'm on a sql2000 sp3 and I have noproblem with the xp when i either send plain text or html, but asstated above I need to send with both formats in one mail......For use when one does not know if the receiver uses a mail-client thatsupports html or not. If not does anyone know of a good way to attackthis problem?thanks in advanceKarl B
View 1 Replies View RelatedHi all,At this moment I'm trying to get database mail working. According tosome people it should be easy. Well...that is not the case for me.I'm having the following error:The mail could not be sent to the recipients because of the mail serverfailure. (Sending Mail using Account 2 (2006-11-24T08:48:15). ExceptionMessage: Cannot send mails to mail server. (Command not implemented.The server response was: Command not Supported).)SQL Server 2005 is installed on a separate server and the SMTP Serveris Lotus Notes. connecting with port 25.Start and stopping the SQL Server and SQL Server agent i tried already.i tried sysmail_stop_sp and sysmail_start_sp.Sometimes when starting or stopping the Mail with the followingcommands :exec sysmail_stop_spGOexec sysmail_start_spGOI will get the following error:Msg 233, Level 20, State 0, Line 0A transport-level error has occurred when sending the request to theserver. (provider: Shared Memory Provider, error: 0 - No process is onthe other end of the pipe.)So any help would be appreciated.Hennie
View 1 Replies View RelatedI have an issue with SMTP server " send mail task ". we see the following error [Send Mail Task] Error: An error occurred with the following error message: "The SMTP server requires a secure connection or the client was not authenticated.In SMTP connection manager what we should give in SMTP SERVER, if we use gmail id's in send mail task editor.
View 4 Replies View RelatedOK so now I'm setting up a trigger to email info to different people based on values INSERTed into one of my tables. I'm using an IF statement to determine who I'm giong to send the mail to, but I don't really understand how to include the data (parameters) in my message. Thanks for any help. Here's what I have so far.
Code Block
ALTER TRIGGER [smallin].[trig_test]
ON [smallin].[DATALIST]
AFTER INSERT
AS
declare @rc int,
@post bit,
@pre bit
SELECT @post = [POST], @pre = [PRE] FROM inserted
IF @post = 1
exec @rc = master.dbo.xp_smtp_sendmail
@FROM = N'ln.li@mydomain.com',
@FROM_NAME = N'Alert Mailer',
@TO = N's.mallin@mydomain.com',
@replyto = N'ln.li@mydomain.com',
@CC = N'',
@BCC = N'',
@priority = N'NORMAL',
@subject = N'This is post data',
@message = N'Goodbye MAPI and Outlook',
@messagefile = N'',
@type = N'text/plain',
@attachment = N'',
@attachments = N'',
@codepage = 0,
@server = N'exchange.mydomain.com'
ELSE IF @pre = 1
exec @rc = master.dbo.xp_smtp_sendmail
@FROM = N'ln.li@mydomain.com',
@FROM_NAME = N'Alert Mailer',
@TO = N's.mallin@mydomain.com',
@replyto = N'ln.li@mydomain.com',
@CC = N'',
@BCC = N'',
@priority = N'NORMAL',
@subject = N'This is pre data',
@message = N'Goodbye MAPI and Outlook',
@messagefile = N'',
@type = N'text/plain',
@attachment = N'',
@attachments = N'',
@codepage = 0,
@server = N'exchange.mydomain.com'
I am doing some ssis package development in my local machine. I have a requirement to send email the output.
I am developing in my local machine. Is it possible to configure SMTP configuration in my local system to receive the email in Gmail?
if yes, what all are the steps to be followed.
Hello,
The Database Mail feature is already enabled on the server, also I have a mail account on the other server.
The problem I faced is that I need to send mail from my SQL Server using a created email account on the other server. How should I configure my email to do that ?
Should I use a sysmail_add_account procedure to enable account, also set profile and profile account ? Does this way creates server mail account that is binded with other email account?
The mail should be sent from my SQL Server.
Thank You.
Hi
I'm trying to send email from my rss script. It seems that the script cannot create an SmtpClient instance because of SmtpPermission problems, but I just can't find where I need to enable the SmtpPermission. I've tried many things, including web.config and rssrvpolicy.config.
Here's a code sample:
Public Sub Main
Dim smtpClient As New System.Net.Mail.SmtpClient
End Sub
and here's the output when I execute the above script under rs.exe against my local report server
Unhandled exception:
Request for the permission of type 'System.Net.Mail.SmtpPermission, System, Version=2.0.0.0, Culture=neutral,PublicKeyToken=b77a5c561934e089' failed.
Any ideas?
Many thanks
Tony
Does anyone have any step by step instructions for how to send smtp mail from SQL?
I guess I can use xp_cmdshell to run a vb script or something but I have no clue besides that as to what's involved.
Hope someone can help.
Deirdre
Has anyone ever set up sql mail through smtp. I am trying to automate my server and not having to much success as i cannot use exchange for company reasons. I understand that i am able to set this up through outlook and not outlook express.
this is what i have tried to do:
1. Remove any MAPI application (Full Outlook or Microsoft Messaging from control panel). It is important that there are no mapi profiles on the server.
2. Logon to the SQL server using the SQLService account
3. Check that Outlook Express is the default Mail client (done from IE/tools/Internet Options/Programs)
4. Check that there is a mail account configured, pointing to an SMTP server, say aklexch1 (just put bogus stuff in for the POP server)
5. test that you can send a message (ignoring the receive errors) from Outlook Express to your @advantagegroup.co.nz address
Only after step 5 is working should you start testing from SQL
6. In SQL Mail config you will not see any profiles in the list but just type 'Default'
7. Create an SQL Operator with an @advantagegroup.co.nz address and click the test button
nb:i am setting this up on an win2000 server.
Hi
How to Create SMTP Notifications using SQL Server 2000.
Thanks & Regards
-Raj
Raj.
hi,
would you know how to know if a connection can be established to an smtp server without even issuing any smtp command? i want to be able to do this using ssis, script component. thanks.
I am using a unix terminal via sendmail (which i assume is compliant), I have set up mail client in outlook express called SQLService. My main issue is that no mapi profile can be located on the server and sql server agent is recieving login failed attempts when I a attempt to start it! any ideas
------------
Damien Harris at 1/25/01 7:29:49 PM
Can anyone adivise me with setting up mail in SQL 7. Unfortunatly I am unable to use the usual mail client for security reasons, thus I am attempting to use a mail account through express specifying a smtp address. I keep recieving Mapi and logon errors when starting mail and service manager.
Can anyone help! thanks
--------------------------------------------------------------------------------