Database Mail And MS Exchange
Oct 30, 2007
I have set up database mail in SQL 2005. We have an MS Exchange group that is alerted when SQL jobs fail.
Two things ;
i) I can't seem to be able to use Exchange mail Groups. If I specify the group name SQL returns ;
The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 1 (2007-10-30T15:40:39). Exception Message: Cannot send mails to mail server. (The specified string is not in the form required for an e-mail address.).
If Exchange cannot be used in the way that Outlook did then how can we alert a group of users about SQL job failures ?
Therefore I tried specifiying an indiviual email address rather than a group ;
- sending a test message (right click database mail) using the full single email address works fine.
- sp_send_dbmail using the full single email address is also fine.
ii) When a job fails the notifications do not seem to work. The Job history log just reports ;
NOTE: Failed to notify 'Operator Name ' via email.
The SQL Error log reports ;
Message
[264] An attempt was made to send an email when no email session has been established
However sysmail_help_status_sp indicates that database mail has started.
The job fails to notify the operator and in this case it is a single email address.
Anybody got any suggestions, (thanks in advance) ?
View 7 Replies
ADVERTISEMENT
Apr 26, 2007
Database Mail only sends SMTP email messages and logs problemsconnecting to the mail server. However, I also need to log bouncedemails (bad address, etc).Are there any clean ways to do this with Database Mail and Exchange?Or will I have to mix Database Mail with SQL Mail to read bounces outof the inbox? Or, have a .NET windows service that talks to theExchange API?
View 1 Replies
View Related
Jul 9, 2001
I am using nt4.0 sp5 with sql7.0 sp3 and exchange client.
Does anyone know how to keep xp_sendamil form putting a copy of the mail message in the sent mail folder or an automated process for deleting all mail in the sent folder? As it stands now I must manually delete all messages from the sent mail folder on a daily basis.
Thanks,
Ed.
View 6 Replies
View Related
Jul 9, 2001
Hey All,
Is there any way to run SQL Mail with exchange CLOSED? Keeping Exchange always minimized seems rather unneedy, inexperienced developers might just have the tendency to close it. Is there any way to avoid that?
Also, can SQL Mail be configured with something else besides Exchange?
Thanks a bunch!
Ilya
View 3 Replies
View Related
Oct 27, 2000
I setup a domain user account and e-mail account for the sql agent. When I want the agent to mail me a message
when something happens it puts it in the out box but does not send until I pull up the outlook express and ping the server to send recieve.
If I don't have outlook express running in the taskbar, it won't send the message at all. The e-mail is configured as an internet mail component.
Any suggestions??
View 2 Replies
View Related
Oct 28, 2000
I want use SQL MAIL, but I have MDAEMON mail server on my Wndows NT Server!
Can I have any chances for it?
View 1 Replies
View Related
Feb 3, 2000
I saw from SWYNK that you were able to set up SQL Mail using Lotus
Notes. I tried following the post by Edward Alexander but got into some trouble:
We were using MAPI to get to Notes Mail.
1. We know that MAPI works because we were able to send mail by
a. using the exchange client (Windows Messaging client)
b. using VB script to send a message with MAPI.Session
The problem is that SQL server cannot see the Exchange Profile that was defined on the SQL box.
View 2 Replies
View Related
Jan 25, 2008
I've used send mail tasks on all my etl's without any problem.
Today we are migrating from a exchange 2003 to an exchange 2007 server.
I've filled in the new IP and runned the send mail task box and now it fails, the send mail task won't work anymore.
Anyone else who has experianced simular problems like this ?
I've already tried the checkboxes use windows login verification and ssl but it still won't work.
Someone please help me or i have a major problem.
View 1 Replies
View Related
Mar 1, 2002
Hi all,
I'd like to link a SQL Server database / table to Microsoft Exchange Server E-Mail-Address data, for an Employee Directory project.
I've read a little about "Web Store", a little about ExOLEDB, but I've come across nothing along practical lines. I.e., I still don't know where to begin!
For example the "Web Store" should be created on the SQL server, but how do you create it? Any insights will be greatly appreciated.
Gallagher
View 1 Replies
View Related
Sep 3, 2006
I just read that if you use an exchange server...the account that youstart SQL with needs a mail on the exchange box.Is this true?I know I didn't need an account when I've set it up before...but Imight have been using a POP3 server.I have Outlook 2003 installed on the server. Windows 2003 Enterprise.Thanks.
View 1 Replies
View Related
Jul 23, 2005
I would like to configure e-mail alerts on my SQL Server 2000 box.However, we also run Exchange on the same machine. I've been told therecould be conflicts/issues having Outlook on the same machine asExchange; and apparently, one needs Outlook to configure a mail profilefor SQL Server Agent.Is there, in fact, anything to worry about? If so, are there anywork-arounds beside moving Exchange to another server? (we've only gotone server, so this is not an option for us at this time).Thanks.- Dana
View 1 Replies
View Related
Aug 24, 2005
I have a database with 2 users - 'dbo' and 'user1'.Currently:=> 'dbo' is tied to login - 'login1'=> 'user1' is not tied to any login.I want to change the login tied to the database users to:=> 'dbo' tied to no login=> 'user1' tied to 'login1'I try to use:sp_change_users_login 'Update_One', 'user1', 'login1'But it give me an error said 'login1' is already tied to a user.Then I try to remove the login tied to 'dbo' with this:sp_change_users_login 'Update_One', 'dbo', ''Then I get another error said that 'dbo' is a forbidden value for thelogin name parameter.------Previously, all the while 'dbo' is not tied to any login and 'user1' istied to 'login1', but yesterday I restore the DB from the backup filebring back from customer side, then I saw the login changed to the oneI mention above, I'm not sure whether is the DBA from customer sidechange it or what, but is there any way for me to change the login backto the state I want?Thanks.Peter CCH
View 11 Replies
View Related
Mar 7, 2007
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."
View 1 Replies
View Related
Feb 20, 2008
Hi all....
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
Thanks
Rajesh
View 10 Replies
View Related
Sep 1, 2006
Hello
I have got a script which gives the mail to the dba mail box when database backup fails.
In the script I want to make a change so that I get the particular database name , on what ever database i implement.
Can you tell me some suggestions.
The script I am using is :
use master
go
alter PROCEDURE dbo.SendMail
@to VARCHAR(255),
@subject VARCHAR(255),
@message VARCHAR(8000)
AS
BEGIN
SET NOCOUNT ON;
DECLARE
@rv INT,
@from VARCHAR(64),
@server VARCHAR(255);
SELECT
@from = 'testsql2000@is.depaul.edu',
@server = 'smtp.depaul.edu';
select @message = @message + char(13) + Char(13) + @@servername + '-'+ db_name()+ '-' + 'Backup Status Failed' + Char(13)
EXEC @rv = dbo.xp_smtp_sendmail
@to = @to,
@from = @from,
@message = @message,
@subject = @subject,
@server = @server;
END
GO
--- After the above script is run the following should be given in the 2nd step when
--- the backup jobs are scheduled ------
exec master.dbo.sendmail
@to = 'dvaddi@depaul.edu',
@subject =' Test sqlserver 2000',
@message = '' ;
Thanks
View 4 Replies
View Related
Mar 9, 2007
Hi every body
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?
please help me.
POUYAN
View 21 Replies
View Related
Jul 20, 2005
Hello,I work for an attorney staff, so basically the whole day they aresending themselves a lot and a lot of papers (Word docs or Excellsheets).We are going to propose them the use of a Document Exchange andDatabase System (like Lotus Notes or Oracle Managment Content,formerly known as Internet File System IFS ) with .NET interfazes.Basically the idea is that instead of sending papers the whole day,they can use a software to check and manage more quickly theirdocuments.We are looking for a system that allows us to manage:- Security- Versioning- Folders- Check-in/Check-out- Workflow- Search and Retrieval- Extensible MetadataMy question is:1) Is there any Microsoft tool who can help us to achieve that(management of codes, dates, text, names of documents- I mean like aDocument Exchange and Database System) with .NET interface?2) Or do we have to built it from scratch?Thank you very much!Jorge
View 4 Replies
View Related
Feb 7, 2008
We have installation of Dbase Engine and SSIS that is PRODUCTION, and want to replace with newer hardware. In "the old days", we built "boxname_new" and installed SQL with "sqlname_new", took PROD users off-line, and quickly renamed original boxes/SQL and new boxes/SQL to original name, copied data and off we went with upgrade.
NOW, the "renaming" option for SQL tools is not supported, but with re-installation.
Has anyone developed game plan steps for accomplishing hardware upgrade, including SQL environment swap with MINIMAL downtime for PRODUCTION environment? Can you share?
View 2 Replies
View Related
Nov 6, 2007
Hi,
Can anyone please tell me the difference between Database Mail and SQL Mail.
Thanks in Advance
R.K.Nair
RKNAIR
View 1 Replies
View Related
Jan 26, 2007
Hi
I am trying to change the host database (MSDB) of Database Mail to some new database (say NewDB) and
unable to make DatabaseMail90.exe point to this new database (NewDB).
Is it possible to do this?
Thanks
Uddemarri
View 4 Replies
View Related
Sep 13, 2006
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
View 2 Replies
View Related
Aug 22, 2007
Hello,
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.
Thanks Alot
Steve
View 2 Replies
View Related
Apr 9, 2008
What is equavalent in oracle database which does the job similar to Database Mail in sql server.
i use database mail in sql server to send mail.
I do have jobs set, which gets fired every ten minutes. it uses msdb.dbo.sp_send_dbmail
and i have a profile created under database mail which has all the info related to the smtp email acct.
our client now wants our project to also work on oracle.
Thank you very much for the information.
View 1 Replies
View Related
May 2, 2008
hi,
In database mail,
while execting sp_send_dbmail i want foolowing thing to be done.
@recipient=select emaild from <tablename>
Is it possible ?
View 2 Replies
View Related
May 26, 2008
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';
View 1 Replies
View Related
Jun 6, 2008
Hi All,
I am going made here. I set up database mail on a 2005 box. It was working fine, untill I needed to reboot it. Now it does not.
If I run a test with 2000 it works fine. However 2005 does not.
I go to the test mail bit and it says its sent, but it never turns up. So I ran:-
SELECT * FROM msdb.dbo.sysmail_event_log
And I get the fowwloing error:-
259error2008-06-06 16:38:24.493Could not retrieve item from the queue.5708NULLNULL2008-06-06 16:38:24.493UK_domainUSER
Any ideas at all would be gratfull aprisiated!!!
Thanks
Dave
Dave Dunckley says there is a law for the rich and a law for the poor and a law for
Dirty Davey.
View 8 Replies
View Related
Mar 19, 2007
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.
Is this possible?
Thank you, MP
View 1 Replies
View Related
Mar 30, 2008
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
View 7 Replies
View Related
Feb 2, 2007
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
Any one have a sugesstion?
Thanks
View 1 Replies
View Related
Apr 9, 2008
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?
View 1 Replies
View Related
Apr 12, 2006
I am trying to configure Database Mail on a new installation of SQL Server 2005 and the 'DatabaseMailUserRole' does not exist.
How do I add this role to the server?
View 8 Replies
View Related
Aug 16, 2007
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.
View 3 Replies
View Related
Aug 9, 2006
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
View 2 Replies
View Related
