Xpoint
   [напомнить пароль]

MSSQL2005: Database mail - Не могу настроить

Метки: [без меток]
2007-05-31 13:35:21 [обр] Top manager(0/2)[досье]

Толи я тормоз, толи система глючная. Не могу настроить, всё сделал:

sp_configure 'Database Mail XPs', '1'
GO
RECONFIGURE
GO
PRINT 'Creating a SQLMail' 
EXECUTE msdb.dbo.sysmail_add_profile_sp
   @profile_name   = 'SQLMail',
   @description    = 'Profile description...'
GO

--  First Account
PRINT 'Creating DBMail SQLMail' 
EXECUTE msdb.dbo.sysmail_add_account_sp
   @account_name       = 'SQLMail',
   @description        = 'Account description...',   
   @email_address      = 'user@kz.kz',
   @display_name       = 'DBMail SQLMail',
   @mailserver_name    = '127.0.0.1' 
GO

PRINT 'Tie the accounts to the profile'
EXECUTE msdb.dbo.sysmail_add_profileaccount_sp
   @profile_name   = 'SQLMail',
   @account_name   = 'SQLMail',
   @sequence_number= 1
GO

-------------------------------------------------------
-- Send an email
-------------------------------------------------------

EXECUTE msdb..sp_send_dbmail
   @profile_name  = 'SQLMail',        
   @recipients  = 'user@kz.kz', 
   @subject  = 'database Mail:  Account Failover Test',
   @body  = 'Testing account failover'

После в логе...

Date      5/31/2007 3:29:06 PM
Log      Database Mail (Database Mail Log)

Log ID      21
Process ID      5532
Mail Item ID      9
Last Modified      5/31/2007 3:29:06 PM
Last Modified By      sa

Message
The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 3 (2007-05-31T15:29:06). Exception Message: Cannot send mails to mail server. (Syntax error in parameters or arguments. The server response was: Syntax error).
)
спустя 3 дня [обр] Кирилл [Kirk] Королев(88/673)[досье]
because of the mail server failure
Уверены, что смтп-сервер - это локалхост?
спустя 3 минуты [обр] Top manager(0/2)[досье]
Кирилл [Kirk] Королев[досье] :) Абсолюдно
Powered by POEM™ Engine Copyright © 2002-2005