Database Mail Does Not Work From Sql Server Agent Job After Upgrade To SP1

May 5, 2006

Upgraded SQL Server 2005 x64 to Service Pack 1 expressly for the purpose of enabling Database Mail from SQL Job, which was a known bug that was listed as fixed in this Service Pack. It still does not work; in fact after installing SP1 on an x86 SQL Server Standard, Database Mail does not work from there now either, although it did prior to the upgrade! I am using Integrated Security.

Error message received: The job succeeded. The Job was invoked by User <name>. The last step to run was step 1 (Select). NOTE: Failed to notify 'Mike Schelstrate' via email.

Message in Error Log: [264] An attempt was made to send an email when no email session has been established.

Send test Email does work on both Servers.

Here is another Error message I found in the SQL Error Logs: [298] SQLServer Error: 2812, Could not find stored procedure 'msdb.dbo.xp_sqlagent_notify'. [SQLSTATE 42000] (DisableAgentXPs). Looks like this may be the root of the problem because it does not exist, I checked. How do I obtain this missing extended stored procedure?

View 9 Replies

Upgrade And Now Mail Doesn`t Work

Sep 4, 1998

Hello, I upgraded to Beta 3 and now mail isn`t working(I hate mail!) I found 2 error messages. One when trying to add an operators email id and the other when I try to "test" mail under server properties.

- Unable to start a mail session on the server with this mail profile.

- no mail profile defined.

The account that I am using is used for all our SQL Servers and was working on this server on 6.5 before the upgrade. I have checked the new SQLServerAgent service and it`s using the correct account.

Any help would be appreciated.

And to all you that are off for a long Labor Day weekend...I`m jealous!

View 1 Replies View Related

SQL Server 2005 Database Mail And Agent Error

Feb 9, 2006

Hello, hoping someone might be able to help.

I've set up Database Mail on an instance of 2005 and the test mail works just fine. However, when testing a job (notify on fail, success, whatever) the mail fails to send. Job History last information reads NOTE: Failed to notify 'My Name' via email.

Checked out the Database Mail logs - nothing interesting.

Restarted the Agent service and then checked out the current Agent Log. Found message:

[260] Unable to start mail session (reason: No mail profile defined).

The 'DatabaseMailProfile' key is most certainly defined in the Registry
(at 'HKEY_LOCAL_MACHINE', N'SOFTWAREMicrosoftMicrosoft SQL ServerMSSQL.1SQLServerAgent')

I'm at a loss...why is it telling me no mail profile defined?
I'd be most grateful for any help if anybody else has run across this problem.

Cheers,
Megan

View 2 Replies View Related

Sql Mail And Sql Server Agent Mail With Lotus Notes Domino Server

Jul 7, 2003

Hello Everyone,
I am trying to configure SQL MAIL and SQL SERVER AGENT MAIL feature of SQL SERVER 2000 with Lotus Domino server (Not Microsoft Exchange). Every thing goes fine and it works also. Problem starts when I try to restart SQL Agent Service. It hangs and the status of service remain 'starting'...
Also the size of the sqlagent service process goes upto 12MB. I don't understand why? Can any one help me in solving this problem.
I am using Windows 2000 Advanced Server and SQL Server 2000 with SP3. Domino client is R5.0.5 and Outlook 2000.

View 14 Replies View Related

SQL Agent Won't Send Database Mail

Oct 5, 2007

Here's the scoop, and I've seen several posts to this effect but none of the solutions have worked.
Enabled database mail. confirmed profiles and can send test database mail from Query Window. I can also right click Database mail and send test emails. Configured valid operator using same email address for the test emails above.
Enabled database mail profile under SQL Agent properties > Alert System.

From what I've seen, the test button is supposed to be greyed out, and it is. However alerts do not send emails operator.

I've done this

http://msdn2.microsoft.com/en-us/library/ms186358(SQL.90).aspx

and this

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=322173&SiteID=1

and have bounced the Agent after each change but still no mail from the Agent.
I've tried select * from sys_mail_event_log no errors.

For the life of me, I can't see why the Agent won't send mail.

Help.

View 5 Replies View Related

Database Mail Doesn't Work

Nov 21, 2007

I am having trouble getting database mail to work. I have tried many things, but can't make it work.

Initially, I setup IIS opn the same box as a virtual SMTP server. I set it up to relay to 127.0.0.1. In sql server, I setup database mail
to point to localhost, with no authentication. After the setup, when I test the email it works fine.

