Skip to Content
author's profile photo Former Member
Former Member

Disp+work.exe is stopped, Database is Down

Dear All,

Our Production Server is in the cluster mode.

Disp+work.exe is stopped

Database is down

Database : MS SQL 2005 Server

OS: Windows 2003 32 bit

Kindly help us to start the database.

In the Services we have 5 SQL Server Services:

1. SQL Server (MSSQLSERVER)-- not started --manual (logon as Server\clustadmin)

2. SQL Server Active Directory Helper --- hot started u2013manual (logon as Server\clustadmin)

3. SQL Server Agent (MSSQLSERVER) -not started u2013 manual -(logon as Server\clustadmin)

4. SQLSERVER Browser ---Started ---Automaticu2014(Logon as\clustadmin)

5. SQL Server writer u2013Started ---Automaticu2014(logon as Local System)

Syslog: Database: Database error -1 at CON

SQLERRORLOG.1

2010-07-05 10:26:02.67 Server Microsoft SQL Server 2005 - 9.00.3042.00 (Intel X86)

Feb 9 2007 22:47:07

Copyright (c) 1988-2005 Microsoft Corporation

Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 2)

2010-07-05 10:26:02.67 Server (c) 2005 Microsoft Corporation.

2010-07-05 10:26:02.67 Server All rights reserved.

2010-07-05 10:26:02.67 Server Server process ID is 7344.

2010-07-05 10:26:02.67 Server Authentication mode is MIXED.

2010-07-05 10:26:02.67 Server Logging SQL Server messages in file 'F:\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG'.

2010-07-05 10:26:02.67 Server This instance of SQL Server last reported using a process ID of 6800 at 7/5/2010 10:25:07 AM (local) 7/5/2010 4:55:07 AM (UTC). This is an informational message only; no user action is required.

2010-07-05 10:26:02.67 Server Registry startup parameters:

2010-07-05 10:26:02.67 Server -d F:\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\master.mdf

2010-07-05 10:26:02.67 Server -e F:\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG

2010-07-05 10:26:02.67 Server -l F:\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\mastlog.ldf

2010-07-05 10:26:02.67 Server SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.

2010-07-05 10:26:02.67 Server Detected 16 CPUs. This is an informational message; no user action is required.

2010-07-05 10:26:02.98 Server Set AWE Enabled to 1 in the configuration parameters to allow use of more memory.

2010-07-05 10:26:03.32 Server Using dynamic lock allocation. Initial allocation of 2500 Lock blocks and 5000 Lock Owner blocks per node. This is an informational message only. No user action is required.

2010-07-05 10:26:03.32 Server Lock partitioning is enabled. This is an informational message only. No user action is required.

2010-07-05 10:26:03.39 Server Attempting to initialize Microsoft Distributed Transaction Coordinator (MS DTC). This is an informational message only. No user action is required.

2010-07-05 10:26:06.28 Server The Microsoft Distributed Transaction Coordinator (MS DTC) service could not be contacted. If you would like distributed transaction functionality, please start this service.

2010-07-05 10:26:06.28 Server Database mirroring has been enabled on this instance of SQL Server.

2010-07-05 10:26:06.29 spid5s Starting up database 'master'.

2010-07-05 10:26:06.33 spid5s 1 transactions rolled forward in database 'master' (1). This is an informational message only. No user action is required.

2010-07-05 10:26:06.33 spid5s 0 transactions rolled back in database 'master' (1). This is an informational message only. No user action is required.

2010-07-05 10:26:06.33 spid5s Recovery is writing a checkpoint in database 'master' (1). This is an informational message only. No user action is required.

2010-07-05 10:26:06.34 spid5s SQL Trace ID 1 was started by login "sa".

2010-07-05 10:26:06.36 spid5s Starting up database 'mssqlsystemresource'.

2010-07-05 10:26:06.36 spid5s The resource database build version is 9.00.3042. This is an informational message only. No user action is required.

2010-07-05 10:26:06.58 spid5s Server name is 'DBGRP'. This is an informational message only. No user action is required.

2010-07-05 10:26:06.58 spid9s Starting up database 'model'.

2010-07-05 10:26:06.58 spid5s The NETBIOS name of the local node that is running the server is 'DHBPRD2'. This is an informational message only. No user action is required.

2010-07-05 10:26:06.70 spid9s Clearing tempdb database.

2010-07-05 10:26:06.90 spid9s Starting up database 'tempdb'.

2010-07-05 10:26:06.97 spid9s Analysis of database 'tempdb' (2) is 100% complete (approximately 0 seconds remain). This is an informational message only. No user action is required.

2010-07-05 10:26:07.04 spid12s The Service Broker protocol transport is disabled or not configured.

2010-07-05 10:26:07.04 spid12s The Database Mirroring protocol transport is disabled or not configured.

2010-07-05 10:26:07.11 spid12s Service Broker manager has started.

2010-07-05 10:26:07.42 Server A self-generated certificate was successfully loaded for encryption.

2010-07-05 10:26:07.43 Server Error: 26054, Severity: 16, State: 1.

2010-07-05 10:26:07.43 Server Could not find any IP address that this SQL Server instance depends upon. Make sure that the cluster service is running, that the dependency relationship between SQL Server and Network Name resources is correct, and that the IP addresses on which this SQL Server instance depends are available. Error code: 0x103.

2010-07-05 10:26:07.45 Server Error: 17182, Severity: 16, State: 1.

2010-07-05 10:26:07.45 Server TDSSNIClient initialization failed with error 0x103, status code 0xa.

2010-07-05 10:26:07.45 Server Error: 17182, Severity: 16, State: 1.

2010-07-05 10:26:07.45 Server TDSSNIClient initialization failed with error 0x103, status code 0x1.

2010-07-05 10:26:07.45 Server Error: 17826, Severity: 18, State: 3.

2010-07-05 10:26:07.45 Server Could not start the network library because of an internal error in the network library. To determine the cause, review the errors immediately preceding this one in the error log.

2010-07-05 10:26:07.45 Server Error: 17120, Severity: 16, State: 1.

2010-07-05 10:26:07.45 Server SQL Server could not spawn FRunCM thread. Check the SQL Server error log and the Windows event logs for information about possible related problems.

Best Regards,

Sunil

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Best Answer
    Posted on Jul 05, 2010 at 08:33 AM

    Hi Sunil,

    this is the problem:

    2010-07-05 10:26:07.43 Server Error: 26054, Severity: 16, State: 1.

    2010-07-05 10:26:07.43 Server Could not find any IP address that this SQL Server instance depends upon. Make sure that the cluster service is running, that the dependency relationship between SQL Server and Network Name resources is correct, and that the IP addresses on which this SQL Server instance depends are available. Error code: 0x103.

    In the cluster admin please check if the IPadress and the network name for the SQL Server is online, before you start the SQL Server.

    Regards

    Clas

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jul 06, 2010 at 11:32 AM

    Hello,

    Please check SQL server Service and the SQL Agent Service

    are starting correctly.

    Are there any errors in event viewer refering to these services?

    regards,

    John Feely

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.