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 |
|
kid_on_the_block
Posting Yak Master
172 Posts |
 Posted - 2005-11-21 : 13:26:22
|
| Hi I just ran the following command & got the following result Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05 Copyright (c) 1988-2003 Microsoft Corporation Enterprise Evaluation Edition on Windows NT 5.0 (Build 2195: Service Pack 4)Thus as per my knowledge is has Service Pack 4 , which is the latest.Now i have even configured the Microsoft Outlook client & am able to send & recieve mails.But then i try to configure the SQL Mail it says Error 18030:xp_test_mapi_profile:Either there is no defaultmail client or the currrent mail client cannot fulfill the messagong request.Please help. |
|
|
druer
Constraint Violating Yak Guru
314 Posts |
Posted - 2005-11-21 : 15:55:53
|
| You need to create a user on the server and configure it for Outlook. Then you need to change the Server and SQL Server Agent properties to login as that user, then you'll be able to choose that users default mail profile. Basically SQL Server needs to have a MAPI client profile to start with in order for it to send mail. |
 |
|
|
kid_on_the_block
Posting Yak Master
172 Posts |
Posted - 2005-11-22 : 12:08:06
|
| Thanks Druer I did that I have logged in as a domain administrator & have created a profile of the email with that login , even the services use that same user account Still its not allowing me to configure the SQL MAil Please help |
|
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2005-11-22 : 21:31:01
|
| 8.00.760 --That is SP3, not SP4.Make sure you haven't setup a .PST file for the account. Some people make that mistake which causes issues. Just keep all the email on the server.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
|
|
|
SQL Mail not getting configured