Hi Friends,
I am finding an error in SQL Server Agent log which is related to database mail configuration. Can any one please guide me how to configure the database mail configuration to transfer the data from SQL CE to SQL server.
Thanks in Advance
Has anyone been able to configure Database Mail and successfully send an email message? I set it up this afternoon, but all my messages are sitting in the sys_mailitems table of the msdb database.
View 5 Replies View RelatedI want to send mails from SQL Server 2005 Management Studio Express for which I referred to the article at http://www.databasejournal.com/features/mssql/article.php/3626056. I could successfully do the steps from step 1 to step 6 listed at the above URL. In fact, when I sent a test mail (as cited in step 6), SQL Server displays the message Mail queued though the mail didn't get delivered. The mail server address I am using is smtp.mail.yahoo.co.uk.
But when I expand the Management node in the Management Studio Express GUI, I don't find Database Mail as a child node. In fact, there are only 2 child nodes under the Management node - SQL Server Logs & Activity Monitor.
Why isn't Database Mail listed under the Management node? What am I missing here?
Also when I open Surface Area Configuration & then click Surface Area Configuration for Services and Connections, the following error gets generated:
Computer localhost does not exist on the network, or the computer cannot be configured remotely. Verify that the remote computer has the required Windows Management Instrumentation components and then try again. (SQLSAC)
Additional Information:
The type initializer 'System.Management.ManagementPath' threw an exception. (System.Management)
Unable to cast COM object of type 'System.Management.WbemDefPath' to interface type 'System.Management.IWbemPath'. The operation failed because the QueryInterface call on the COM component for the interface with IID '(38C15AF2-736C-477E-9E51-238AF8667DCC)' failed due to the following error: No such interface supported (Exception from HRESULT: 0x80004002 (E_NOINTERFACE)). (System.Management)
When I click Surface Area Configuration for Features, it generates the error cited above but from the first bulleted list.
How do I overcome this error? I confirmed that Windows Management Instrumentation is running by opening Services from Control Panel ---> Administrative Tools.
I am on WinXP Pro SP2. Please note that I also have SQL Server 7.0 installed in my machine which is a standalone m/c.
Thanks
I'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!
Hi,
I have 4 sqlservers(sp3) with same
hardware and software running on
win2000
all servers use same domain account
(myCompanysvcsql) used by sql
service and same mail profile and mail box(svcsql)
One server send more mail then another
and this server 1-2 times a week
fails to execute sp_sendmail.
Each time we have to restart sql
service to resolve the problem.
1.If 4 servers send mail at the same time ,could one of the server "timeout" to exchange connection and cause mail failure ?
2. Should each server have
sepate mail profile and mail box ?
Thank you
Alex
I can't seem to get mail generated by SQLMail to actually send.
Here is what I did.
1. Installed Outlook 2000 and configured it. I was able to send mail.
2. When into Enterprise Mgr and added the profile. It tests ok.
3. When into Query manager and did xp_sendmail 'rutherb2@nationwide.com','test'
4. Message says 'Mail sent', but nothing is sent..
However if I open Outlook and do a "Send and Receive" the mail gets sent.
My question is : Is this the way it is suppose to work? Do I have to have the Outlook client running on my server to get the mail to send?
What am I missing?
Thanks in advance....
!boB
Hello;
** I'am a student* in UTC in France and I have a probleme with a replication in
SQLServer 6.5.
The message error is that:
1-Replication cannot be installed as @@SERVERNAME is NULL
2-If Replication is uninstalled, all publications will be
eliminated and the distribution database[if it exist]will be
dropped. After the process has completed, this session will be
disconnected from the SQL Server. Do you want to unistall
replication?
3-Error 2812:[SQL Server)Strored procedure
'ma_base..sp_MShelp_subscriber_info' not found.
->I don't know why SQL Server want to found* this procedure;
perhaps because last time I creat a database named
'ma_base' and i do a replication a then i dropped it??
when i dropped, i receive this message:
4-Error911:[SQL Server]Attempt to locate ebtry in sysdatabase for database 'ma_base' by name failed no entry found under that name, Make sure that name is entered property.
And when i create a database with name 'ma_base', i receive this message:
5-Error 2812:[SQL Server] Stored procedure
'ma_bse..sp_MShelp_subscriber_info' not found
I don't know what i do???
Thank you very much :((
Hi,
I have a requirement sql server 2005 in which i need to send a mail when ever there is an error in the procedure or job.
The mail should fire with the error attached to it.
could you please suggest the ways to handle this.
Please tell me the list of steps to configure and send the mail.
Thanks in advance.
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."
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
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
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
Hi,
Can anyone please tell me the difference between Database Mail and SQL Mail.
Thanks in Advance
R.K.Nair
RKNAIR
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
I am trying to learn ASP.NET using Visual Basic Standard Edition 2003 and an MSDE database. I am having problems configuring the login. Is this a workable configuration? Are there instructions somewhere for setting up this configuration? I have no problem using Access 2003, but I would like to use MSDE.
View 1 Replies View RelatedIs there a way that anyone knows of that I can get a
printout of my server and database configuration?
I don't want 'Generate Scripts'. I'm looking for a
stored procedure or something that will give me a
text document listing the configuration.
I'm running SQL 7 with sp1 on most servers and sp2
on a few.
I would appreciate any info.
Thanks!
Toni
Please excuse me as although I have lots of database design & development experience I'm not database administrator and I'm new to SQL Server.
I have a SQL server 7 database on a remote web server which I can access over the Internet.
I have SQL server 7 installed on my local network server and I use Enterprise Manager to administer and configure the databases on the server.
Can I use Enterprise Manager to administer and configure the remote database?
If I can't then how do I make changes to the remote database? Do I need to FTP objects or use RAS?
Any help would be very much appreciated?
Hi,
I'm new to SQL 2000 administration and would like to know how to find out what the existing SQL Server Database configurations and what installation options has been installed / selected.
Thanks
Murras68
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 RelatedHello,
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
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.
hi,
In database mail,
while execting sp_send_dbmail i want foolowing thing to be done.
@recipient=select emaild from <tablename>
Is it possible ?
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';
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.
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
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 RelatedI'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
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?
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?
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?
View 6 Replies View Related
Hi,
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)