I am trying to setup the mail service on an SQL7
When I am openning 'Support Services', 'SQL Mail',
On the profile ListBox Is empty so I write the name of the exchange server or profile name, I Tryed both. but when I am pressing TEST I am getting:
'Error 22030:(A MAPI Error (273 occured: MapiLogonEx failed do to MAPI Error 273:MAPI Logon faild'
What am I am doing wrong where can I see the right profile name?
1) Create a dedicated (local) NT Account (ie admsql), with local administrator permissions, strong password,
cannot change password, password never expires
2) Let all SQL services run under that account (restart the services after this)
3a) Log on to the NT Server with that account
3b) Create a MAPI profile (i name that one generally SQLMAIL), test the profile (with Outlook 2000 in
your case).
4a) Log off/Log on to the NT Server
4b) Start the EM, and configure SQLMail, where the profile SQLMAIL should appear (as only one) in the
combobox...
4c) Configure also the SQL Server Agent's SQLMail (same selection)
4d) restart SQL Server services...
If you (still) get the error, please indicate at which step..
CHeers