Error 22022 Sql Server Mail Session Not Running
Contents |
Start here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of
Sql Server Error 22022 Job Is Already Running
this site About Us Learn more about Stack Overflow the company Business Learn microsoft sql server error 22022 job is already running more about hiring developers or posting ads with us Server Fault Questions Tags Users Badges Unanswered Ask Question _
Error 22022 Sql Server 2012
Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute: Sign up Here's how it works: Anybody can ask a question Anybody sql server error 22022 job suspended can answer The best answers are voted up and rise to the top How do I enable e-mail alerts in SQLServer? up vote 1 down vote favorite I'm trying to enable e-mail alerts for an operator in SQL Server (2000). When I try to test the e-mail, I get the following message: Error 22022: SQLServerAgent Error: The SQLServerAgent mail session is not running; check the error 22022 sql server 2008 r2 mail profile and/or the SQLServerAgent service startup account in the SQLServerAgent Properties dialog. When I open [Server].Management.[SQL Server Agent] in Enterprise Manager, The only option that seems at all relevant is the "Mail Session" section; but the "Mail Profile" field (and everything else in the box) has been grayed out. How do I get those fields enabled? email sql-server share|improve this question edited Aug 24 '09 at 13:12 Alex Angas 1,53312234 asked Jul 13 '09 at 20:49 BIBD 92452137 add a comment| 2 Answers 2 active oldest votes up vote 4 down vote accepted You need to install Outlook on the server, log on as the account you use to run SQL server under and configure Outlook. See also, KB311231. share|improve this answer answered Jul 13 '09 at 20:54 ThatGraemeGuy 11.2k73873 add a comment| Did you find this question interesting? Try our newsletter Sign up for our newsletter and get our top new questions delivered to your inbox (see an example). Subscribed! Success! Please click the link in the confirmation email to activate your subscription. up vote 2 down vote Right-click on the server, click on Properties, then verify that your
New? Advanced Search Forum Database Discussions MS SQL Server 7/MS SQL Server 2000 SQL Mail Not Working If this is your first visit, be sure to check out the FAQ by clicking the
Microsoft Sql Server Error 22022 Replication
link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. Results 1 to 5 of 5 Thread: SQL Mail Not Working Tweet Thread Tools Show Printable Version Email this Page… Subscribe to this Thread… Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode 10-19-2001,07:50 PM #1 Denise http://serverfault.com/questions/40139/how-do-i-enable-e-mail-alerts-in-sqlserver Guest SQL Mail Not Working Hi, I'm trying to send an email notification test. I get an error that reads as follows: Error 22022: SQL Server Agent Error: The SQL Server Mail Session is not running; check the mail profile and/or the SQL Server Agent service start up account in the SQL Server Agent Properties dialog. I viewed the SQL Mail properties and it shows Start. Any Suggestions? Thanks, Denise Reply With http://forums.databasejournal.com/showthread.php?15181-SQL-Mail-Not-Working Quote 10-22-2001,05:51 AM #2 David Guest SQL Mail Not Working (reply) Hi, Do you have a mail profile set-up on the server. (MS Outlook or Exchange). If not, install MS Outlook. If so, right click on the Mail icon on the desktop on the server and select properties. Click on the Show Profiles button. What is the name of the profile that starts when using MS Outlook? It should be something like MS Exchange Settings. This profile must be for the Account that starts your SQL Services. If that account does not have a mail profile, log on as that account and create one. If it does have a mail profile, then THAT name (MS Exchange settings) must be the name in SQL mail (under support services), and also in SQL Agent (under management). Hope this helps... David ------------ Denise at 10/19/01 8:50:11 PM Hi, I'm trying to send an email notification test. I get an error that reads as follows: Error 22022: SQL Server Agent Error: The SQL Server Mail Session is not running; check the mail profile and/or the SQL Server Agent service start up account in the SQL Server Agent Properties dialog. I viewed the SQL Mail properties and it shows Start. Any Suggestions? Thanks, Denise Reply With Quote 10-23-2001,02:23 PM #3 De
for Help Receive Real-Time Help Create a Freelance Project Hire for a Full Time Job Ways to Get Help Ask a Question Ask for Help Receive Real-Time Help Create a Freelance Project Hire for a Full Time Job Ways to Get Help Expand Search Submit Close Search Login Join https://www.experts-exchange.com/questions/21627245/Error-22022-when-test-emai-on-Sql-Server-Agent-Operator.html Today Products BackProducts Gigs Live Careers Vendor Services Groups Website Testing Store Headlines Experts Exchange > https://blogs.msdn.microsoft.com/karthick_pk/2009/01/14/unable-to-start-sqlserver-agent-resource-on-cluster-after-upgrading-to-9-00-3186-or-higher/ Questions > Error 22022 when test emai on Sql Server Agent Operator Want to Advertise Here? Solved Error 22022 when test emai on Sql Server Agent Operator Posted on 2005-11-10 MS SQL Server 1 Verified Solution 6 Comments 14,294 Views Last Modified: 2012-05-05 Hi experts I got the following error when I tested emailing to the operator in Sql Server Agent. "Error 22022 : error 22022 SQLServerAgent Error. The SQLServerAgent mail session is not running; check the mail profile and/or the SQLServerAgent service startup account in the SQLServerAgent properties dialog." However, if I stopped and then started the SQL Server Agent again, I can send email to the operator successfully. The problem happened again when the server is restarted. Here are some checks on my server. - Running SQL2000 on SBS2003 (WIN2003). Outlook client 2003. - Mail profile is using Exchange 2003, not POP3 - sql server error Mail Profile test in Sql Server Agent is alway OK even though I cannot send email to operator. - SQL Server Agent service startup account = SQL server service startup account = mail profile mail box AD account - SQL server agent is set to start automatically with Sql Server (which is not the default setting. I don't understand why?) Have you came acrossed situation like this? Edwin 0 Question by:Edwin_C Facebook Twitter LinkedIn Google Best Solution bymodulo Closed, 500 points refunded. modulo Community Support Moderator Go to Solution 5 Comments LVL 13 Overall: Level 13 MS SQL Server 6 Message Expert Comment by:TommyTupa2005-11-11 I had a similar problem which became solved with the install of sp3a and a reboot. Is this installed on your server? 0 LVL 16 Overall: Level 16 MS SQL Server 1 Message Author Comment by:Edwin_C2005-11-11 Hi Tommy I have SP4 installed. Thanks for your advice anyways. Edwin 0 LVL 16 Overall: Level 16 MS SQL Server 1 Message Author Comment by:Edwin_C2005-11-14 If the cause of the problem is unknown, I can restart the SQLAgent Service everytime after rebooting the server as workaround. How can I do that automatically? 0 LVL 16 Overall: Level 16 MS SQL Server 1 Message Author Comment by:Edwin_C2005-11-22 After consulting MS support, it appeared (not proved) that the problem was caused by having the SqlServerAgent service started too early when Exchange service is not
on cluster after upgrading to 9.00.3186 or Higher ★★★★★★★★★★★★★★★ Karthick P.K - karthick krishnamurthyJanuary 14, 20095 0 0 0 Error=== 2008-03-19 23:06:23 - ? [100] Microsoft SQLServerAgent version 9.00.3186.00 (x86 unicode retail build) : Process ID 24282008-03-19 23:06:23 - ? [101] SQL Server SNETNAME version 9.00.3186 (0 connection limit)2008-03-19 23:06:23 - ? [102] SQL Server ODBC driver version 9.00.30422008-03-19 23:06:23 - ? [103] NetLib being used by driver is DBNETLIB.DLL; Local host server is 2008-03-19 23:06:23 - ? [310] 4 processor(s) and 2560 MB RAM detected2008-03-19 23:06:23 - ? [339] Local computer is SNETNAME running Windows NT 5.2 (3790) Service Pack 22008-03-19 23:06:23 - ? [432] There are 11 subsystems in the subsystems cache2008-03-19 23:06:38 - ! [364] The Messenger service has not been started - NetSend notifications will not be sent2008-03-19 23:06:38 - ? [129] SQLSERVERAGENT starting under Windows NT service control2008-03-19 23:06:38 - + [260] Unable to start mail session (reason: No mail profile defined)2008-03-19 23:06:38 - + [396] An idle CPU condition has not been defined - OnIdle job schedules will have no effect2008-03-19 23:06:38 - + [408] SQL Server MSSQLSERVER is clustered - AutoRestart has been disabled2008-03-19 23:06:39 - ! [298] SQLServer Error: 22022, CryptUnprotectData() returned error -2146893813, ‘Key not valid for use in specified state.' [SQLSTATE 42000] 2008-03-19 23:06:39 - ! [442] ConnConnectAndSetCryptoForXpstar failed (0).2008-03-19 23:06:40 - ? [098] SQLServerAgent terminated (normally) Error2=====2008-03-18 12:18:30 - ? [100] Microsoft SQLServerAgent version 9.00.3200.00 ((Unknown) unicode retail build) : Process ID 65122008-03-18 12:18:30 - ? [101] SQL Server PISTONDIST version 9.00.3200 (0 connection limit)2008-03-18 12:18:30 - ? [102] SQL Server ODBC driver version 9.00.30422008-03-18 12:18:30 - ? [103] NetLib being used by driver is DBNETLIB.DLL; Local host server is np:pistondist2008-03-18 12:18:30 - ? [310] 16 processor(s) and 32765 MB RAM detected2008-03-18 12:18:30 - ? [339] Local computer is PISTONDIST running Windows NT 5.2 (3790) Service Pack 22008-03-18 12: