In addition to changing the account name, SQL Server Configuration Manager performs additional configuration such as setting permissions in the Windows Registry so that the new account can read the SQL You cannot post HTML code. Will bump this thread if/when I find out, however I suspect I will be handed the task of installing SQL Server/Outlook on a member server rather than the PDC/SBS/EXCHANGE server. As for step 1, Microsoft recommends "Do not run the SQL Server Agent service under a Microsoft Windows account that is a member of the Windows Administrators group."http://technet.microsoft.com/en-us/library/ms190926.aspx step 2, I've Check This Out
Add the user if it is not present under the following policies. If that does not work, change the SQL Server Agent account to SQL Server Services account or other account. I have tried to stop and restart the SQL Server Agent services but still receive the same error. I can send and receive mail from Outlook when logged into the server but I receive the following error when testing the profile in SQL Mail and SQL Server Agent properties:
My AccountSearchMapsYouTubePlayNewsGmailDriveCalendarGoogle+TranslatePhotosMoreShoppingWalletFinanceDocsBooksBloggerContactsHangoutsEven more from GoogleSign inHidden fieldsSearch for groups or messages Register Help Remember Me? Message  Unable to start mail session (reason: Microsoft.SqlServer.Management.SqlIMail.Server.Common.BaseException: Mail configuration information could not be read from the database. ---> System.InvalidCastException: Unable to cast object of type 'System.DBNull' to type 'System.Byte'. You cannot edit your own events.
Copyright © 2002-2016 Redgate. Check the registry HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.1\SQLServerAgent, and ensure UseDatabaseMail is 1. At this point, I'm just trying to understand why using the Microsoft recommended security settings does not work, or what I've missed. It sounds like a nice solution, and in some cases it is a nice solution.
Jones Posted Wednesday, February 27, 2008 9:30 AM SSC-Enthusiastic Group: General Forum Members Last Login: Monday, November 3, 2014 8:29 AM Points: 119, Visits: 548 in the past I've used a  The Messenger Service Has Not Been Started - Netsend Notifications Will Not Be Sent Jones - Database Tech. It has full 64 bit support. https://support.microsoft.com/en-us/kb/953321 I did double check that though Reply With Quote 02-23-04,07:01 #4 rhigdon View Profile View Forum Posts Registered User Join Date Oct 2001 Location Naples, FL Posts 273 Maybe these help
Still no luck with alerts when running with the sql agent domain account. The sqlagent account has full database permissions, but still will not start the mail session when sqlagent starts. BobGriff on Wed, 12 Mar 2014 16:30:44 Steps to reproduce: 1) create [email protected] domain user 2) add [email protected] domain user to SQLServerSQLAgentUser$myserver$myinstance local computer group 3) change sqlagent service startup account Did changing the SQL Server Agent account cause this to fail?
Thanks, Robert BobGriff on Thu, 13 Mar 2014 14:48:27 Problem solved. his comment is here The time now is 19:45. Do I need to install a service pack for SQL Server? That works fine, however in sql server agent properties the mail session section on the first general tab appears to be greyed out.
Forum New Posts FAQ Calendar Forum Actions Mark Forums Read Quick Links Today's Posts View Site Leaders What's New? Here is my first post since i have joined SQL Server Central. Thanks.BobGriff on Fri, 21 Feb 2014 15:26:35 Followed all suggestions with no luck. this contact form Report Abuse.
all pretty standard damn it Reply With Quote 02-23-04,17:51 #6 JDionne View Profile View Forum Posts Visit Homepage Registered User Join Date Aug 2002 Location Charlotte NC Posts 665 Originally posted then if i go in proprieties of sql server agent in alert system my changes aren't saved. You cannot post replies to polls.
Post #460795 henri flokstrahenri flokstra Posted Wednesday, February 27, 2008 5:36 AM SSC Rookie Group: General Forum Members Last Login: Monday, February 22, 2010 12:59 AM Points: 25, Visits: 177 @Dustin, Toggle navigation Questions and Answers Azure development Sql Azure C# Sharepoint Best gaming deals on Amazon This weeks Xbox deals with gold SQL Server 2008 R2 SP2 dbmail won't send alerts, Try to run SQL Management studio in administrator mode and try to configure database mail on sql server installed system. You cannot post or upload images.
This article explains exactly how to used the SQL Server Configuration manager: http://technet.microsoft.com/en-us/library/ms345578(v=sql.105).aspx Thanks for everyone's replies, Robert Latest posts in the category COLUMNS_UPDATED() Returning Unexpected Results Database email issue for You cannot post IFCode. Advanced Search Forum Database Discussions MS SQL Server 7/MS SQL Server 2000 SQL Mail MAPI error If this is your first visit, be sure to check out the FAQ by clicking http://popupjammer.com/unable-to/unable-to-update-auto-refresh-reference-39-telerik-web-ui-dll-39-cannot-find-assembly.html What we do see is an alert in the server log after a restart from the SQL Server Agent service: "Unable to start mail session (reason: No mail profile defined)".
Reply With Quote Quick Navigation Microsoft SQL Server Top Site Areas Settings Private Messages Subscriptions Who's Online Search Forums Forums Home Forums Non-SQL Forums MongoDB Database Server Software Adabas DB2 Informix Good work!! I looked the log of sql server agent and i saw this error:  Unable to start mail session (reason: Unable to logon (reason: MAPI Logon failed); check the mail profile