Sql server 2000 sql mail yapilandirma hk

Merhaba

http://www.cozumpark.com/blogs/sql/archive/2008/05/09/sql-mail-ve-sql-mail-agent-yap-land-rmak.aspx

Hakan hocam bu makeleyi okudum fakat exchange tabanlı bir mail adresim yok mail host disarida tutuluyor bu yuzden

2. Adım Olarak SQLServer’ı Bir Posta İstemcisi Olarak Yapılandırmak.  bu adimda kaliyorum exchange mail kutusu olusturamadigim icin bu konuda yardimci olursaniz sevinirim Server uzerinde pop3 mail hesabi olusturduktan sonra sql mail configuration olsuturmus oldugum profile name kismini secip test dedigimde error:18025 xp_test_mapi_profile failed with mail error hatasi almaktayim ama outlook sorunsuz bir sekilde calismaktadir bu hatayi henuz asmadim

çözüm

I've also faced the same problem "Error 18025:xp_test_mapi_profile:
failed with mail error 0x80040111"

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...

Hakan hocam cok tesekkurler yukarida soylemis oldugunuz yolu izledim ve sorun cozume kavusmus oldu ne varsa ingilizce dokumanlarda var yine 🙂

olur mu ? ne varsa Çözümpark' ta var 🙂

Tabii ki Hakan hocam orasi tartisilmaz iyiki varsiniz sayenizde cozumu olmayan soru kalmiyor 🙂

Saygilarimla.

ben değil portal bir ekip işi  🙂 hepimizin katkıları ile oluyor bunlar...