June 23, 2009 at 10:48 pm
Hi pls explain
How to configure Sql Mail in sqlserver 2000
i need to send/receive a mails from sqlserver 2000 express edition
Thanks in advance
June 23, 2009 at 11:09 pm
If you want to sent emails from SQL Mail in SQL Server 2000, the windows SQL Server login account and exchange server should be in one domain. then only u can send emails after configuring SQL Mail.
Following are the steps to do for configuring sql mail:
1. Creat one domin account (Administrator)
2. Login into the system with domain account (OS:Windows Server 2003)
3. Make sure MS Office 2003 installed.
4. Configure one email account with "SQLMailService" as profile name
5. Open Enterprise Manager from Start > Programs > Microsoft SQL Server > Enterprise Manager. Next, right-click on SQL Server and choose Properties, then choose the Security tab. Under the Startup Service Account, give the domain account user name and password
EX: User name: domain-name
password: xxxxxxxx
6.Next expand SQL Server > Management, then right-click on SQL Server Agent and choose Properties . On the General Page, under the Service Startup Account give the domain account user name and password. And in the Mail Session given the out look profile name and click on "Test", Successfully started ( and stopped) a mail session with this profile message will come.
7. Expand Support Services folder and click on Properties of SQL Mail. Here also give the same Out look profile name and click on Test button, Successfully started ( and stopped) a MAPI session with this profile message will come.
8. Expand Management -> SQL Server Agent, right click on Operators and select new operator. Here give email address and click on Test button immediately one message will come "This will send the message ---- the group with the address ----- ok to send?. when u click on OK, "email sent to ....." message will be displayed.
if u get email sent successfully message u are able to send emails using xp_sendmail stored procedure also
June 24, 2009 at 1:06 am
June 25, 2009 at 6:41 am
How did you create the mail profiles for sql server and sql agent services?
iam using sqlserver 2000 sp2
when i tried to test sql profile iam getting this error
Error 18025:xp_test_mapi_profile: failed with mail error 0x80040111
reply soon pls
thanks in advance
June 25, 2009 at 9:20 pm
Creating mail profile is nothing but creating outlook profile. and add that out look profile to SQL Mail.
Looks like some mistakes happened while creating outlook profile.
Follow the above steps mentioned in my thread.
recently i also configured SQL Mail in the same way.
If your outlook domain and SQL Server loging account should be in the same domain, then only u will send emails from sql server. if those two are not in same domain u will not send emails
June 26, 2009 at 12:47 am
HI GUYS
But finally I got the solution and resolved.
To resolve this problem:
1. I changed Log On information of MSSQLServer from Windows Services.
2. I also changed Log On information of SQLServerAgent from Windows
Services.
To do 1 & 2 go to Windows Services window, select MSSQLSERVER and
SQLSERVERAGENT services one by one. Select Log On tab. Select "This
Account" option button instead of "Local System Account" option button.
And put my domain user acount and password as domain\userid. Domain must be the same to which I was logged in. And lastly restarted the services.
3. Then I configured Profile information. To do this explore Control
Panel. Click on Profile icon. Removed the added email account
information and then added it again.
4. Now open Enterprise Manager of SQL and went to Database Server
Properties window. Selected Server Setting tab. Clicked on Change button in area SQL Main and select the profile from the combo.
5. Now I went to SQL SErver Agent's propeties window and selected the
prfile name in Mail Session area.
6. Again I restarted MSSQLSERVER, SQLSERVERAGENT, Performance Log and
Alerter services from Windows Services window.
And it worked...
This might help u...
but finally iam getting this error
after executing the query
Error Sending e-mail.
CDO.Message.1
The transport failed to connect to the server.
pls suggest for futher action
Thanks in advance
*** Sent via Developersdex http://www.developersdex.com ***
June 26, 2009 at 6:55 am
Are you sure the SQL Server box can communicate with your email box? Try logging on as the service account, open outlook and try to send an email from there to yourself. If it doesn't get through, you have to fix that before it will work from inside SQL Server.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply