funnycik
asked on
SQL Server 2008 Installation Problem
i tried to install sql server 2008 but i get an error every single install..
i tried over 15 times,different settings,but still get error..
OS - Windows XP SP 3
Hardware is enough for installation
i tried over 15 times,different settings,but still get error..
OS - Windows XP SP 3
Hardware is enough for installation
summary.txt
Overall summary:
Final result: SQL Server installation failed. To continue, investigate the reason for the failure, correct the problem, uninstall SQL Server, and then rerun SQL Server Setup.
Exit code (Decimal): -2068643839
Exit facility code: 1203
Exit error code: 1
Exit message: SQL Server installation failed. To continue, investigate the reason for the failure, correct the problem, uninstall SQL Server, and then rerun SQL Server Setup.
Start time: 2009-07-09 14:55:10
End time: 2009-07-09 15:05:55
Requested action: Install
Log with failure: C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20090709_145108\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.1600.22%26EvtType%3d0x5D9A8C61
Machine Properties:
Machine name: FUNNYCIK
Machine processor count: 2
OS version: Windows XP
OS service pack: Service Pack 3
OS region: Türkiye
OS language: Türkçe (Türkiye)
OS architecture: x86
Process architecture: 32 Bit
OS clustered: No
Product features discovered:
Product Instance Instance ID Feature Language Edition Version Clustered
Sql Server 2000 MSSQLSERVER SQL Server 1033 Personal Edition 8.4.2039 No
Sql Server 2000 MSSQLSERVER Replication Support 1033 Personal Edition 8.4.2039 No
Sql Server 2000 MSSQLSERVER Debug Symbols 1033 Personal Edition 8.4.2039 No
Sql Server 2000 MSSQLSERVER Performance Counters 1033 Personal Edition 8.4.2039 No
Sql Server 2000 MSSQLSERVER Analysis Services 8.00.194 No
Sql Server 2000 TEST SQL Server 1033 Personal Edition 8.4.2039 No
Sql Server 2000 TEST Replication Support 1033 Personal Edition 8.4.2039 No
Sql Server 2000 TEST Debug Symbols 1033 Personal Edition 8.4.2039 No
Sql Server 2000 TEST Performance Counters 1033 Personal Edition 8.4.2039 No
Sql Server 2000 Enterprise Manager Tools 8.00.194 No
Sql Server 2000 Profiler Tools 8.00.194 No
Sql Server 2000 Query Analyzer Tools 8.00.194 No
Sql Server 2000 DTC Client Support Tools 8.00.194 No
Sql Server 2000 Conflict Viewer Tools 8.00.194 No
Sql Server 2000 Client Connectivity Tools 8.00.194 No
Sql Server 2000 Books Online On Disk Tools 8.00.194 No
Sql Server 2000 Debugger Interface Tools 8.00.194 No
Sql Server 2000 AS_Tools Tools 8.00.194 No
Sql Server 2000 DTS Tools 8.00.194 No
Sql Server 2005 SQLEXPRESS MSSQL.1 Database Engine Services 1033 Express Edition 9.3.4035 No
Sql Server 2005 SQLEXPRESS MSSQL.1 SQL Server Replication 1033 Express Edition 9.3.4035 No
Sql Server 2005 SQLEXPRESS MSSQL.1 SharedTools 1033 Express Edition 9.3.4035 No
Sql Server 2005 Tools 1033 Express Edition 9.3.4035 No
Sql Server 2005 ToolsClient 1033 Express Edition 9.3.4035 No
Sql Server 2005 ToolsClient\Connectivity 1033 Express Edition 9.3.4035 No
Sql Server 2008 SQL2008 MSSQL10.SQL2008 Database Engine Services 1033 Enterprise Edition 10.0.1442.32 No
Sql Server 2008 SQL2008 MSSQL10.SQL2008 SQL Server Replication 1033 Enterprise Edition 10.0.1442.32 No
Sql Server 2008 SQL2008 MSSQL10.SQL2008 Full-Text Search 1033 Enterprise Edition 10.0.1442.32 No
Sql Server 2008 SQL2008 MSAS10.SQL2008 Analysis Services 1033 Enterprise Edition 10.0.1442.32 No
Sql Server 2008 SQL2008 MSRS10.SQL2008 Reporting Services 1033 Enterprise Edition 10.0.1442.32 No
Sql Server 2008 S2008 MSSQL10.S2008 Database Engine Services 1033 10.0.1600.22 No
Sql Server 2008 S2008 MSSQL10.S2008 SQL Server Replication 1033 10.0.1600.22 No
Sql Server 2008 S2008 MSSQL10.S2008 Full-Text Search 1033 10.0.1600.22 No
Sql Server 2008 SQ2008 MSSQL10.SQ2008 Database Engine Services 1033 10.0.1600.22 No
Sql Server 2008 SS2008 MSSQL10.SS2008 Database Engine Services 1033 10.0.1600.22 No
Sql Server 2008 SQL10 MSSQL10.SQL10 Database Engine Services 1033 10.0.1600.22 No
Sql Server 2008 S10 MSSQL10.S10 Database Engine Services 1033 10.0.1600.22 No
Sql Server 2008 SQ10 MSSQL10.SQ10 Database Engine Services 1033 10.0.1600.22 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: D:\tools\Program\SQL Server 2008 Enterprise\x86\setup\
Installation edition: ENTERPRISE
User Input Settings:
ACTION: Install
ADDCURRENTUSERASSQLADMIN: False
AGTSVCACCOUNT: NT AUTHORITY\SYSTEM
AGTSVCPASSWORD: *****
AGTSVCSTARTUPTYPE: Manual
ASBACKUPDIR: Backup
ASCOLLATION: Latin1_General_CI_AS
ASCONFIGDIR: Config
ASDATADIR: Data
ASDOMAINGROUP: <empty>
ASLOGDIR: Log
ASPROVIDERMSOLAP: 1
ASSVCACCOUNT: <empty>
ASSVCPASSWORD: *****
ASSVCSTARTUPTYPE: Automatic
ASSYSADMINACCOUNTS: <empty>
ASTEMPDIR: Temp
BROWSERSVCSTARTUPTYPE: Automatic
CONFIGURATIONFILE: C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20090709_145108\ConfigurationFile.ini
ENABLERANU: False
ERRORREPORTING: False
FEATURES: SQLENGINE
FILESTREAMLEVEL: 0
FILESTREAMSHARENAME: <empty>
FTSVCACCOUNT: <empty>
FTSVCPASSWORD: *****
HELP: False
INDICATEPROGRESS: False
INSTALLSHAREDDIR: C:\Program Files\Microsoft SQL Server\
INSTALLSHAREDWOWDIR: C:\Program Files\Microsoft SQL Server\
INSTALLSQLDATADIR: <empty>
INSTANCEDIR: C:\Program Files\Microsoft SQL Server\
INSTANCEID: T2008
INSTANCENAME: T2008
ISSVCACCOUNT: NT AUTHORITY\NetworkService
ISSVCPASSWORD: *****
ISSVCSTARTUPTYPE: Automatic
MEDIASOURCE: D:\tools\Program\SQL Server 2008 Enterprise\
NPENABLED: 0
PID: *****
QUIET: False
QUIETSIMPLE: False
RSINSTALLMODE: FilesOnlyMode
RSSVCACCOUNT: <empty>
RSSVCPASSWORD: *****
RSSVCSTARTUPTYPE: Automatic
SAPWD: *****
SECURITYMODE: <empty>
SQLBACKUPDIR: <empty>
SQLCOLLATION: Turkish_CI_AS
SQLSVCACCOUNT: NT AUTHORITY\SYSTEM
SQLSVCPASSWORD: *****
SQLSVCSTARTUPTYPE: Automatic
SQLSYSADMINACCOUNTS: FUNNYCIK\tugi
SQLTEMPDBDIR: <empty>
SQLTEMPDBLOGDIR: <empty>
SQLUSERDBDIR: <empty>
SQLUSERDBLOGDIR: <empty>
SQMREPORTING: False
TCPENABLED: 1
X86: False
Configuration file: C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20090709_145108\ConfigurationFile.ini
Detailed results:
Feature: Database Engine Services
Status: Failed: see logs for details
MSI status: Passed
Configuration status: Passed
Rules with failures:
Global rules:
Scenario specific rules:
Rules report file: C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20090709_145108\SystemConfigurationCheck_Report.htm
ASKER
uninstalled Microsoft SQL Server Setup Support Files then install again ms sql server 2008 but same error:(
summart.txt for last installation try is below;
summart.txt for last installation try is below;
Overall summary:
Final result: SQL Server installation failed. To continue, investigate the reason for the failure, correct the problem, uninstall SQL Server, and then rerun SQL Server Setup.
Exit code (Decimal): -2068643839
Exit facility code: 1203
Exit error code: 1
Exit message: SQL Server installation failed. To continue, investigate the reason for the failure, correct the problem, uninstall SQL Server, and then rerun SQL Server Setup.
Start time: 2009-07-10 12:40:10
End time: 2009-07-10 12:53:16
Requested action: Install
Log with failure: C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20090710_123817\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.1600.22%26EvtType%3d0x5D9A8C61
Machine Properties:
Machine name: TURGAY
Machine processor count: 2
OS version: Windows XP
OS service pack: Service Pack 3
OS region: Türkiye
OS language: Türkçe (Türkiye)
OS architecture: x86
Process architecture: 32 Bit
OS clustered: No
Product features discovered:
Product Instance Instance ID Feature Language Edition Version Clustered
Sql Server 2000 MSSQLSERVER SQL Server 1033 Personal Edition 8.4.2039 No
Sql Server 2000 MSSQLSERVER Replication Support 1033 Personal Edition 8.4.2039 No
Sql Server 2000 MSSQLSERVER Debug Symbols 1033 Personal Edition 8.4.2039 No
Sql Server 2000 MSSQLSERVER Performance Counters 1033 Personal Edition 8.4.2039 No
Sql Server 2000 MSSQLSERVER Analysis Services 8.00.194 No
Sql Server 2000 TEST SQL Server 1033 Personal Edition 8.4.2039 No
Sql Server 2000 TEST Replication Support 1033 Personal Edition 8.4.2039 No
Sql Server 2000 TEST Debug Symbols 1033 Personal Edition 8.4.2039 No
Sql Server 2000 TEST Performance Counters 1033 Personal Edition 8.4.2039 No
Sql Server 2000 Enterprise Manager Tools 8.00.194 No
Sql Server 2000 Profiler Tools 8.00.194 No
Sql Server 2000 Query Analyzer Tools 8.00.194 No
Sql Server 2000 DTC Client Support Tools 8.00.194 No
Sql Server 2000 Conflict Viewer Tools 8.00.194 No
Sql Server 2000 Client Connectivity Tools 8.00.194 No
Sql Server 2000 Books Online On Disk Tools 8.00.194 No
Sql Server 2000 Debugger Interface Tools 8.00.194 No
Sql Server 2000 AS_Tools Tools 8.00.194 No
Sql Server 2000 DTS Tools 8.00.194 No
Sql Server 2005 SQLEXPRESS MSSQL.1 Database Engine Services 1033 Express Edition 9.3.4035 No
Sql Server 2005 SQLEXPRESS MSSQL.1 SQL Server Replication 1033 Express Edition 9.3.4035 No
Sql Server 2005 SQLEXPRESS MSSQL.1 SharedTools 1033 Express Edition 9.3.4035 No
Sql Server 2005 Tools 1033 Express Edition 9.3.4035 No
Sql Server 2005 ToolsClient 1033 Express Edition 9.3.4035 No
Sql Server 2005 ToolsClient\Connectivity 1033 Express Edition 9.3.4035 No
Sql Server 2008 SQL2008 MSSQL10.SQL2008 Database Engine Services 1033 Enterprise Edition 10.0.1442.32 No
Sql Server 2008 SQL2008 MSSQL10.SQL2008 SQL Server Replication 1033 Enterprise Edition 10.0.1442.32 No
Sql Server 2008 SQL2008 MSSQL10.SQL2008 Full-Text Search 1033 Enterprise Edition 10.0.1442.32 No
Sql Server 2008 SQL2008 MSAS10.SQL2008 Analysis Services 1033 Enterprise Edition 10.0.1442.32 No
Sql Server 2008 SQL2008 MSRS10.SQL2008 Reporting Services 1033 Enterprise Edition 10.0.1442.32 No
Sql Server 2008 S2008 MSSQL10.S2008 Database Engine Services 1033 10.0.1600.22 No
Sql Server 2008 S2008 MSSQL10.S2008 SQL Server Replication 1033 10.0.1600.22 No
Sql Server 2008 S2008 MSSQL10.S2008 Full-Text Search 1033 10.0.1600.22 No
Sql Server 2008 SQ2008 MSSQL10.SQ2008 Database Engine Services 1033 10.0.1600.22 No
Sql Server 2008 SS2008 MSSQL10.SS2008 Database Engine Services 1033 10.0.1600.22 No
Sql Server 2008 SQL10 MSSQL10.SQL10 Database Engine Services 1033 10.0.1600.22 No
Sql Server 2008 S10 MSSQL10.S10 Database Engine Services 1033 10.0.1600.22 No
Sql Server 2008 SQ10 MSSQL10.SQ10 Database Engine Services 1033 10.0.1600.22 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: D:\tools\Program\SQL Server 2008 Enterprise\x86\setup\
Installation edition: ENTERPRISE
User Input Settings:
ACTION: Install
ADDCURRENTUSERASSQLADMIN: False
AGTSVCACCOUNT: NT AUTHORITY\SYSTEM
AGTSVCPASSWORD: *****
AGTSVCSTARTUPTYPE: Manual
ASBACKUPDIR: Backup
ASCOLLATION: Latin1_General_CI_AS
ASCONFIGDIR: Config
ASDATADIR: Data
ASDOMAINGROUP: <empty>
ASLOGDIR: Log
ASPROVIDERMSOLAP: 1
ASSVCACCOUNT: <empty>
ASSVCPASSWORD: *****
ASSVCSTARTUPTYPE: Automatic
ASSYSADMINACCOUNTS: <empty>
ASTEMPDIR: Temp
BROWSERSVCSTARTUPTYPE: Automatic
CONFIGURATIONFILE: C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20090710_123817\ConfigurationFile.ini
ENABLERANU: False
ERRORREPORTING: False
FEATURES: SQLENGINE
FILESTREAMLEVEL: 0
FILESTREAMSHARENAME: <empty>
FTSVCACCOUNT: <empty>
FTSVCPASSWORD: *****
HELP: False
INDICATEPROGRESS: False
INSTALLSHAREDDIR: C:\Program Files\Microsoft SQL Server\
INSTALLSHAREDWOWDIR: C:\Program Files\Microsoft SQL Server\
INSTALLSQLDATADIR: <empty>
INSTANCEDIR: C:\Program Files\Microsoft SQL Server\
INSTANCEID: TURGAY2008
INSTANCENAME: TURGAY2008
ISSVCACCOUNT: NT AUTHORITY\NetworkService
ISSVCPASSWORD: *****
ISSVCSTARTUPTYPE: Automatic
MEDIASOURCE: D:\tools\Program\SQL Server 2008 Enterprise\
NPENABLED: 0
PID: *****
QUIET: False
QUIETSIMPLE: False
RSINSTALLMODE: FilesOnlyMode
RSSVCACCOUNT: <empty>
RSSVCPASSWORD: *****
RSSVCSTARTUPTYPE: Automatic
SAPWD: *****
SECURITYMODE: <empty>
SQLBACKUPDIR: <empty>
SQLCOLLATION: Turkish_CI_AS
SQLSVCACCOUNT: NT AUTHORITY\SYSTEM
SQLSVCPASSWORD: *****
SQLSVCSTARTUPTYPE: Automatic
SQLSYSADMINACCOUNTS: TURGAY\tugi
SQLTEMPDBDIR: <empty>
SQLTEMPDBLOGDIR: <empty>
SQLUSERDBDIR: <empty>
SQLUSERDBLOGDIR: <empty>
SQMREPORTING: False
TCPENABLED: 1
X86: False
Configuration file: C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20090710_123817\ConfigurationFile.ini
Detailed results:
Feature: Database Engine Services
Status: Failed: see logs for details
MSI status: Passed
Configuration status: Passed
Rules with failures:
Global rules:
Scenario specific rules:
Rules report file: C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20090710_123817\SystemConfigurationCheck_Report.htm
Hope you tried to install from DVD.
Copy the contents to your local drive and try the installation again.
Copy the contents to your local drive and try the installation again.
ASKER
@rrjegan17
i tried both..from iso file(with virtual disk) and from local drive..
both same error..:(
i tried both..from iso file(with virtual disk) and from local drive..
both same error..:(
What says the detail log in C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20090710_123 817\Detail .txt ?
ASKER
@pcelba
my last installation detail.txt in here..
http://rapidshare.com/files/254128139/Detail.txt.html
ty
my last installation detail.txt in here..
http://rapidshare.com/files/254128139/Detail.txt.html
ty
The message: "Kullan1c1 hesab1 ad1 geçersiz veya yok veya belirtilen hesap ad1 için parola geçersiz." points to insufficient access rights during the installation. It was raised after several attempts to solve the situation and you selected to cancel the installation.
Did you restrict local admin rights somehow on your computer?
The problem was encountered during the installation of "SQL AD Helper Service" for which the service already exists on the computer but it is impossible to change it by installation program because either the NT AUTHORITY\NETWORK SERVICE or local admin has insufficient rights or even does not exist.
You should discuss with network administrator if it is possible to change AD installed on your computer and why it is restricted. You have to install SQL Server 2008 from user having full access rights.
Did you restrict local admin rights somehow on your computer?
The problem was encountered during the installation of "SQL AD Helper Service" for which the service already exists on the computer but it is impossible to change it by installation program because either the NT AUTHORITY\NETWORK SERVICE or local admin has insufficient rights or even does not exist.
You should discuss with network administrator if it is possible to change AD installed on your computer and why it is restricted. You have to install SQL Server 2008 from user having full access rights.
ASKER
@pcelba
my user (tugi) is a administrator user. i also try installation with administrator..but same result..
my computer is a laptop and we havent got any network administrator here..
ty
my user (tugi) is a administrator user. i also try installation with administrator..but same result..
my computer is a laptop and we havent got any network administrator here..
ty
Reading the detail log it seems you did not uninstall completely the SQL 2008 from the computer (many SQL 2008 related running instances were detected during the setup).
I would recommend to uninstall completely, create a slipstream installation containing SQL2008+SP1 (details on http://blogs.msdn.com/petersad/archive/2009/02/25/sql-server-2008-creating-a-merged-slisptream-drop.aspx), login as local administrator and try the installation again. You should allow the local user to be a SQL admin - you may remove it later.
Having your computer not on hand it is hard to help here. You may post the detail log to MSFT (e.g. at http://connect.microsoft.com/default.aspx)
Some (for you less significant) information are here http://support.microsoft.com/kb/955396
I would recommend to uninstall completely, create a slipstream installation containing SQL2008+SP1 (details on http://blogs.msdn.com/petersad/archive/2009/02/25/sql-server-2008-creating-a-merged-slisptream-drop.aspx), login as local administrator and try the installation again. You should allow the local user to be a SQL admin - you may remove it later.
Having your computer not on hand it is hard to help here. You may post the detail log to MSFT (e.g. at http://connect.microsoft.com/default.aspx)
Some (for you less significant) information are here http://support.microsoft.com/kb/955396
ASKER
okey @pcelba,
i will try tonight to uninstall all sql server 2008 instances.
but i cant understand what did you mean in this sentence "You should allow the local user to be a SQL admin"
my os is XP SP 3
i will try tonight to uninstall all sql server 2008 instances.
but i cant understand what did you mean in this sentence "You should allow the local user to be a SQL admin"
my os is XP SP 3
The detail log contains: AddCurrentUserAsSQLAdmin = False
If such setting is not possible to change during the installation then you can do nothing. Local admins are SQL Server admins by design so, this setting is not necessary for you.
The interesting thing is the point where the installation failed the first time. The detail log pointed to SQL Server Active Directory helper Service. But the reason can be insufficient uninstallation of the previous SQL version. AD helper is normally not necessary to run SQL Server if you don't use AD on the laptop.
XP is not mentioned as supported OS for SQL 2008 Enterprise but this is not the reason of your problems.
If such setting is not possible to change during the installation then you can do nothing. Local admins are SQL Server admins by design so, this setting is not necessary for you.
The interesting thing is the point where the installation failed the first time. The detail log pointed to SQL Server Active Directory helper Service. But the reason can be insufficient uninstallation of the previous SQL version. AD helper is normally not necessary to run SQL Server if you don't use AD on the laptop.
XP is not mentioned as supported OS for SQL 2008 Enterprise but this is not the reason of your problems.
ASKER
uninstalled all sql server 2008 instances,also remove all sql server components in add/remove program..
then try installing again but same problem:(
when i look services i saw there "SQL Server Active Directory Helper" but i cant start it..give an error..
what can i do now?..
ty
then try installing again but same problem:(
when i look services i saw there "SQL Server Active Directory Helper" but i cant start it..give an error..
what can i do now?..
ty
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
You could also look at this blog: http://mark.michaelis.net/Blog/SQLServer2008InstallNightmare.aspx