Post reply

Email server down = SQL Server Locked

  • September 29, 2005 at 11:13 am

    #89178

    I have noticed that whenever our Email Server is rebooted, SQL Server locks up. Users cannot connect to SQL and they get timeout errors.

    Yesterday, we had to reboot the Email server. Just before the reboot I ran xp_stopmail to see if SQL still locks up. It did. I was able to run a trace to capture all events.

    What do I need to search for in the trace log to see why SQL locks up ?

    Thanks in advance.

  • September 30, 2005 at 12:33 am

    #594253

    Is the email server a DC (Domain Controller)?  If so, is it the only one or one of many?  Is the SQL Server a DC?

    If the email server was the only domain controller, and SQL is trying to authenticate users, that may cause a lockup?   

    Also, try checking the NT event log.

  • September 30, 2005 at 3:26 am

    #594279

    This is a problem that has been around for ages in SQL Server.

    It drove me nuts, I had to restart the SQL services if the email servers were bounced or "dropped off" the network for any reason.

    The bug was introduced in SQL 2000 SP2, and was fixed in a post SP3a hotfix 922 and is included in SP4.

    See http://support.microsoft.com/kb/833045/

    This is not exactly the symptom, but it is the problem, it just manifests different ways

    For example, SQL Agent also stopped sending emails

    Also, batch jobs using osql just hung etc

    If you're on SP4 alread, I refer you to teh previous post 🙂

  • September 30, 2005 at 8:09 am

    #594341

    Neither SQL Server nor the Email Server is a DC. Also nothing in the NT Event log.

    I will apply SP4 on a development box and test it first.

    Thanks to both of you.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply