Not able to send Mails using SQL Mail

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

Not able to send Mails using SQL Mail

Author

Topic

vyelchri
Starting Member

12 Posts

Posted - 2009-05-21 : 09:18:19

Hi

i am not able to send emails in MS Sql server 2000.

Following are the steps i did while configuring sql mail:
1. Created one domin account (Administrator)
2. Login into the system with domain account (OS:Windows Server 2003)
3. Installed MS Office 2003
4. Configured one email account with "SQLMailService" as profile name
5. Opened Enterprise Manager from Start > Programs > Microsoft SQL Server > Enterprise Manager. Next, right-clicked on SQL Server and chosen Properties, then choose the Security tab. Under the Startup Service Account, given the domain account user name and password
EX: User name: domain-namepassword: xxxxxxxx
6.Next expanded SQL Server > Management, then right-click on SQL Server Agent and chosen Properties . On the General Page, under the Service Startup Account given the domain account user name and password. And in the Mail Session given the out look profile name and clicked on "Test", Successfully started ( and stopped) a mail session with this profile message came.
7. Expanded Support Services folder and clicked on Properties of SQL Mail. Here also given the same Out look profile name and clicked on Test button, Successfully started ( and stopped) a MAPI session with this profile message came.
8. Expanded Management -> SQL Server Agent, right click on Operators and selected new operator. Here email address given and clicked on Test button immediately one message is coming "This will send the message ---- the group with the address ----- ok to send?. when i clicked on OK,

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. message is displaying.

i checked many times that all the services are running.

can any body plz help me where i did wrong?

Thanks,
VB

vyelchri
Starting Member

12 Posts

Posted - 2009-05-22 : 00:18:22

Can any body plz asist me to resolve this issue

Thanks,
VB

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources