Hi,
Please see the logs below for the error I incountered during my installation.
InstallDB (local)\SOPHOS CBISERVER2 SOPHOS51 "C:\Documents and Settings\All Users\Application Data\Sophos\Management Installer\Sophos_InstallCoreDB.log"
Started
03/25/2013
02:24 PM
==========
HResult 0xFFFFFFFF, Level 16, State 1
SQL Server Network Interfaces: Error Locating Server/Instance Specified [xFFFFFFFF].
Thanks in advance.
tedz
Hi,
If you open a command prompt and run:
sqlcmd -E -S (local)\SOPHOS
Does it connect or error?
Is the SQL Server service for the Sophos instance started? Typically it's called: MSSQL$SOPHOS or long name: "SQL Server (SOPHOS)".
If it is, can you connect with either:
sqlcmd -E -S .\SOPHOS
or
sqlcmd -E -S [computerName]\SOPHOS
or
sqlcmd -E -S [IP]\SOPHOS
Regards,
Jak
Hi,
I ccannot start the service of "SQL Server (SOPHOS)" Could not start SQL Server (Sophos) Service in local computer. error:3 The system cannot find the path specified.
Microsoft Windows [Version 5.2.3790]
(C) Copyright 1985-2003 Microsoft Corp.
C:\Documents and Settings\Administrator.BELMONT>sqlcmd -E -S (local)\SOPHOS
HResult 0xFFFFFFFF, Level 16, State 1
SQL Server Network Interfaces: Error Locating Server/Instance Specified [xFFFFFF
FF].
Sqlcmd: Error: Microsoft SQL Server Native Client 10.0 : A network-related or in
stance-specific error has occurred while establishing a connection to SQL Server
. Server is not found or not accessible. Check if instance name is correct and i
f SQL Server is configured to allow remote connections. For more information see
SQL Server Books Online..
Sqlcmd: Error: Microsoft SQL Server Native Client 10.0 : Login timeout expired.
C:\Documents and Settings\Administrator.BELMONT>sqlcmd -E -S .\SOPHOS
HResult 0xFFFFFFFF, Level 16, State 1
SQL Server Network Interfaces: Error Locating Server/Instance Specified [xFFFFFF
FF].
Sqlcmd: Error: Microsoft SQL Server Native Client 10.0 : A network-related or in
stance-specific error has occurred while establishing a connection to SQL Server
. Server is not found or not accessible. Check if instance name is correct and i
f SQL Server is configured to allow remote connections. For more information see
SQL Server Books Online..
Sqlcmd: Error: Microsoft SQL Server Native Client 10.0 : Login timeout expired.
C:\Documents and Settings\Administrator.BELMONT>sqlcmd -E -S cbiserver2\SOPHOS
HResult 0xFFFFFFFF, Level 16, State 1
SQL Server Network Interfaces: Error Locating Server/Instance Specified [xFFFFFF
FF].
Sqlcmd: Error: Microsoft SQL Server Native Client 10.0 : A network-related or in
stance-specific error has occurred while establishing a connection to SQL Server
. Server is not found or not accessible. Check if instance name is correct and i
f SQL Server is configured to allow remote connections. For more information see
SQL Server Books Online..
Sqlcmd: Error: Microsoft SQL Server Native Client 10.0 : Login timeout expired.
C:\Documents and Settings\Administrator.BELMONT>sqlcmd -E -S 205.158.231.232\SOP
HOS
HResult 0xFFFFFFFF, Level 16, State 1
SQL Server Network Interfaces: Error Locating Server/Instance Specified [xFFFFFF
FF].
Sqlcmd: Error: Microsoft SQL Server Native Client 10.0 : A network-related or in
stance-specific error has occurred while establishing a connection to SQL Server
. Server is not found or not accessible. Check if instance name is correct and i
f SQL Server is configured to allow remote connections. For more information see
SQL Server Books Online..
Sqlcmd: Error: Microsoft SQL Server Native Client 10.0 : Login timeout expired.
C:\Documents and Settings\Administrator.BELMONT>
Thanks,
tedz
Hi,
If the service cannot start, then not much is going to connect. :)
I assume the error: "The system cannot find the path specified." is thrown from the service control manager when it attempts to start the service.
If you look at the properties of the "SQL Server (SOPHOS)" service, specifially the "Path to executable" on the general tab, does the file sqlservr.exe exist in the location referenced?
If not, I would suggest that the Sophos SQL instance is in a half installed state and needs a repair. I would suggest, if given the version of SQL Server you search on Google for "repair sql instance 2008" or 2005, etc.. there will be some steps.
Regards,
Jak
Hi Jak,
Cannot start sql browser error logs below.
Overall summary:
Final result: Failed: see details below
Exit code (Decimal): -2068643839
Exit facility code: 1203
Exit error code: 1
Exit message: Failed: see details below
Start time: 2013-03-26 11:11:16
End time: 2013-03-26 11:20:59
Requested action: Repair
Log with failure: C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20130326_111023\Detail.txt
Exception help link: http%3a%2f%2fgo.microsoft.com%2ffwlink%3fLinkId%3d20476%26ProdName%3dMicrosoft%2bSQL%2bServer%26EvtSrc%3dsetup.rll%26EvtID%3d50000%26ProdVer%3d10.0.4000.0%26EvtType%3d0xB4A84AA1%400xC24842DB
Machine Properties:
Machine name: CBISERVER2
Machine processor count: 2
OS version: Windows Server 2003
OS service pack: Service Pack 2
OS region: United States
OS language: English (United States)
OS architecture: x86
Process architecture: 32 Bit
OS clustered: No
Product features discovered:
Product Instance Instance ID Feature Language Edition Version Clustered
Sql Server 2008 SOPHOS MSSQL10.SOPHOS Database Engine Services 1033 Express Edition 10.2.4000.0 No
Sql Server 2008 SOPHOS MSSQL10.SOPHOS SQL Server Replication 1033 Express Edition 10.2.4000.0 No
Package properties:
Description: SQL Server Database Services 2008
SQLProductFamilyCode: {628F8F38-600E-493D-9946-F4178F20A8A9}
ProductName: SQL2008
Type: RTM
Version: 10
SPLevel: 0
Installation location: c:\6caca558ef5a58966d58c0f1d0\x86\setup\
Installation edition: EXPRESS
User Input Settings:
ACTION: Repair
AGTDOMAINGROUP: <empty>
AGTSVCACCOUNT: <empty>
AGTSVCPASSWORD: *****
AGTSVCSTARTUPTYPE: Manual
ASCONFIGDIR: Config
ASDOMAINGROUP: <empty>
ASSVCACCOUNT: <empty>
ASSVCPASSWORD: *****
CONFIGURATIONFILE: C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20130326_111023\ConfigurationFile.ini
FAILOVERCLUSTERGROUP: <empty>
FAILOVERCLUSTERNETWORKNAME: <empty>
FTSVCACCOUNT: <empty>
FTSVCPASSWORD: *****
HELP: False
INDICATEPROGRESS: False
INSTANCENAME: SOPHOS
ISSVCACCOUNT: NT AUTHORITY\NetworkService
ISSVCPASSWORD: *****
ISSVCSTARTUPTYPE: Automatic
QUIET: False
QUIETSIMPLE: False
SQLDOMAINGROUP: <empty>
SQLSVCACCOUNT: <empty>
SQLSVCPASSWORD: *****
X86: False
Configuration file: C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20130326_111023\ConfigurationFile.ini
Detailed results:
Feature: Database Engine Services
Status: Failed: see logs for details
MSI status: Passed
Configuration status: Failed: see details below
Configuration error code: 0x4971D227@1204@2
Configuration error description: The SQL Server feature 'SQL_Engine_Core_Inst' is not in a supported state for repair, as it was never successfully configured. Only features from successful installations can be repaired. To continue, remove the specified SQL Server feature.
Configuration log: C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20130326_111023\Detail.txt
Configuration status: Failed: see details below
Configuration error code: 0x4971D227@1204@2
Configuration error description: The SQL Server feature 'SQL_Engine_Core_Inst' is not in a supported state for repair, as it was never successfully configured. Only features from successful installations can be repaired. To continue, remove the specified SQL Server feature.
Configuration log: C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20130326_111023\Detail.txt
Configuration status: Failed: see details below
Configuration error code: 0x4971D227@1204@2
Configuration error description: The SQL Server feature 'SQL_Replication_Core_Inst' is not in a supported state for repair, as it was never successfully configured. Only features from successful installations can be repaired. To continue, remove the specified SQL Server feature.
Configuration log: C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20130326_111023\Detail.txt
Configuration status: Failed: see details below
Configuration error code: 0x4971D227@1204@2
Configuration error description: The SQL Server feature 'SQL_Replication_Core_Inst' is not in a supported state for repair, as it was never successfully configured. Only features from successful installations can be repaired. To continue, remove the specified SQL Server feature.
Configuration log: C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20130326_111023\Detail.txt
Feature: SQL Client Connectivity
Status: Passed
MSI status: Passed
Configuration status: Passed
Feature: SQL Client Connectivity SDK
Status: Passed
MSI status: Passed
Configuration status: Passed
Feature: SQL Writer
Status: Passed
MSI status: Passed
Configuration status: Passed
Feature: SQL Browser
Status: Failed: see logs for details
MSI status: Passed
Configuration status: Passed
Feature: SQL Server Replication
Status: Failed: see logs for details
MSI status: Passed
Configuration status: Failed: see details below
Configuration error code: 0x4971D227@1204@2
Configuration error description: The SQL Server feature 'SQL_Replication_Core_Inst' is not in a supported state for repair, as it was never successfully configured. Only features from successful installations can be repaired. To continue, remove the specified SQL Server feature.
Configuration log: C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20130326_111023\Detail.txt
Configuration status: Failed: see details below
Configuration error code: 0x4971D227@1204@2
Configuration error description: The SQL Server feature 'SQL_Replication_Core_Inst' is not in a supported state for repair, as it was never successfully configured. Only features from successful installations can be repaired. To continue, remove the specified SQL Server feature.
Configuration log: C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20130326_111023\Detail.txt
Configuration status: Failed: see details below
Configuration error code: 0x4971D227@1204@2
Configuration error description: The SQL Server feature 'SQL_Engine_Core_Inst' is not in a supported state for repair, as it was never successfully configured. Only features from successful installations can be repaired. To continue, remove the specified SQL Server feature.
Configuration log: C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20130326_111023\Detail.txt
Configuration status: Failed: see details below
Configuration error code: 0x4971D227@1204@2
Configuration error description: The SQL Server feature 'SQL_Engine_Core_Inst' is not in a supported state for repair, as it was never successfully configured. Only features from successful installations can be repaired. To continue, remove the specified SQL Server feature.
Configuration log: C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20130326_111023\Detail.txt
Rules with failures:
Global rules:
There are no scenario-specific rules.
Rules report file: C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20130326_111023\SystemConfigurationCheck_Report.htm
Thanks in advance.
tedz
