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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 SQLMAIL

Author  Topic 

CleaBoe
Starting Member

4 Posts

Posted - 2001-02-09 : 14:07:02
I have a server that has been running SQLMAIL for about 2 years using the same account to run the services that has access to the mailbox and have experienced no problems. About a month ago Mail didn't start when the machine was rebooted, I can test the profile via "support services > SQL Mail" successfully and also via the SQL Agent properties but I cannot start mail. SQLMAIL shows as starting in the SQL Log with no subsequent "Mail session started" later on in the log. I have upgraded to Outlook 2000 on the server, rebooted, then replaced the .dll with one from another server that I know is okay, disabled mail upon start-up and re-booted, killed MAPI32.exe process that seems to hang around and manually started mail using xp_startmail. The extended stored procedure goes into "hang mode" and freezes Enterprise Manager. I have tried starting mail about 20 times in the last 3 weeks to no avail. I have gone through and tested permissions using the \\NET USE \\<computername>\IPC$ to ensure I have permissions and nothing seems to be working.
I know the account that both agent and sql run under has access to the mailbox as I can run mail logged onto the server as this account. Does anyone have any suggestions ?

Thanks in advance,
Clea

   

- Advertisement -