unable to upgrade sql instance from 2008 to 2012
-
Friday, February 08, 2013 9:00 AM
Hi all!
I'm having a HUGE problem, that I was unable to solve browsing the web.
The problem is bigger than this post, in short I messed up my lync 2013 upgrade, and now need to publish my topology to the sql server used by the 2010 pool.
So, here's the deal:
I've managed to upgrade successfully SQL server 2008 to 2012 enterprise edition.
But when I check the version of my instance, it's still the old one.
So, after the upgrade, when trying to publish the topology on lync server, I get this error:
Error: SQL version is not high enough. Minimum SQL Server must be major version 10 and minor version 50 and build 1600 (2008 R2) or higher. This SQL Server is major version 10, minor version 0, and build 5500.
I've tried to follow the steps according to this technet article, but got no results.
Also, I've tried using SQL dump, but still no results.
Can anyone help me out? :)
Cheers,
Andrey
All Replies
-
Friday, February 08, 2013 10:56 AMModerator
Hello,
Please share with us the summary.txt log file. The following article may help you locate the file on disk:
http://technet.microsoft.com/en-us/library/ms143702(v=sql.110)Please share with us the result of Discovery Report too.
http://blogs.msdn.com/b/petersad/archive/2009/11/13/sql-server-2008-discovery-report.aspx
Thank you in advance.
Regards,
Alberto Morillo
SQLCoffee.com -
Friday, February 08, 2013 11:18 AM
Hello Alberto,
Please find below the reports solicited:
summary.txt
Overall summary:
Final result: Passed
Exit code (Decimal): 0
Start time: 2013-02-07 16:48:40
End time: 2013-02-07 16:59:53
Requested action: Upgrade
Machine Properties:
Machine name: INTSQL01LDA
Machine processor count: 1
OS version: Windows Server 2008 R2
OS service pack: Service Pack 1
OS region: United States
OS language: English (United States)
OS architecture: x64
Process architecture: 64 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 Enterprise Edition 10.3.5500.0 No
SQL Server 2008 MSSQLSERVER MSSQL10.MSSQLSERVER SQL Server Replication 1033 Enterprise Edition 10.3.5500.0 No
SQL Server 2008 MSSQLSERVER MSSQL10.MSSQLSERVER Full-Text and Semantic Extractions for Search 1033 Enterprise Edition 10.3.5500.0 No
SQL Server 2008 MSSQLSERVER MSAS10.MSSQLSERVER Analysis Services 1033 Enterprise Edition 10.3.5500.0 No
SQL Server 2008 Management Tools - Basic 1033 Enterprise Edition 10.3.5500.0 No
SQL Server 2008 Management Tools - Complete 1033 Enterprise Edition 10.3.5500.0 No
SQL Server 2008 Client Tools Connectivity 1033 Enterprise Edition 10.3.5500.0 No
SQL Server 2008 Client Tools Backwards Compatibility 1033 Enterprise Edition 10.3.5500.0 No
SQL Server 2008 Client Tools SDK 1033 Enterprise Edition 10.3.5500.0 No
SQL Server 2008 Integration Services 1033 Enterprise Edition 10.3.5500.0 No
SQL Server 2012 MSSQLSERVER.INACTIVE MSSQL11.MSSQLSERVER Database Engine Services 1033 Enterprise Edition: Core-based Licensing 11.1.3000.0 No
SQL Server 2012 MSSQLSERVER.INACTIVE MSSQL11.MSSQLSERVER SQL Server Replication 1033 Enterprise Edition: Core-based Licensing 11.1.3000.0 No
SQL Server 2012 MSSQLSERVER.INACTIVE MSSQL11.MSSQLSERVER Full-Text and Semantic Extractions for Search 1033 Enterprise Edition: Core-based Licensing 11.1.3000.0 No
SQL Server 2012 MSSQLSERVER.INACTIVE MSAS11.MSSQLSERVER Analysis Services 1033 Enterprise Edition: Core-based Licensing 11.1.3000.0 No
SQL Server 2012 MSSQLSERVER.INACTIVE MSRS11.MSSQLSERVER Reporting Services - Native 1033 Enterprise Edition: Core-based Licensing 11.1.3000.0 No
Package properties:
Description: Microsoft SQL Server 2012 Service Pack 1
ProductName: SQL Server 2012
Type: RTM
Version: 11
Installation location: d:\x64\setup\
Installation edition: Enterprise Edition: Core-based Licensing
Slipstream: True
SP Level 1
Product Update Status:
Success: KB 2674319
Product Updates Selected for Installation:
Title: Service Pack 1
Knowledge Based Article: KB 2674319
Version: 11.1.3000.0
Architecture: x64
Language: 1033
Update Source: MU
User Input Settings:
ACTION: Upgrade
AGTDOMAINGROUP: <empty>
ALLOWUPGRADEFORSSRSSHAREPOINTMODE: false
CONFIGURATIONFILE: C:\Program Files\Microsoft SQL Server\110\Setup Bootstrap\Log\20130207_164636\ConfigurationFile.ini
ENU: true
ERRORREPORTING: false
FAILOVERCLUSTERROLLOWNERSHIP: 2
FTSVCACCOUNT: <empty>
FTSVCPASSWORD: <empty>
FTUPGRADEOPTION: Import
HELP: false
IACCEPTSQLSERVERLICENSETERMS: true
INDICATEPROGRESS: false
INSTANCEID: <empty>
INSTANCENAME: <empty>
ISSVCACCOUNT: NT Service\MsDtsServer110
ISSVCPASSWORD: <empty>
ISSVCSTARTUPTYPE: Automatic
PID: *****
QUIET: false
QUIETSIMPLE: false
RSCATALOGSERVERINSTANCENAME: Unknown
RSUPGRADEDATABASEACCOUNT: <empty>
RSUPGRADEPASSWORD: <empty>
SQMREPORTING: false
UIMODE: Normal
UpdateEnabled: true
UpdateSource: MU
X86: false
Configuration file: C:\Program Files\Microsoft SQL Server\110\Setup Bootstrap\Log\20130207_164636\ConfigurationFile.ini
Detailed results:
Feature: Management Tools - Complete
Status: Passed
Feature: Client Tools Connectivity
Status: Passed
Feature: Client Tools SDK
Status: Passed
Feature: Client Tools Backwards Compatibility
Status: Passed
Feature: Management Tools - Basic
Status: Passed
Feature: SQL Server Data Tools
Status: Passed
Feature: Integration Services
Status: Passed
Feature: Documentation Components
Status: Passed
Rules with failures:
Global rules:
Scenario specific rules:
Rules report file: C:\Program Files\Microsoft SQL Server\110\Setup Bootstrap\Log\20130207_164636\SystemConfigurationCheck_Report.htmDiscovery Report
Microsoft SQL Server 2012 Service Pack 1 Setup Discovery Report
Product Instance Instance ID Feature Language Edition Version Clustered Microsoft SQL Server 2012 MSSQLSERVER.INACTIVE MSSQL11.MSSQLSERVER Database Engine Services 1033 Enterprise Edition: Core-based Licensing 11.1.3000.0 No Microsoft SQL Server 2012 MSSQLSERVER.INACTIVE MSSQL11.MSSQLSERVER SQL Server Replication 1033 Enterprise Edition: Core-based Licensing 11.1.3000.0 No Microsoft SQL Server 2012 MSSQLSERVER.INACTIVE MSSQL11.MSSQLSERVER Full-Text and Semantic Extractions for Search 1033 Enterprise Edition: Core-based Licensing 11.1.3000.0 No Microsoft SQL Server 2012 MSSQLSERVER.INACTIVE MSAS11.MSSQLSERVER Analysis Services 1033 Enterprise Edition: Core-based Licensing 11.1.3000.0 No Microsoft SQL Server 2012 MSSQLSERVER.INACTIVE MSRS11.MSSQLSERVER Reporting Services - Native 1033 Enterprise Edition: Core-based Licensing 11.1.3000.0 No Microsoft SQL Server 2012 Management Tools - Basic 1033 Enterprise Edition: Core-based Licensing 11.1.3000.0 No Microsoft SQL Server 2012 Management Tools - Complete 1033 Enterprise Edition: Core-based Licensing 11.1.3000.0 No Microsoft SQL Server 2012 Client Tools Connectivity 1033 Enterprise Edition: Core-based Licensing 11.1.3000.0 No Microsoft SQL Server 2012 Client Tools Backwards Compatibility 1033 Enterprise Edition: Core-based Licensing 11.1.3000.0 No Microsoft SQL Server 2012 Client Tools SDK 1033 Enterprise Edition: Core-based Licensing 11.1.3000.0 No Microsoft SQL Server 2012 Integration Services 1033 Enterprise Edition: Core-based Licensing 11.1.3000.0 No Microsoft SQL Server 2008 MSSQLSERVER MSSQL10.MSSQLSERVER Database Engine Services 1033 Enterprise Edition 10.3.5500.0 No Microsoft SQL Server 2008 MSSQLSERVER MSSQL10.MSSQLSERVER SQL Server Replication 1033 Enterprise Edition 10.3.5500.0 No Microsoft SQL Server 2008 MSSQLSERVER MSSQL10.MSSQLSERVER Full-Text and Semantic Extractions for Search 1033 Enterprise Edition 10.3.5500.0 No Microsoft SQL Server 2008 MSSQLSERVER MSAS10.MSSQLSERVER Analysis Services 1033 Enterprise Edition 10.3.5500.0 No Microsoft SQL Server 2008 Management Tools - Basic 1033 Enterprise Edition 10.3.5500.0 No Microsoft SQL Server 2008 Management Tools - Complete 1033 Enterprise Edition 10.3.5500.0 No Microsoft SQL Server 2008 Client Tools Connectivity 1033 Enterprise Edition 10.3.5500.0 No Microsoft SQL Server 2008 Client Tools Backwards Compatibility 1033 Enterprise Edition 10.3.5500.0 No Microsoft SQL Server 2008 Client Tools SDK 1033 Enterprise Edition 10.3.5500.0 No Microsoft SQL Server 2008 Integration Services 1033 Enterprise Edition 10.3.5500.0 No Thanks for your reply!
Regards,
Andrey Santana
-
Friday, February 08, 2013 12:06 PMModerator
Hello,
The upgrade was not successful. At this time you have an orphan SQL Server instance. To troubleshoot this issue please read the following post:
http://blogs.msdn.com/b/baliles/archive/2012/04/27/how-to-fix-a-failed-sql-2005-2008-r2-or-2012-install-upgrade-mssqlserver-inactive.aspx
Hope this helps.
Regards,
Alberto Morillo
SQLCoffee.com -
Friday, February 08, 2013 2:20 PM
Hi!
It sure helped, there was a time that I could not run the "upgrade" option.
After following the post suggested, the sql upgrade ran, but I got into an error:
If I'm not mistaken, this was the same error I got when trying to upgrade it the 1st time!
I must confess, I have no SQL knowledge, usually I follow documentation online.
You have any clue on how to solve this?
Regards,
Andrey
-
Friday, February 08, 2013 2:43 PMModerator
Hello,
Please share the summary.txt log file and the detailed.txt log file. The following article may help you locate those files on disk:
http://technet.microsoft.com/en-us/library/ms143702(v=sql.110)
Hope this helps.
Regards,
Alberto Morillo
SQLCoffee.com -
Friday, February 08, 2013 2:48 PM
Sure,
Sure, however the detailed.txt is too big to fit into a post, can I e-mail it to you?
Cheers,
Andrey
summary.txt
Overall summary:
Final result: Passed
Exit code (Decimal): 0
Start time: 2013-02-08 15:36:45
End time: 2013-02-08 15:36:56
Requested action: RunDiscovery
Machine Properties:
Machine name: INTSQL01LDA
Machine processor count: 1
OS version: Windows Server 2008 R2
OS service pack: Service Pack 1
OS region: United States
OS language: English (United States)
OS architecture: x64
Process architecture: 64 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 Enterprise Edition 10.3.5500.0 No
SQL Server 2008 MSSQLSERVER MSSQL10.MSSQLSERVER SQL Server Replication 1033 Enterprise Edition 10.3.5500.0 No
SQL Server 2008 MSSQLSERVER MSSQL10.MSSQLSERVER Full-Text and Semantic Extractions for Search 1033 Enterprise Edition 10.3.5500.0 No
SQL Server 2008 MSSQLSERVER MSAS10.MSSQLSERVER Analysis Services 1033 Enterprise Edition 10.3.5500.0 No
SQL Server 2008 Management Tools - Basic 1033 Enterprise Edition 10.3.5500.0 No
SQL Server 2008 Management Tools - Complete 1033 Enterprise Edition 10.3.5500.0 No
SQL Server 2008 Client Tools Connectivity 1033 Enterprise Edition 10.3.5500.0 No
SQL Server 2008 Client Tools Backwards Compatibility 1033 Enterprise Edition 10.3.5500.0 No
SQL Server 2008 Client Tools SDK 1033 Enterprise Edition 10.3.5500.0 No
SQL Server 2008 Integration Services 1033 Enterprise Edition 10.3.5500.0 No
SQL Server 2012 Management Tools - Basic 1033 Enterprise Edition: Core-based Licensing 11.1.3000.0 No
SQL Server 2012 Management Tools - Complete 1033 Enterprise Edition: Core-based Licensing 11.1.3000.0 No
SQL Server 2012 Client Tools Connectivity 1033 Enterprise Edition: Core-based Licensing 11.1.3000.0 No
SQL Server 2012 Client Tools Backwards Compatibility 1033 Enterprise Edition: Core-based Licensing 11.1.3000.0 No
SQL Server 2012 Client Tools SDK 1033 Enterprise Edition: Core-based Licensing 11.1.3000.0 No
SQL Server 2012 Integration Services 1033 Enterprise Edition: Core-based Licensing 11.1.3000.0 No
Package properties:
Description: Microsoft SQL Server 2012 Service Pack 1
ProductName: SQL Server 2012
Type: RTM
Version: 11
SPLevel: 0
Installation location: D:\x64\setup\
Installation edition:
User Input Settings:
ACTION: RunDiscovery
CONFIGURATIONFILE:
ENU: true
HELP: false
IACCEPTSQLSERVERLICENSETERMS: false
INDICATEPROGRESS: false
QUIET: false
QUIETSIMPLE: false
UIMODE: Normal
X86: false
Configuration file: C:\Program Files\Microsoft SQL Server\110\Setup Bootstrap\Log\20130208_153634\ConfigurationFile.ini
Rules with failures:
Global rules:
There are no scenario-specific rules.
Rules report file: The rule result report file is not available.
- Edited by Andrey Santana Friday, February 08, 2013 2:54 PM
-
Friday, February 08, 2013 3:02 PMModerator
Hello,
I cannot find any information on the summary.txt, please upload the file on the Public folder of your skydrive.live.com account, and share with us the URL of the Public folder.
Thank you in advance.
Regards,
Alberto Morillo
SQLCoffee.com -
Friday, February 08, 2013 3:12 PM
Here you go:
https://skydrive.live.com/redir?resid=136005D04E9B6AA2!252&authkey=!ACHAqoEL222amUA
Cheers,
Andrey
-
Friday, February 08, 2013 3:32 PMModerator
Hello,
I found the following warning and error:
MsiExtension.GetDiskCost: Warning: No matched disk size is detected for feature ALL_VSHelpLP_Cpu64_1053 and directory SystemDrive(01) 2013-02-08 15:36:52 Slp: Sco: File 'D:\redist\DotNetFrameworks\x64\dotNetFx40_Full_x86_x64.exe' does not exist
About the error, I would try reinstall or repair .NET Framework 4.0, and then run SQL Server setup again.
About the warning, I have never seen that warning before, but hopefully solving the issue with .NET Framework 4 we can proceed with upgrade process.
Hope this helps.
Regards,
Alberto Morillo
SQLCoffee.com- Proposed As Answer by Fanny LiuMicrosoft Contingent Staff, Moderator Wednesday, February 13, 2013 10:03 AM
-
Friday, February 08, 2013 11:26 PMModerator
Would you please check-out
http://blogs.msdn.com/b/ai/archive/2012/10/12/recovering-from-sql-server-upgrade-failure.aspx
FAQ
----
Regards,
Ahmed Ibrahim
SQL Server Setup Team
My Blog
This posting is provided "AS IS" with no warranties, and confers no rights. Please remember to click "Mark as Answer" and "Vote as Helpful" on posts that help you.
This can be beneficial to other community members reading the thread.
-
Wednesday, February 13, 2013 3:37 PM
Hi!
It looks like it has cleared something, but its still not working..
Cheers,
Andrey
-
Wednesday, February 13, 2013 3:57 PM
Hi Alberto!
Sorry for the late reply, for I've been busy troubleshooting this!
I've fixed all errors regarding .net, I uninstalled .NET Framework 4.0 and installed .NET Framework 4.5
However, when trying to upgrade it, it still fails.
Please find below the summary.txt and the link to the detailed file.
Cheers,
Andrey
Summary
Overall summary:
Final result: Failed: see details below
Exit code (Decimal): -2068119551
Start time: 2013-02-11 16:35:24
End time: 2013-02-11 16:46:52
Requested action: Upgrade
Setup completed with required actions for features.
Troubleshooting information for those features:
Next step for SQLEngine: The upgrade process for SQL Server failed. To continue the upgrade process, use the following information to resolve the error. Next, uninstall SQL Server by using this command line: setup /q /action=uninstall /instanceid=MSSQLSERVER /features=SQLENGINE,FULLTEXT,REPLICATION,AS. Then, run SQL Server Setup again.
Next step for FullText: The upgrade process for SQL Server failed. To continue the upgrade process, use the following information to resolve the error. Next, uninstall SQL Server by using this command line: setup /q /action=uninstall /instanceid=MSSQLSERVER /features=SQLENGINE,FULLTEXT,REPLICATION,AS. Then, run SQL Server Setup again.
Next step for Replication: The upgrade process for SQL Server failed. To continue the upgrade process, use the following information to resolve the error. Next, uninstall SQL Server by using this command line: setup /q /action=uninstall /instanceid=MSSQLSERVER /features=SQLENGINE,FULLTEXT,REPLICATION,AS. Then, run SQL Server Setup again.
Next step for AS: The upgrade process for SQL Server failed. To continue the upgrade process, use the following information to resolve the error. Next, uninstall SQL Server by using this command line: setup /q /action=uninstall /instanceid=MSSQLSERVER /features=SQLENGINE,FULLTEXT,REPLICATION,AS. Then, run SQL Server Setup again.
Machine Properties:
Machine name: INTSQL01LDA
Machine processor count: 1
OS version: Windows Server 2008 R2
OS service pack: Service Pack 1
OS region: United States
OS language: English (United States)
OS architecture: x64
Process architecture: 64 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 Enterprise Edition 10.3.5500.0 No
SQL Server 2008 MSSQLSERVER MSSQL10.MSSQLSERVER SQL Server Replication 1033 Enterprise Edition 10.3.5500.0 No
SQL Server 2008 MSSQLSERVER MSSQL10.MSSQLSERVER Full-Text and Semantic Extractions for Search 1033 Enterprise Edition 10.3.5500.0 No
SQL Server 2008 MSSQLSERVER MSAS10.MSSQLSERVER Analysis Services 1033 Enterprise Edition 10.3.5500.0 No
SQL Server 2008 Management Tools - Basic 1033 Enterprise Edition 10.3.5500.0 No
SQL Server 2008 Management Tools - Complete 1033 Enterprise Edition 10.3.5500.0 No
SQL Server 2008 Client Tools Connectivity 1033 Enterprise Edition 10.3.5500.0 No
SQL Server 2008 Client Tools Backwards Compatibility 1033 Enterprise Edition 10.3.5500.0 No
SQL Server 2008 Client Tools SDK 1033 Enterprise Edition 10.3.5500.0 No
SQL Server 2008 Integration Services 1033 Enterprise Edition 10.3.5500.0 No
Package properties:
Description: Microsoft SQL Server 2012 Service Pack 1
ProductName: SQL Server 2012
Type: RTM
Version: 11
Installation location: D:\x64\setup\
Installation edition: Enterprise Edition: Core-based Licensing
Slipstream: True
SP Level 1
Product Update Status:
Success: KB 2674319
Product Updates Selected for Installation:
Title: Service Pack 1
Knowledge Based Article: KB 2674319
Version: 11.1.3000.0
Architecture: x64
Language: 1033
Update Source: MU
User Input Settings:
ACTION: Upgrade
AGTDOMAINGROUP: <empty>
ALLOWUPGRADEFORSSRSSHAREPOINTMODE: false
CONFIGURATIONFILE: C:\Program Files\Microsoft SQL Server\110\Setup Bootstrap\Log\20130211_163421\ConfigurationFile.ini
ENU: true
ERRORREPORTING: false
FAILOVERCLUSTERROLLOWNERSHIP: 2
FTSVCACCOUNT: NT Service\MSSQLFDLauncher
FTSVCPASSWORD: <empty>
FTUPGRADEOPTION: Import
HELP: false
IACCEPTSQLSERVERLICENSETERMS: true
INDICATEPROGRESS: false
INSTANCEID: MSSQLSERVER
INSTANCENAME: MSSQLSERVER
ISSVCACCOUNT: NT Service\MsDtsServer110
ISSVCPASSWORD: <empty>
ISSVCSTARTUPTYPE: Automatic
PID: *****
QUIET: false
QUIETSIMPLE: false
RSCATALOGSERVERINSTANCENAME: Unknown
RSUPGRADEDATABASEACCOUNT: <empty>
RSUPGRADEPASSWORD: <empty>
SQMREPORTING: false
UIMODE: Normal
UpdateEnabled: true
UpdateSource: MU
X86: false
Configuration file: C:\Program Files\Microsoft SQL Server\110\Setup Bootstrap\Log\20130211_163421\ConfigurationFile.ini
Detailed results:
Feature: Management Tools - Complete
Status: Passed
Feature: Client Tools Connectivity
Status: Passed
Feature: Client Tools SDK
Status: Passed
Feature: Client Tools Backwards Compatibility
Status: Passed
Feature: Management Tools - Basic
Status: Passed
Feature: SQL Server Data Tools
Status: Passed
Feature: Database Engine Services
Status: Failed: see logs for details
Reason for failure: An error occurred for a dependency of the feature causing the setup process for the feature to fail.
Next Step: The upgrade process for SQL Server failed. To continue the upgrade process, use the following information to resolve the error. Next, uninstall SQL Server by using this command line: setup /q /action=uninstall /instanceid=MSSQLSERVER /features=SQLENGINE,FULLTEXT,REPLICATION,AS. Then, run SQL Server Setup again.
Component name: SQL Server Full Text Search
Component error code: 0x84BB0001
Error description: The name is already in use as either a service name or a service display name.
Error help link: http://go.microsoft.com/fwlink?LinkId=20476&ProdName=Microsoft+SQL+Server&EvtSrc=setup.rll&EvtID=50000&ProdVer=11.0.3000.0&EvtType=0x8123A9E2%400xDC80C325&EvtType=0x8123A9E2%400xDC80C325
Feature: Full-Text and Semantic Extractions for Search
Status: Failed: see logs for details
Reason for failure: An error occurred during the setup process of the feature.
Next Step: The upgrade process for SQL Server failed. To continue the upgrade process, use the following information to resolve the error. Next, uninstall SQL Server by using this command line: setup /q /action=uninstall /instanceid=MSSQLSERVER /features=SQLENGINE,FULLTEXT,REPLICATION,AS. Then, run SQL Server Setup again.
Component name: SQL Server Full Text Search
Component error code: 0x84BB0001
Error description: The name is already in use as either a service name or a service display name.
Error help link: http://go.microsoft.com/fwlink?LinkId=20476&ProdName=Microsoft+SQL+Server&EvtSrc=setup.rll&EvtID=50000&ProdVer=11.0.3000.0&EvtType=0x8123A9E2%400xDC80C325&EvtType=0x8123A9E2%400xDC80C325
Feature: SQL Server Replication
Status: Failed: see logs for details
Reason for failure: An error occurred for a dependency of the feature causing the setup process for the feature to fail.
Next Step: The upgrade process for SQL Server failed. To continue the upgrade process, use the following information to resolve the error. Next, uninstall SQL Server by using this command line: setup /q /action=uninstall /instanceid=MSSQLSERVER /features=SQLENGINE,FULLTEXT,REPLICATION,AS. Then, run SQL Server Setup again.
Component name: SQL Server Full Text Search
Component error code: 0x84BB0001
Error description: The name is already in use as either a service name or a service display name.
Error help link: http://go.microsoft.com/fwlink?LinkId=20476&ProdName=Microsoft+SQL+Server&EvtSrc=setup.rll&EvtID=50000&ProdVer=11.0.3000.0&EvtType=0x8123A9E2%400xDC80C325&EvtType=0x8123A9E2%400xDC80C325
Feature: Integration Services
Status: Passed
Feature: Analysis Services
Status: Failed: see logs for details
Reason for failure: An error occurred for a dependency of the feature causing the setup process for the feature to fail.
Next Step: The upgrade process for SQL Server failed. To continue the upgrade process, use the following information to resolve the error. Next, uninstall SQL Server by using this command line: setup /q /action=uninstall /instanceid=MSSQLSERVER /features=SQLENGINE,FULLTEXT,REPLICATION,AS. Then, run SQL Server Setup again.
Component name: SQL Server Full Text Search
Component error code: 0x84BB0001
Error description: The name is already in use as either a service name or a service display name.
Error help link: http://go.microsoft.com/fwlink?LinkId=20476&ProdName=Microsoft+SQL+Server&EvtSrc=setup.rll&EvtID=50000&ProdVer=11.0.3000.0&EvtType=0x8123A9E2%400xDC80C325&EvtType=0x8123A9E2%400xDC80C325
Feature: Documentation Components
Status: Passed
Rules with failures:
Global rules:
Scenario specific rules:
Rules report file: C:\Program Files\Microsoft SQL Server\110\Setup Bootstrap\Log\20130211_163421\SystemConfigurationCheck_Report.htm
-
Wednesday, February 13, 2013 4:23 PMModerator
Hello,
The upgrade process failed. Setup is requesting to execute the following command and then run setup again.
setup /q /action=uninstall /instanceid=MSSQLSERVER /features=SQLENGINE,FULLTEXT,REPLICATION,AS
The error 0x84BB0001 means access denied. Probably the upgrade failed because of permissions issues accessing resources like the Registry, files, etc.Regards,
Alberto Morillo
SQLCoffee.com- Edited by Alberto MorilloMVP, Moderator Wednesday, February 13, 2013 5:39 PM
- Proposed As Answer by Fanny LiuMicrosoft Contingent Staff, Moderator Friday, February 15, 2013 8:40 AM
-
Friday, February 22, 2013 4:00 PM
Hi!
After chatting with MS support, I finally solved my issue:
Backed up SQL DBs
Uninstalled SQL 2008
Fresh Install of SQL 2012
Restored SQL DBs
Well, I had to create a new fresh server because I couldn't uninstall SQL 2008, but it ends up the same way.
Hope this helps someone!
CHeers,
Andrey
- Marked As Answer by Andrey Santana Friday, February 22, 2013 4:00 PM
.png)
