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 |
|
sujith
Starting Member
20 Posts |
 Posted - 2005-06-08 : 01:28:21
|
| I tried to configure SQL Mail with Microsoft Outlook 2003 to fetch mails from my inbox. I used xp_startmail with profile name and password as parameters. It gave the following error."xp_startmail: Your SQL Server Service is running under the local system account. You need to change your SQL Server Service account ro run under a domain account in order to complete this operation"I searched for this error in microsoft.com. Search gave the following link :http://support.microsoft.com/default.aspx?scid=kb;en-us;292761Is there anybody who has faced this problem earlier and resolved it or who knows anything in detail about it? Please help me out for this...Sujith S |
|
|
raclede
Posting Yak Master
180 Posts |
Posted - 2005-06-08 : 01:38:30
|
Have you tried doing as what the article has said.SYMPTOMSIf the MSSQLServer Service startup account is set to the local system account, xp_startmail fails with the following error message: Server: Msg 18025, Level 16, State 1, Line 0xp_startmail: failed with mail error 0x80040111 It is not apparent from the error message that the MSSQLServer Service should be configured to use a domain account rather than the system account in order for SQL Mail to function properly. ORRESOLUTIONTo resolve this problem, obtain the latest service pack for SQL Server 2000. For additional information, click the following article number to view the article in the Microsoft Knowledge Base: 290211 INF: How to Obtain the Latest SQL Server 2000 Service Pack "If the automobile had followed the same development cycle as the computer, a Rolls-Royce would today cost $100, get a million miles per gallon, and explode once a year, killing everyone inside. " raclede |
 |
|
|
sujith
Starting Member
20 Posts |
Posted - 2005-06-08 : 02:04:53
|
| I have done it. I have installed SQL server SP3a. But still the problem persists.My system has :Windows 2000 ProfessionalMS Outlook 2003SQL server 2000 with SP3aSujith S |
|
|
|
|
|
|
Configuring SQL Mail with MS Outlook 2003