Hi,

I downloaded SQL Server 2008 Developer edition from microsoft Dreamspark
website and installed it and it was working fine, till some microsoft update
which happened last week i guess!

Now i am unable to connect to the Database engine and it gives me errors
like Piped Names error 40, error 2 etc...I have since then installed /
uninstalled SQL server a couple of times and each time either during install
or uninstall, it gives errors....

I have the detailed error report but here there does not seem to be an
option to upload the error text file.

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: 2010-05-21 01:29:16
End time: 2010-05-21 01:50:37
Requested action: Repair
Log with failure: C:\Program Files\Microsoft SQL
Server\100\Setup Bootstrap\Log\20100521_012757\Detail.txt
Exception help link:
http%3a%2f%2fgo.microsoft.com%2ffwlink%3fLinkId%3d 20476%26ProdName%3dMicrosoft%2bSQL%2bServer%26EvtS rc%3dsetup.rll%26EvtID%3d50000%26ProdVer%3d10.0.25 31.0%26EvtType%3d0x13DA3258%400xF15156D0

Machine Properties:
Machine name: ZAKCAPRIUS
Machine processor count: 2
OS version: Windows Vista
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 MSSQLSERVER MSSQL10.MSSQLSERVER
Database Engine Services 1033 Developer
Edition 10.1.2531.0 No
Sql Server 2008 MSSQLSERVER MSSQL10.MSSQLSERVER
SQL Server Replication 1033 Developer
Edition 10.1.2531.0 No
Sql Server 2008 MSSQLSERVER MSSQL10.MSSQLSERVER
Full-Text Search 1033 Developer
Edition 10.0.1600.22 No
Sql Server 2008 MSSQLSERVER MSAS10.MSSQLSERVER
Analysis Services 1033 Developer
Edition 10.1.2531.0 No
Sql Server 2008 MSSQLSERVER MSRS10.MSSQLSERVER
Reporting Services 1033
10.1.2531.0 No
Sql Server 2008 SQLEXPRESS MSSQL10.SQLEXPRESS
Database Engine Services 1033 Express Edition
10.1.2531.0 No
Sql Server 2008 SQLEXPRESS MSSQL10.SQLEXPRESS
SQL Server Replication 1033 Express Edition
10.1.2531.0 No
Sql Server 2008
Management Tools - Basic 1033 Developer
Edition 10.1.2531.0 No
Sql Server 2008
Management Tools - Complete 1033 Developer
Edition 10.1.2531.0 No
Sql Server 2008
Client Tools Connectivity 1033 Developer
Edition 10.1.2531.0 No
Sql Server 2008
Client Tools Backwards Compatibility 1033 Developer
Edition 10.1.2531.0 No
Sql Server 2008
Client Tools SDK 1033 Developer
Edition 10.1.2531.0 No
Sql Server 2008
Integration Services 1033 Developer
Edition 10.1.2531.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: G:\SQL Server\x86\setup\
Installation edition: DEVELOPER

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\20100521_012757\ConfigurationFile.in i
FAILOVERCLUSTERGROUP: <empty>
FAILOVERCLUSTERNETWORKNAME: <empty>
FTSVCACCOUNT: NT AUTHORITY\LOCAL SERVICE
FTSVCPASSWORD: *****
HELP: False
INDICATEPROGRESS: False
INSTANCENAME: MSSQLSERVER
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\20100521_012757\ConfigurationFile.in i

Detailed results:
Feature: Database Engine Services
Status: Failed: see logs for details
MSI status: Passed
Configuration status: Failed: see details below
Configuration error code: 0x254B099F@1306@57
Configuration error description: The master database location is missing
from the Parameters registry key. The master log location is missing from
the Parameters registry key. The Database Engine error log location is
missing from the Parameters key.
Configuration log: C:\Program Files\Microsoft SQL
Server\100\Setup Bootstrap\Log\20100521_012757\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: Passed
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: 0x254B099F@1306@57
Configuration error description: The master database location is missing
from the Parameters registry key. The master log location is missing from
the Parameters registry key. The Database Engine error log location is
missing from the Parameters key.
Configuration log: C:\Program Files\Microsoft SQL
Server\100\Setup Bootstrap\Log\20100521_012757\Detail.txt

Feature: Full-Text Search
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_FullText_Adv'
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\20100521_012757\Detail.txt
Configuration status: Failed: see details below
Configuration error code: 0x4971D227@1204@2
Configuration error description: The SQL Server feature 'SQL_FullText_Adv'
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\20100521_012757\Detail.txt
Configuration status: Failed: see details below
Configuration error code: 0x4971D227@1204@2
Configuration error description: The SQL Server feature 'SQL_FullText_Adv'
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\20100521_012757\Detail.txt
Configuration status: Failed: see details below
Configuration error code: 0x254B099F@1306@57
Configuration error description: The master database location is missing
from the Parameters registry key. The master log location is missing from
the Parameters registry key. The Database Engine error log location is
missing from the Parameters key.
Configuration log: C:\Program Files\Microsoft SQL
Server\100\Setup Bootstrap\Log\20100521_012757\Detail.txt

Feature: Analysis Services
Status: Passed
MSI status: Passed
Configuration status: Passed

Feature: Reporting Services
Status: Failed: see logs for details
MSI status: Passed
Configuration status: Passed

Feature: Integration Services
Status: Passed
MSI status: Passed
Configuration status: Passed

Feature: SQL Compact Edition Tools
Status: Passed
MSI status: Passed
Configuration status: Passed

Feature: SQL Compact Edition Runtime
Status: Passed
MSI status: Passed
Configuration status: Passed

Feature: Client Tools Connectivity
Status: Passed
MSI status: Passed
Configuration status: Passed

Feature: Management Tools - Complete
Status: Passed
MSI status: Passed
Configuration status: Passed

Feature: Management Tools - Basic
Status: Passed
MSI status: Passed
Configuration status: Passed

Feature: Client Tools SDK
Status: Passed
MSI status: Passed
Configuration status: Passed

Feature: Client Tools Backwards Compatibility
Status: Passed
MSI status: Passed
Configuration status: Passed

Feature: Business Intelligence Development Studio
Status: Passed
MSI status: Passed
Configuration status: Passed

Feature: SQL Server Books Online
Status: Passed
MSI status: Passed
Configuration status: Passed

Feature: Microsoft Sync Framework
Status: Passed
MSI status: Passed
Configuration status: Passed

Rules with failures:

Global rules:

There are no scenario-specific rules.

Rules report file: C:\Program Files\Microsoft SQL
Server\100\Setup
Bootstrap\Log\20100521_012757\SystemConfigurationC heck_Report.htm


Please help!

sifar786 (sifar786 (AT) discussions (DOT) microsoft.com) writes:
It is not entirely trivial to diagnose this, as you seem to have done
all sorts of things. The log you post is from an attempt to repair the
installation. It seems that some of the registry keys are damaged.

I think your best option is to install a second instance, and leave the
default instance in the damaged state. It is possible it can be fixed
with some registry editing, but it can be time-consuming without leading
anywhere. If you have any databases you want to keep, you can attach this
to the new instance you install.
--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx