Re: SQL Clustered Node restarting unexpectedly

From: Mike Epprecht \(SQL MVP\) (mike_at_epprecht.net)
Date: 11/09/04

  • Next message: RIBR: "Re: How to move system databases to new SAN drive in cluster serve" 
    Date: Tue, 9 Nov 2004 08:08:39 +0100

    Hi

    Your biggest clue:
    Message:- The previous system Shut Down was unexpected.

    The machine rebooted without being nicely shut down = crashed.

    I had a similar scenario about 8 weeks ago, both nodes were crashing on some
    decent HP hardware. Found it to be a NMI that was caught by the system BIOS
    because a driver was issuing a bad command to the Fiber Channel card and
    then the BIOS rebooted the box. Fixed it by upgrading the BIOS and all the
    latest drivers.

    Regards
    --------------------------------
    Mike Epprecht, Microsoft SQL Server MVP
    Zurich, Switzerland

    IM: mike@epprecht.net

    MVP Program: http://www.microsoft.com/mvp

    Blog: http://www.msmvps.com/epprecht/

    "Haroon Malik" <anonymous@discussions.microsoft.com> wrote in message
    news:490e01c4c629$f285f2c0$a601280a@phx.gbl...
    > Dear All,
    >
    > I have an SQL CLuster Setup on Windows 2000 Advanced
    > Servers on 2 nodes connected to SAN Storage using Fibre
    > Channel adapters. Every week i have an unexpected restart
    > on either of the servers.
    >
    > I am enclosing few of the erros generated in system log
    > of the event viewer on the Clustered SQL Servers.
    >
    > Source :- EventLog
    > Event ID:- 6008
    > Message:- The previous system Shut Down was unexpected.
    >
    > Source:- Server
    > Event ID:- 2506
    > Message:- The value name NoRemapPipes in the server's
    > registry key LanManServer\Parameters was invalid. The
    > value was ignored and the processing continued.
    >
    > Source:- Application Pop up
    > Event Id:- 26
    > Message:- Application Popup Idle Time expired : Session
    > has been idle over its time limit.
    > Log off will start in 2 minutes
    > Press any key now to continue session.
    >
    > Source:- DnsApi
    > Event ID:- 11151
    > Message:- The system failed to register network adapter
    > with settings.
    >
    > Source:- ClusSvc
    > Event ID:- 1119
    > Message:- The registration of DNS name jazsqlar.jscsite
    > for network name resource SQL network name (JAZSQLAR)
    > failed for the following reason:
    >
    > DNS server failure
    >
    >

  • Next message: RIBR: "Re: How to move system databases to new SAN drive in cluster serve"

    Relevant Pages

    • Re: Remote disk space analysis
      ... Check the drive space on all of the servers listed in a text file and store the output like Server name, Drive Name, Disk Space and Free space information on a SQL Server table. ...
      (microsoft.public.scripting.vbscript)
    • Re: Hiding MS SQL databases in Enterprise Manager
      ... > When I create a database in the Microsoft SQL Server, ... > security issue, I would like to set it up so that users can only see ... > databases for which they've been assigned a role. ... your SQL servers, not at preventing a list of them. ...
      (Focus-Microsoft)
    • Re: using windows authentication...
      ... SQL Server DOES NOT TALK TO WEB ... Web clients request access and data from database servers, ... Server security. ...
      (microsoft.public.sqlserver.server)
    • Re: Not associated with a trusted SQL Server connection....
      ... I altered my publisher account to impersonate the SQLServer ... > Are both SQL Servers and SQL Server agent running under the same account? ...
      (microsoft.public.sqlserver.replication)
    • Re: [tip:x86/setup] x86, setup: "glove box" BIOS calls -- infrastructure
      ... secret bootstrap sequences and code compactness ... Code quality is dead last in the list. ... BIOS problems, but definitely not all of them. ... For servers, I guess Linux has enough of market share that we ...
      (Linux-Kernel)