
	Home > Ask the SQL Server Experts > Kevin Kline - Monitoring/Administration Questions & Answers > SQL Mail troubleshooting

Ask The SQL Server Expert: Questions & Answers

EMAIL THIS

SQL Mail troubleshooting

EXPERT RESPONSE FROM: Kevin Kline

		Pose a Question

		Other SQL Server Categories

		Meet all SQL Server Experts
		Become an Expert for this site

Digg This!

StumbleUpon

Del.icio.us

QUESTION POSED ON: 22 November 2005
I currently have two instances of Microsoft SQL Server 2000. I tried to set up e-mail notification on my new server, but it does not work. I am using the same domain account for both servers. I have followed all the instructions and settings are identical to the older one, on which e-mail works perfect. I have tested MS Outlook with the profile for SQL system account on that server. The SQLMail profile test works, but when I try to send e-mail to an operator I get this message:
"Error 22022: SQL ServerAgent Error: The SQL ServerAgent mail session is not running; check the mail profile and/or the SQL Server Agent service startup account in the SQLServerAgent Properties dialog."

Any suggestions?

Digg This!

StumbleUpon

Del.icio.us

RELATED CONTENT

	Kevin Kline - Monitoring/Administration
	Publisher residing on a different domain
	Installing SQL Server client tools on Windows XP Pro
	Incorrect drive letter assignments
	Installing SQL Server 2000 Enterprise Edition on Windows XP
	Identifier field in Microsoft's SQL Server
	Getting scheduled DTS packages to run
	Performance problems after installing Windows Service Pack 4
	Improve performance by spreading data
	Difficulties transferring stored procedures and triggers
	Shrinking database and log files

Microsoft SQL Server Administration

Recovery Model Options in SQL Server

Run SQL 2000 and SQL 2005 instances at the same time

SQL Server backup and restore fundamentals

SQL Server 2005 Books Online

SQL Server 2005 T-SQL debugging alternatives

All-in-One Guide: SQL Server backup and recovery

SQL Server Management Studio client tool enhancements

Microsoft SQL Server Administration Research

SQL Server Security

The keys to database backup protection for SQL Server

Understanding transparent data encryption in SQL Server 2008

The fine line between not encrypting your databases and breach notification

Securing SQL Server with access control, login monitoring and DDL triggers

SQL Server security: Controlling access via database roles

Implementing security audit in SQL Server 2008

New security features in SQL Server 2008 leave some work for you

Can I encrypt and restore a database backup in SQL Server 2005?

FAQ: How to troubleshoot and grant SQL Server permissions

Secure SQL Server from SQL injection attacks

RELATED GLOSSARY TERMS

Terms from Whatis.com − the technology online dictionary

Yukon (SearchSQLServer.com)

RELATED RESOURCES

2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems

Search Bitpipe.com for the latest white papers and business webcasts

Whatis.com, the online computer dictionary

SQLMail is troublesome and the reason for many support calls.

Your biggest issue, in my opinion, is the security context that SQL Server Agent is running under. Test SQLMail using the Windows user ID that the SQL Server Agent runs under.

You must first provide SQLMail with the Outlook mail profile used to test the mail client configuration. To do so, go to Enterprise Manger, then Support Services folder, right click SQL Mail and choose Properties.

You must then provide the mail profile to SQL Server Agent. To do so, go to Enterprise Manager, then Management folder, right click SQL Agent and choose Properties.

Do you have comments on this Ask the Expert Q&A? Let us know.

Search and Browse the Expert Answer Center
Search and browse more than 25,000 question and answer pairs from more than 250 TechTarget industry experts.

Browse our Expert Advice
Operating Systems IT Management Networking Database	Security Servers and Storage Applications and Development Career Center

SQL Solutions - SQL Database Design

SEARCH

TechTarget provides technology professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective purchase decisions and managing their organizations' technology projects - with its network of technology-specific websites, events and online magazines.


TechTarget Corporate Web Site \| Media Kits \| Site Map All Rights Reserved, Copyright 2005 - 2009, TechTarget \| Read our Privacy Policy