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.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-04-17 : 07:34:37
|
| Kumar Narayanan writes "Hello FolksI am encountering a MAPI error while trying to configure SQl MAILS.When I ran xp_startmail under query analyzer it gave ERROR NUMBER 17952.It also asked me to provide a valid MAPI profile.Can someone help?I am a complete novice to this..SQl version:7.0 with no service packoutlook express version 5.0warm regards" |
|
|
samsekar
Constraint Violating Yak Guru
437 Posts |
|
|
shaidh
Starting Member
5 Posts |
Posted - 2003-04-17 : 08:41:48
|
| I have configured SQL Mail to work with our exchange server and it was really straightforward surprisisngly. If you have an exchange server and use SQL 2000 than read. Within SQL Enterprise manager and expands your server node, you should see 'Support services. Beneath this should reveal a child node called SQL MAIL. Right click this node and click properties, enter your exchange server. This should be valid MAPI profile, ie. Outlook should be setup on the machine to send and recieve emails.Click Test, and your MAPI service will be started and stopped, if this succeeds than you have won a prize of following my instructions.Goto SQL Query Analyser and enter the following:-EXEC master xp_sendmail 'someone@somewhere.com',@subject = 'SQL Server Report',@message = 'This is a test to see how I can send email messages',Hope this helps |
 |
|
|
|
|
|
MAPI Error while configuring SQL mail