I created a job that will fail every time. I setup myself as the notify party on the job. When I run the job, it fails.
I get no email. The job log has the following error (notice failed to notify):

Message
The job failed. The Job was invoked by User xxxxAdministrator.
The last step to run was step 1 (test 1).
NOTE: Failed to notify 'Dan Jones' via email.

In the SQL Server log, I see:

[264] An attempt was made to send an email when no email session has been established

Also:

Message
[260] Unable to start mail session (reason: Microsoft.SqlServer.Management.SqlIMail.Server.Common.BaseException: Mail configuration information could not be read from the database. ---> System.Data.SqlClient.SqlException: profile name is not valid
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
a)

This is my preferred configuration, but I couldn;t make it work, so I tried another...

I tried to setup mail through my mail service provider. I entered the IP in sql server. When I test it, I get the following error:

Date 11/19/2007 8:16:06 AM
Log Database Mail (Database Mail Log)

Log ID 24
Process ID 3176
Last Modified 11/19/2007 8:16:06 AM
Last Modified By NT AUTHORITYSYSTEM

Message
1) Exception Information
===================
Exception Type: Microsoft.SqlServer.Management.SqlIMail.Server.Common.BaseException
Message: Could not retrieve item from the queue.
Data: System.Collections.ListDictionaryInternal
TargetSite: Microsoft.SqlServer.Management.SqlIMail.Server.Controller.ICommand CreateSendMailCommand(Microsoft.SqlServer.Management.SqlIMail.Server.DataAccess.DBSession)
HelpLink: NULL
Source: DatabaseMailEngine

StackTrace Information
===================
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)

On the same box, I used telnet to step through thge SMPT mail send process. It worked fine, indicating no firwewall, router or other issues.

I am of the opinion that Database mail is defective. This post is similar to another I have done, but no usefull responses have been made.
I am hoping that sonmeone will provide some useful information here

This is running on Windows 2003 Standard, and on SQL Server workgroup edition.
I have a second backup server similary configured that behaves exactly the same.

View 10 Replies View Related

SQL Server Agent And Mail

Mar 8, 2005

Has anyone's SQLAgent ever hung up becuase of SQL Mail and if so what did you do to correct it?

Tom

View 2 Replies View Related

SQL Server Agent + SQL Mail

Jul 23, 2005

Hi,I've been able to successfully configure SQL Server Agent to sendnotification emails to an appropriate Operator in the event of an alertbeing fired. This all works fine on one condition - that Outlook clientis running on the server.If Outlook is not running the alerts still be fired (i.e. the OccuranceRate still increases as and when expected), but the emails beinggenerated will not be sent until the next time Outlook is opened.Clearly it's unwise to rely on Outlook being open on the server at alltimes, so I was wondering if anyone knows of a workaround to ensurethese emails are processed immediately?I'm using SQL Server 2000 SP4 and Outlook 2003.thanks,Bob.

View 3 Replies View Related

DTS - SQL Server Agent Mail Issue

Mar 24, 2006

Hi,

Wondering if anyone there can tell me what I'm doing wrong (and please be gentle as I'm not at all techy).

I have a DTS scheduled on the Server Agent to run, and at the end it is to send a mail to notify me and several others that it has completed. Trouble is, it runs but doesn't send the mail.

However if I execute the DTS manually it does send the mail.

I have a idea it might be to do with the Profile in SQL Mail in Server Settings on the Properties of the server, but have no idea how to correct this.
Can anybody help?

View 2 Replies View Related

SQL Server Agent &> General Tab &> Mail Session Is Greyed Out ??

Feb 22, 2004

Hi All,

Great forum y'all have going here.

Just wondering if anyone else has experienced this?

Enterprise Manager:
I have setup and 'sucessfully tested a MAPI session' with a mail profile via support services > sql mail. That works fine, however in sql server agent properties the mail session section on the first general tab appears to be greyed out.

scenario is:
Windows Server 2003 SBS edition
SQL Server 2000 SP3
Exchange Server 2003 is also running on the server, with Outlook 2003 client (so i suspect side chaining issue).

Any help appreciated! did not have any luck googling or using microsoft KB.

View 12 Replies View Related

Mail Profile Disabled In SQL Server Agent Properties

Jul 23, 2005

