And here is part of the installation log...

I get to the point of starting the services and receive the following message after about 4 minutes of trying to start. I tried in Mixed Mode and Windows Authentication Mode. Message:

TITLE: Microsoft SQL Server 2005 Setup
------------------------------

The SQL Server service failed to start. For more information, see the SQL Server Books Online topics, "How to: View SQL Server 2005 Setup Log Files" and "Starting SQL Server Manually."

For help, click: http://go.microsoft.com/fwlink LinkID=20476&ProdName=Microsoft+SQL+Server&ProdVer=9.00.2047.00&EvtSrc=setup.rll&EvtID=29503&EvtType=sqlsetuplib%5cservice.cpp%40Do_sqlScript%40sqls%3a%3aService%3a%3aWaitForServiceState%40x41d

------------------------------
BUTTONS:

&Retry
Cancel
------------------------------



Answer this question

And here is part of the installation log...

  • AndrewLittlejohn

    Thanks.....

    Property(S): DatabaseReplRes.D9BC9C10_2DCD_44D3_AACC_9C58CAF76128 = C:\Program Files\Common Files\Microsoft Shared\Database Replication\Resources\
    Property(S): DatabaseReplRes1033.D9BC9C10_2DCD_44D3_AACC_9C58CAF76128 = C:\Program Files\Common Files\Microsoft Shared\Database Replication\Resources\1033\
    Property(S): SqlVerComBin.8B75390F_DF2F_4C2C_92F5_9B83F3B36340 = C:\Program Files\Microsoft SQL Server\90\COM\
    Property(S): Ver.8B75390F_DF2F_4C2C_92F5_9B83F3B36340 = C:\Program Files\Microsoft SQL Server\90\
    Property(S): SqlVerComBin.889BED4C_E3F4_4943_956C_6FFD882F721F = C:\Program Files\Microsoft SQL Server\90\COM\
    Property(S): Ver.889BED4C_E3F4_4943_956C_6FFD882F721F = C:\Program Files\Microsoft SQL Server\90\
    Property(S): SqlVerComBin.CC4DBEA7_CD8B_4AAE_A10F_657CBA390BD6 = C:\Program Files\Microsoft SQL Server\90\COM\
    Property(S): Ver.CC4DBEA7_CD8B_4AAE_A10F_657CBA390BD6 = C:\Program Files\Microsoft SQL Server\90\
    Property(S): SqlVerComBinRes.CC4DBEA7_CD8B_4AAE_A10F_657CBA390BD6 = C:\Program Files\Microsoft SQL Server\90\COM\Resources\
    Property(S): SqlVerComBinRes1033.CC4DBEA7_CD8B_4AAE_A10F_657CBA390BD6 = C:\Program Files\Microsoft SQL Server\90\COM\Resources\1033\
    Property(S): CostingComplete = 1
    Property(S): OutOfDiskSpace = 0
    Property(S): OutOfNoRbDiskSpace = 0
    Property(S): PrimaryVolumeSpaceAvailable = 0
    Property(S): PrimaryVolumeSpaceRequired = 0
    Property(S): PrimaryVolumeSpaceRemaining = 0
    Property(S): RSVirtualDirectoryServer = ReportServer$SQLEXPRESS
    Property(S): SqlActionManaged = 3
    Property(S): SqlNamedInstance = 1
    Property(S): SqlStateManaged = 2
    Property(S): RSVirtualDirectoryManager = Reports$SQLEXPRESS
    Property(S): SOURCEDIR = d:\69a81902561ca8c7a8df\Setup\
    Property(S): SourcedirProduct = {2AFFFDD7-ED85-4A90-8C52-5DA9EBDC9B8F}
    Property(S): InstallNgenTicks = 110000
    Property(S): SQLBROWSERSCMACCOUNT = NT AUTHORITY\NetworkService
    Property(S): SQLSCMACCOUNT = NT AUTHORITY\NetworkService
    Property(S): DebugClsid.CC1A8C58_27D1_4D38_BF1B_C0A5CBB90616 = {84AFA01D-0112-4F29-990C-7A3EECC00498}
    Property(S): ProductToBeRegistered = 1
    MSI (s) (EC:1C) [08:37:27:207]: Note: 1: 1708
    MSI (s) (EC:1C) [08:37:27:207]: Product: Microsoft SQL Server 2005 Express Edition -- Installation failed.

    MSI (s) (EC:1C) [08:37:27:227]: Cleaning up uninstalled install packages, if any exist
    MSI (s) (EC:1C) [08:37:27:227]: MainEngineThread is returning 1603
    MSI (s) (EC:5C) [08:37:27:337]: Destroying RemoteAPI object.
    MSI (s) (EC:D8) [08:37:27:337]: Custom Action Manager thread ending.
    === Logging stopped: 5/28/2006 8:37:27 ===
    MSI (c) (78:AC) [08:37:27:377]: Decrementing counter to disable shutdown. If counter >= 0, shutdown will be denied. Counter after decrement: -1
    MSI (c) (78:AC) [08:37:27:377]: MainEngineThread is returning 1603
    === Verbose logging stopped: 5/28/2006 8:37:27 ===


  • RKumarB

    I can find nothing useful in the Windows event log and I guess I do not understand where the sql server log files are.
  • ICantThinkOfAGoodOne

    YOu need do have a look in the WIndows event log or in the log files of SQL Server mentioned. There is a problem starting the service, the message that you provided is just a generic one which doesn’t tell the specific error.



    HTH, Jens Suessmeyer.

    ---
    http://www.sqlserver2005.de
    ---

  • panaconsultas

    here is the log contents of the last attempted installation and of course it timed out while trying to start the service:

    2006-05-28 07:37:06.92 Server Microsoft SQL Server 2005 - 9.00.2047.00 (Intel X86)

    Apr 14 2006 01:12:25

    Copyright (c) 1988-2005 Microsoft Corporation

    Express Edition with Advanced Services on Windows NT 5.1 (Build 2600: Service Pack 2)

    2006-05-28 07:37:06.92 Server (c) 2005 Microsoft Corporation.

    2006-05-28 07:37:06.92 Server All rights reserved.

    2006-05-28 07:37:06.92 Server Server process ID is 4776.

    2006-05-28 07:37:06.92 Server Logging SQL Server messages in file 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG'.

    2006-05-28 07:37:06.94 Server Registry startup parameters:

    2006-05-28 07:37:06.94 Server -d C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\master.mdf

    2006-05-28 07:37:06.94 Server -e C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG

    2006-05-28 07:37:06.94 Server -l C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\mastlog.ldf

    2006-05-28 07:37:06.94 Server Command Line Startup Parameters:

    2006-05-28 07:37:06.95 Server -m SqlSetup

    2006-05-28 07:37:06.95 Server SqlSetup

    2006-05-28 07:37:06.95 Server -Q

    2006-05-28 07:37:06.95 Server -q SQL_Latin1_General_CP1_CI_AS

    2006-05-28 07:37:06.95 Server -T 4022

    2006-05-28 07:37:06.95 Server -T 3659

    2006-05-28 07:37:06.95 Server -T 3610

    2006-05-28 07:37:06.95 Server -T 4010

    2006-05-28 07:37:06.98 Server SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.

    2006-05-28 07:37:06.98 Server Detected 1 CPUs. This is an informational message; no user action is required.

    2006-05-28 07:40:49.72 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.

    2006-05-28 07:40:50.88 Server Database Mirroring Transport is disabled in the endpoint configuration.

    2006-05-28 07:59:24.50 Server Service control: stop before startup


  • Peter Gadsby

    For me its located in here:

    C:\Program Files\Microsoft SQL Server\MSSQL.4\MSSQL\LOG

    Could be something different for you depending on your installation.

    HTH, Jens Suessmeyer.

    ---
    http://www.sqlserver2005.de
    ---

  • latesh

    What service account are you using for the service. It could be that the service account used doesn’t have the appropiate permissions to start up SQL Server. Change that (e.g. to Local System) and see if a manual startup comes up successfull.

    HTH, Jens Suessmeyer.

    ---
    http://www.sqlserver2005.de
    ---

  • And here is part of the installation log...