SQL Database Mail - Responding To And Out Of Office Msg
May 16, 2006
Hi All,
Do anybody know if it's possible to have an SQL 2005 server deal with and out of office reply from an email its send via the new Database Mail?
My application sends mail to users, giving them task instructions via Database Mail, however if they have thier out of office set true, I just get a reply msg in the profiles inbox. I would like the SQL server to know that they are out of office.
I can recogise the replys by the subject and I have control over the format of the replies, so its just case of getting the SQL server to read msg in the inbox.
My sql agent mail suddenly stops working. The mails are usually going to the people. But once in a while I have this wierd problem of mails not reaching the recipients. Happens once in 2-3 weeks, starts working fine if I restart the server. When I open the Outlook client, the outbox is also empty, but still the mails are not gone. If I Test the mail profile in the sql agent properties, it gives time out error. Everything becomes okay if I restart the server.
OS: Win 2K sp4 Server : SQL 2000 SP3 Account : Verified that the account is in Administrator Group There is only one MAPI32.DLL file and is in system32 folder.
The wierd part is everything works if I restart..any help would be much appreciated.
We were recently acquired and need to move our existing SSRS 2012 mail server from our internal SMTP service. The internal service doesn't need to have a 'real' account to send email out. Everything seems to be setup and running under the internal service.I think I need to change the Email Settings information in "Reporting Services Configuration Manager". Namely the Sender address and SMTP Server fields. But without actually making these changes, I don't see where it is going to ask for the password. Really hate to make changes on a production server.
Do I need to change the "Log On As" account in the "SQL Server Configuration Manager" as well? If so, does this need to be the same account as used in the Sender Address (above)?. there is a lot of ink about making additions to the "rsreportserver.config" file. Our existing file does not have any of these entries.
Today we moved from 32bit to 64bit computing environment. 64bit Window server 2003 and SQL 2005 are now our playing ground. And 32 bit Office 2003 is also installed. Excel in Office program plays important roll in our mission.
One of our routine task is that step 1. get Excel data files from other websites and step 2. extract specific data from them and step 3. converting them into some type of data that can be compatible with SQL
Our problem occured in step 3. To convert data, we realised taht 64 bit excel driver, which we believe is not yet available, is required.
My questions are:
1. Is 64 bit excel driver (of office 2003 or office 2007) available now?
2. Is there any way OR IS IT POSSIBLE to use 32 bit excel driver with 64bit SQL 2005? If possible, please enlighten me.
I would appreciate it very much if anybody answer my questions.
What is the best way to insert records into an SQL Server 2005 database that's being hosted with my website. The data will originate from customer sites as transactions. Do I connect to the hosted database using TCP/IP or do I create web pages that accept the data variables? This is all new to me! I need this to happen unattended and 24/7/365 Thanks Tim
I'm not experienced with SQL Server 2005.I've got a live copy of my database running on the web server.I've got another copy running on my desktop that I make changes to.Whats the best way to sync between the two so:1. I don't have to take the application offline2. I don't loose any data from the live database3. But I can implement changes to tables and/or add new tables
Lokendra writes "I have configured the Database mail profile and account in Sql Server 2005 but the mail is not sending and showing the following error message:
Error,235,The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 1 (2007-03-05T15:16:07). Exception Message: Cannot send mails to mail server. (Mailbox name not allowed. The server response was: Sorry<c/> that domain isn't in my list of allowed rcpthosts.). ),3000,90,,3/5/2007 3:16:07 PM,sa
but while in the same mail set up in previous instance of sql server 2005 the message was sending very well. After installing new instance of sql server 2005 the problem is arising.
Anybody can tell me that what I can do so that i can send mail using the SMTP databasemail account."
Our company use yahoo business mail server for our corporate mails. I know that I can configure database mail with SMTP. But when I try to configure database mail account with yahoo bizmail, I cannot do that. It gets configured but when I test it it doesn't send any mails. Do I need to have any special condiguration for this. SMTP address is smtp.bizmail.yahoo.com. Also I have specified the Authentication using my user name and password. Please help
I want to send a simple mail using DATABASE MAIL feature in SQL SERVER 2005.
I've defined a public profile. I've enabled Database Mail stored procedures through the Surface Area Configuration .
but I can't send a mail with sp_send_dbmail stored procedure in 'msdb' database .
when I execute sp_send_dbmail in the Managment Studio the message is "Mail queued" but the mail is not sent.
Could it be related to Service Broker?Because the Surface Area Configuration indicates:'this inctance does not have a Service Broker endpoint'.If so, how should I make an endpoint?
here is the log file after executing sp_send_dbmail:
1) "DatabaseMail process is started"
2) "The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 2 (2007-03-08T00:49:29). Exception Message: Could not connect to mail server. (No connection could be made because the target machine actively refused it)."
The DatabaseMail90.exe is triggred ,so the mail is transfered to the mail queue but DatabaseMail90.exe couldn't give the mail to SMTP server.The promlem is what should I do to make DatabaseMail90.exe able to connect to the server?
I am having a problem with connecting to SQL Server 2005 database from Office Business Scorecard Manager 2005 (the connection string i am using is: provider=SQLOLEDB;Data source=server_name; Initial catalog=database_name). But the connection failed. Would please any experts here shed me any light on what is the problem and how to fix it then? As there is no any forum for Office Business Scrorecard manager 2005. Therefore I post my thread here as it is related to the connection to SQL Server 2005 database engine, thought here is the best place for this question.
Thank you very in advance for your kind advices and help. And I am looking forward to hearing from you soon.
HI,when configuring database mail in sql server 2005 i am getting the below error.The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 4 (2006-09-13T13:50:18). Exception Message: Could not connect to mail server. (An established connection was aborted by the software in your host machine). )when i ping the smtp server, i could successfully connect to the smtp server. but when i send a test email i am getting the above error message saying not able to connect to the server.please help
I am trying to use database mail to send out a list of data. I am using a number of queries to build a string and each query needs to have its results displayed on a new line when the email is viewed using Outlook.
I am having trouble adding a line break into the string. Any pointers would be great.
Please Concentrate on colored TSQL; I should i pass dynamic text to database mail in @body. Declare @charstrn varchar(20); Declare @C_name varchar(20); Declare @l_code nvarchar(20); SET @charstrn = @S_name+'Welcome to India.You are now registered Student under counslerName'+@C_name+'BranchOffice'+@l_code;
EXEC msdb.dbo.sp_send_dbmail @profile_name = 'Pradeepvarun', @recipients = @emailid , @body = (select @charstrn), @subject = 'You are now Registered in APT';
I have an application which allows communication through an internal blog. We have to monitor all communications for compliance but I'm unable to find a solution to my problem and hope someone can help.
The application allows IM/Email/Blog entries to authenticated members. We can take these communications and send them to our exchange server. However the FROM address is always the profile owner setup in SQL.
Question:
I want the FROM address to list the person starting the conversation and not setup individual profiles for each person using the application. We already have the ability to capture the communication through the application and send it to exchange but the FROM address doesn't reflect the person initiating the conversations.
Hi, i need to send emails from sql server. to configure the setting i need to open database mail configuration windows right? But i dont have database mail icon or tab under management folder. I only have archieve under server roles. Help me.. Urgent.Thanks
I'm keen to use database Mail in SQL 2005. It seems to work well and save's me having to implement a queue, audit logging for sent/errored etc, as SQL2005 can take care of all of that for me.
heres the but..
Is there any way to specify the "From" email address in sp_send_dbmail I know you specify it as part of email account & profile but I want to override that.
I just wanted to be able to keep an audit of all the emails that where sent from an asp.net website and thought i could get that functionality "out of the box" with SQL 2005 and DB Mail, but with out being able to set the from: address its not going to work
Dear Profetionals , I am new in SQL I would like to set up a Database mail but I have no Mail Server in my Domain. So, I have to use yahoo pop3 and smtp whitch are mentioned here :
Incoming Mail (POP3) Server: plus.pop.mail.yahoo.com (Use SSL, port: 995)
Outgoing Mail (SMTP) Server: plus.smtp.mail.yahoo.com (Use SSL, port: 465, use authentication)
Account Name/Login Name: Your Yahoo! Mail ID (your email address without the "@yahoo.com")
Email Address: Your Yahoo! Mail address (e.g., user@yahoo.com)
Password: Your Yahoo! Mail password
I used my yahoo email account and plus.smtp.mail.yahoo.com port: 465 to configure the Databast Mail But no test mail recieved , Then I tried SQL help and found this SELECT * FROM msdb.dbo.sysmail_event_log ;i used this SP and the result was : 1 information 2008-04-08 14:53:53.397 DatabaseMail process is started 1188 NULL NULL 2008-04-08 14:53:53.397 IMPSDevuser2 error 2008-04-08 14:54:11.190 The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 1 (2008-04-08T14:54:10). Exception Message: Could not connect to mail server. (No such host is known). ) 1188 1 NULL 2008-04-08 14:54:11.190 saWould you please help me find the error?
We have a user set up for our .net framework (webuser) with access to a database we created for our website. "webuser" needs to be able to send out emails using Databse Mail (SQL Server 2005) via a stored proc by excuting msdb.dbo.sp_send_dbmail. This stopred proc works fine when I am logged in as administrator but won't work for "webuser" and I can't seem to grant DatabaseMailUserRole to our that user either. What do I need to do?
I have bee trying to find a "how to" on setting this up but have been unsuccessful.
Dear Folks,I am trying to finish my configuration of Database Mail on my sp1 build 2153 sql server. I believe to have set it up properly but i still can't get a test message through. My error message reads: The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 3 (2006-08-09T15:14:00). Exception Message: Cannot send mails to mail server. (Transaction failed. The server response was: Mail from <account email address> rejected for policy reasons.). )
Everything that needs to be enabled, i.e. service broker, SQL Server Agent properties, deafult profile in msdb table, services restarted. Is this message a result of Sql server policy or the smtp server? Is there a process in the transaction Sql server initiates that could be causing the policy violation that i need to tell the email admin about? Thanks for your reply. -C
I'm trying to use SQL server email, I am able to use it from the administrator account, but anyone else gets the "EXECUTE permission was denied on the object 'sp_send_dbmail'. The MSDN says "To send Database mail, users must be a user in the msdb database and a member of the DatabaseMailUserRole database role in the msdb database. To add msdb users or groups to this role use SQL Server Management Studio or execute the following statement for the user or role that needs to send Database Mail." . The only problem is - I have no idea what the user name / role database is. I've plunked around the MSDB database and I can't find any documentation, help, anything. I know the login name of the user I want to enable to use database mail, but obviously that's not what the bit of SQL code that MS provided is looking for. Is there an "AddMember" function somewhere?? I don't see it. Should it really be this complicated to do simple email tasks - am I looking in the wrong place?
I have setup a stored procedure which sends an email. It is working fine and I am also receiving all the emails. But, when I checked the Database Mail log in SQL Server, there are hundreds of error messages which I am not able to decide why?
Can someone please provide information on these?
Date 10/3/2007 5:31:13 AM Log Database Mail (Database Mail Log) Log ID 2385 Process ID 5464 Last Modified 10/3/2007 5:31:13 AM Last Modified By MMITask_PWDXServer Message 1) Exception Information =================== Exception Type: System.NullReferenceException Message: Object reference not set to an instance of an object. Data: System.Collections.ListDictionaryInternal TargetSite: Microsoft.SqlServer.Management.SqlIMail.Server.Objects.Account GetAccount(Int32) HelpLink: NULL Source: DatabaseMailEngine StackTrace Information =================== at Microsoft.SqlServer.Management.SqlIMail.Server.DataAccess.DataAccessAdapter.GetAccount(Int32 accountID) at Microsoft.SqlServer.Management.SqlIMail.Server.Controller.CommandFactory.CreateSendMailCommand(DBSession dbSession) at Microsoft.SqlServer.Management.SqlIMail.Server.Controller.CommandFactory.CreateCommand(DBSession dbSession) at Microsoft.SqlServer.Management.SqlIMail.Server.Controller.CommandRunner.Run(DBSession db) at Microsoft.SqlServer.Management.SqlIMail.IMailProcess.ThreadCallBack.MailOperation(Object o)
I have configured sql 2005 to send Database mail via SMTP using a profile and account that works fine during a test send. However, when I set myself up as an opperator (with the same email as the test) and tell a job to email me upon sucess, and run the job I dont get the email.I looked at the error log, and get the error that: "an attempt was made to send an email when no email session has been established"Any help is greatly appreciated!Dan
I'm having a problem with SQL Server 2005 not being able to send all of my messages. Occasionally when we batch a large number of messages together, we run into problems because the SMTP server can't process them fast enough, and the message doesn't send due to a timeout. I know I have increase the number of retries, but I'd rather just increase the timeout setting. Does anyone know where I might be able to do this at? The mail admins are also looking at modifying the rules in SMTP so that messages from these servers don't go through the vigor of SPAM and phishing detection. Hopefully that will speed it up, but I'd like to give it a little extra leniency on the SQL side as well. Any suggestions?
I just installed a new sql 2005 with sp2 on a windows 2003 sp1. I enable the database mail in surface area configuration and configured the database mail, but I got a error message when I tried to send a test mail, I used the sql server and sql server agent startup account to set up the mail.
The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 2 (2007-06-11T20:17:57). Exception Message: Could not connect to mail server. (No connection could be made because the target machine actively refused it). )
Hi I have set up database mail. I know the settings are correct because I use the same ones for MS Outlook on the same machine. I am getting the following error. ----------------------------------- The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 6 (2007-06-26T06:25:01). Exception Message: Could not connect to mail server. (No such host is known). ) ------------------------------------ Service broker is enabled. Database mail is started.
i really don't know what else it could be. ...Does SQL Server Agent have anything to do with Database mail? Any other suggestions gratefully accepted.. ICW
