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 |
|
dontipton
Starting Member
8 Posts |
 Posted - 2002-02-06 : 09:05:35
|
| I have SQL Server 2000 EE(SP1) installed on Windows 2000 Advanced Server (SP2) and OutLook 2000 (version 9.0.0.3821) for SQL Mail. I created my outlook profile using the same domain account that is responsible for starting the MSSQL Server service and the SQL Agent Service. When I first configured everything mail was working fine. After a couple of weeks the mail stops working. If I try xp_sendmail in Query Analyzer the query hangs and I have to cancel the window using task manager. If I try to test SQL Mail within Enterprise manager the window hangs and must be killed using task manager. If I do a test mail to an operator the server says the mail has been sent successfully, but the mail never arrives. After a reboot for maintenance the mail started working again for about two weeks and then stopped working again.Has anyone run into this problem?I have checked the MAPI32.DLL file located in Winnt\system32 and it is 128KB.If I try to open outlook it tells me that my mailbox folders are in use and I need to stop any processes that are accessing them before I can open outlook.As I mentioned before rebooting the machine does fix the problem for a short period, but this is a 24X7 production system so periodic reboots are not an exceptable solution.ThanksDon Tipton |
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2002-02-06 : 11:57:29
|
| Is your mail server an Exchange server or a POP3 server?-Chad |
 |
|
|
dontipton
Starting Member
8 Posts |
Posted - 2002-02-06 : 14:38:30
|
| Exchange |
|
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2002-02-06 : 18:04:07
|
| If SQL Mail hangs periodically, the most likely cause is the loss of aconnection to the mail server. Experience has shown that a SQL Mail hang is more likely to happen when using an Internet mail (POP3/SMTP) server, but it could also happen if a connection to an Exchange server fails.What happens is that the mail client attempts to connect to the mail server. If the connection fails, a popup message from the mail client appears requesting user action as to whether to continue or cancel. This popup message does not appear on the server box because SQL Mail is run from the SQL Server service. Because a popup message does not appear, no user action can be taken and SQL Mail will indefinitely wait. Even if the network connection is re-established, SQL Mail will not automatically reset and retry. You will need to stop and restart the SQL Server service before you can begin sending messages again.Because SQL Mail is run through the SQL Server service, any popup messages that could cause SQL Mail to hang do not appear on your desktop. To see if SQL Mail is raising any popup messages, you will need to run SQL Server as a console application, not as a service. Follow the steps below:a. Login to the Windows server with the same account used to start the SQL Server service.b. Open a command prompt window. If you are using SQL Server 2000, you will need to navigate to the directory where the executable files for your SQL Server instance are installed.c. Start SQL Server as an application by executing this command:sqlservr -cNOTE: For SQL Server 2000, if you are using a named instance, you need to add -s with the instance name.d. Connect to SQL Server with Query Analyzer and run xp_sendmail to test sending a mail message. e. If a popup window appears, you will need to correct the problem before you can use SQL Mail.What I suspect is happening is that you lose connectivity between your SQL and exchange servers from time to time, and a popup message appears (Thus hanging SQLMail).HTH-Chad |
|
|
|
|
|
|
|
|
SQL Mail hanging