It's a Windows 2000 Server box with SQL 2000 on it. MSSQLSERVER &SQLSERVERAGENT services are logged in as valid domain user. I set up amail profile for that user, and can send email via Outlook 2003.However, when I go to the SQL Agent Properties in Enterprise Manager,Mail Profile is disabled.I've restarted the services & even tried rebooting the server. Thisworks on my other servers, but they're Windows 2003. Not sure ifthat's the problem though.Anybody have any clues?

View 1 Replies View Related

SQL Server 2005 Does Not Work After OS Upgrade To Vista

Jun 27, 2007

My instance of SQL Server Developer stopped working after upgrade of OS from Vista to XP. I have also installed SP1 & SP2. Still it is not working. The message that I get when I start SQL Server Management Studio is "The application cannot start."

View 7 Replies View Related

SQL Server Agent Service Authentication During Upgrade Wizard

Apr 29, 2008

I am trying to upgrade my default instance from SQL Server 2000 Standard to SQL Server 2005 Standard. I get to the service authentication window and hit my first problem. On that window, there is a dropdown box where you should be able to choose the default instance service AND the SQL Server Agent service and set the authentication information for both of those services. That's the way it is in my test environment. However, on my production server, when I click that dropdown box, only the instance appears, and not the agent. Why?

I tried the upgrade this past weekend and ran into this problem. After researching it and not finding anything out about it online, I decided to just go forward anyway since I had lots of backups and copies of everything. The upgrade appeared to go ok, but the agent service wouldn't start. It gave the usual message when you try to start a service that doesn't have anything to do, like the Performance Logs and Alerts service. When I looked at the agent in SQL Server Management Studio, it had (Agent XPs Disabled) next to it. So I researched this and found how to enable it. For some people online, this allowed them to start the agent service, but of course that didn't work for me. Finally in my research online I found that some individuals had a lot of missing system tables in their MSDB and Master databases after the upgrade due to some of the SQL scripts that are part of the upgrade process not running properly. So I compared my system tables and SP's against another SQL 2005 instance I have, and sure enough, there appears to be a lot of missing tables. It was at that point I decided to just restore everything and try again later.

My point in writing that second paragraph is to ask if that was all due to the fact that the SQL Server Agent wasn't listed in the upgrade wizard like it should have been? Or maybe the fact that it wasn't in that dropdown box was evidence of a deeper problem? Is it likely that if I do whatever it is I need to do to make the agent appear in the upgrade wizard that my missing system tables and agent service not starting problems would probably not be an issue anymore? And why would the agent not be appearing in the upgrade wizard?

Thanks for your help!

View 2 Replies View Related

Configuring Mail For SQL Server Agent - Problem With Exchange And Outlook On Same Machine?

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

Database Mail With Yahoo Business Mail Server

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

SQL Server 2000 Mail Agent For Use With A POP Server ?

Mar 20, 2001

Hi
I would like to know if it's possible to use pop3 server protocol instead of MAPI application to cause SQL Server 2000 sends email to an Administrator when anormal event comes ?
i.e, configure a pop profile to receive sql server 2000 error

Thanks for all repply

Michel

View 1 Replies View Related

Jan 30, 2006

I've just installed and configured outlook 2003 with sql agent mail and I've come across a strange conundrum: messages from agent mail are not actually sent unless the outlook client is open, but the default mail folder is locked by agent when agent is started, thus preventing outlook 2003 from opening. If I try things the other way - opening the client and then configuring/restarting agent mail - then agent mail can't access the default mail folder because the client has it locked.

There doesn't seem to be any way to win here.

Anyone come across this issue and found a workaround?

View 4 Replies View Related

Send Mail Task Failing Under SQL Agent

Nov 9, 2006

Using SQL 2005, SSIS, I have an SSIS package which is scheduled as a SQL Server Agent job. The package contains a Send Mail task. This task fails when SQL Agent runs the package. The task succeeds when executed interactively from the package, logged on as the SQL Agent service account. The package as a whole succeeds when executed from "Start Debugging". An Execute SQL Task in the same package containing an sp_send_dbmail statement succeeds when SQL Agent runs the job, and the same sp_send_dbmail succeeds in Mgmt Studio query window. All these events all logged onto the server as the SQL Server/SQL Agent service account.

I would appreciate ideas on what else to check for here, so that I can use the Send Mail SSIS task in packages which are run by SQL Agent jobs.

Thanks, Holly

View 1 Replies View Related