SQL Mail

[daerath]

I’ve encountered a problem with SQL Mail and none of the existing KB articles seem to provide a solution. Simply put, I can’t get SQL Mail to start.

Several weeks ago I configured SQL Mail on a SQL 7 box running Windows 2000 and the latest service packs for both SQL Server and Windows. At the same time I also configured a SQL 2000 box running Windows 2000, again both had the latest service packs. At this point both servers were running SQL Mail without problem.

SQL Server and the SQL Server Agent are both running under the same account, called SQLService. This account has local administrator privileges on this box. This account is also a user of the domain and does have a mailbox on the Exchange server. When I configured this account’s exchange profile I did so by logging onto the SQL7 box as SQLService. I then configured SQL Mail while still logged on as SQLService.

Now, on to the problem.

On the 2nd of July, when attempting to start SQL Mail on SQL 7 I received the following error:

Error 22030: A MAPI error (error number: 273) occurred.: MapiLogonEx failed due to MAPI error 273: MAPI logon failed.

The SQL Logfile contained errors 17903 and 17951, both severity 18, state 1.

If I log on to the SQL7 box as SQLService I can send and receive email through Outlook.

While attempting to correct this problem I was able to get SQL Mail functioning for several minutes, but whenever I would press the “test” button on the SQL Server Agent Properties page (Mail session section) or on the SQL Mail Configuration page, I received the above MAPI error. In spite of this error I was able to start the SQL Mail service and could send mail successfully. I then rebooted the server and when it came back up I was unable to restart the service.

The SQL 2000 box does not have this problem and SQL Mail is still running properly.

Any thoughts?

 

[Flloyd]

You might want to try and reset the logon account/password for the sqlserveragent service and restart on the SQL7 box. Then reset the service startup account via SEM for the 'SQL Server Agent' to the same account and password.

Afterwards, set the Mail Session profile and test from the same properties tab. Just for posterity, go down to the SQL Mail object and do the same thing on the properties window for it.

Lloyd Freiday

 

[daerath]

I was able to resolve the problem, but I'm not sure what I did that fixed the problem.

I reentered the password for the SQLService account under Services, and inside SEM at the "Service startup account" section. The password had not changed.

I also recreated the Exchange Profile for SQLService and reselected it within SQL Server Agent and SQL Mail. Prior to reselecting it I made it a point to select an entirely different profile.

My thought at the moment is that each exchange profile has a unique ID and this ID is what was stored within SEM. When I recreated the profile I had to reselect it to get the new profile ID.

That could also be totally wrong, but in any event, it works again.

Thanks!