Upgrade to SQL Server 2012 failed on VS 2010 - how do I fix this?
-
Monday, March 11, 2013 12:01 AM
I have just updated the installation of SQL Server 2008 Developer Edition on my PC to SQL Server 2012 Developer. During the process, a small dialogue box popped up asking me to insert a VS2010 CD. I was running VS2010 at the time and did not relate this dialogue box to the SS2012 installation. I therefore cancelled the dialogue box.
However, it became clear later that a VS2010-related part of the SQL Server 2012 had failed. Everything else was fine.
My problem is that that I have no idea how to fix that failure. Any advice would be much appreciated.
David
All Replies
-
Monday, March 11, 2013 12:37 AMModerator
Hello,
SP1 for VS2010 is required before upgrading to SQL Server 2012.Could you please share the summary.txt log file with us? The following article may help you locate this file on disk:
http://msdn.microsoft.com/en-us/library/ms143702(v=sql.110).aspx
Hope this helps.
Regards,
Alberto Morillo
SQLCoffee.com -
Monday, March 11, 2013 6:58 AMModerator
Hi haggis,
When you install SQL Server 2012 and Visual Studio 2010 side-by-side, I think you could follow the steps below:
1. Install visual studio 2010, turn off "Microsoft SQL Server 2008 Express Service Pack"
2. Install visual studio 2010 Service Pack 1.
3. Install SQL Server 2012.If it failed, please post the error messages in %programfiles%\Microsoft SQL Server\110\Setup Bootstrap\Log\.
If you have any feedback on our support, please click here.
Thanks.
Maggie Luo
TechNet Community Support
-
Monday, March 11, 2013 7:42 AMModerator
Would you please check-out workaround in below blogpost
http://blogs.msdn.com/b/ai/archive/2012/04/28/work-around-for-sql-server-2012-setup-deployment-requiring-access-to-visual-studio-media.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.
-
Monday, March 11, 2013 9:41 AM
Hi Alberto,
Here are the Summary.txt file contents, as requested:EDIT: This Summary.txt file may not be useful. I made several attempts to find a way to fix my problem by re-running the SQL Server installation process and then cancelling when I found it was not going to do what I wanted. As there appears to be only one Summary.txt file I am guessing it only covers the most recent aborted installation. However, I do have no less than 7 dated log file folders from yesterday evening!
----------------------------------------------
Overall summary:
Final result: User cancelled
Exit code (Decimal): -2068380094
Exit facility code: 1207
Exit error code: 1602
Exit message: User has cancelled.
Start time: 2013-03-10 23:48:05
End time: 2013-03-10 23:51:53
Requested action: InstallMachine Properties:
Machine name: DELL_T7500
Machine processor count: 4
OS version: Windows 7
OS service pack: Service Pack 1
OS region: United States
OS language: English (United States)
OS architecture: x64
Process architecture: 64 Bit
OS clustered: NoProduct features discovered:
Product Instance Instance ID Feature Language Edition Version Clustered
SQL Server 2008 SQLEXPRESS MSSQL10.SQLEXPRESS Database Engine Services 1033 Express Edition 10.3.5512.0 No
SQL Server 2008 SQLEXPRESS MSSQL10.SQLEXPRESS SQL Server Replication 1033 Express Edition 10.3.5512.0 No
SQL Server 2008 Management Tools - Basic 1033 Developer Edition 10.3.5512.0 No
SQL Server 2008 Management Tools - Complete 1033 Developer Edition 10.3.5500.0 No
SQL Server 2008 Integration Services 1033 Developer Edition 10.3.5512.0 No
SQL Server 2012 MYMIXMODSQL MSSQL11.MYMIXMODSQL Database Engine Services 1033 Developer Edition 11.1.3128.0 No
SQL Server 2012 MYMIXMODSQL MSSQL11.MYMIXMODSQL SQL Server Replication 1033 Developer Edition 11.1.3128.0 No
SQL Server 2012 MYMIXMODSQL MSSQL11.MYMIXMODSQL Full-Text and Semantic Extractions for Search 1033 Developer Edition 11.1.3000.0 No
SQL Server 2012 MYMIXMODSQL MSAS11.MYMIXMODSQL Analysis Services 1033 Developer Edition 11.1.3128.0 No
SQL Server 2012 MYMIXMODSQL MSRS11.MYMIXMODSQL Reporting Services - Native 1033 Developer Edition 11.1.3128.0 No
SQL Server 2012 Management Tools - Basic 1033 Developer Edition 11.1.3128.0 No
SQL Server 2012 Management Tools - Complete 1033 Developer Edition 11.1.3128.0 No
SQL Server 2012 Integration Services 1033 Developer Edition 11.1.3128.0 No
SQL Server 2012 LocalDB 1033 Express Edition 11.0.2100.60 NoPackage properties:
Description: Microsoft SQL Server 2012 Service Pack 1
ProductName: SQL Server 2012
Type: RTM
Version: 11
Installation location: D:\English\SQLServer2012wSP1\Developer\x64\x64\setup\
Installation edition: DeveloperSlipstream: True
SP Level 1
Patch Level: 11.1.3128.0Product Update Status:
Success: KB 2674319, KB 2793634Product Updates Selected for Installation:
Title: Service Pack 1
Knowledge Based Article: KB 2674319
Version: 11.1.3000.0
Architecture: x64
Language: 1033Title: SQL Server 2012 SP1 GDR Product Update
Knowledge Based Article: KB 2793634
Version: 11.1.3128.0
Architecture: x64
Language: AllUpdate Source: MU
User Input Settings:
ACTION: Install
ADDCURRENTUSERASSQLADMIN: false
AGTSVCACCOUNT: <empty>
AGTSVCPASSWORD: <empty>
AGTSVCSTARTUPTYPE: Manual
ASBACKUPDIR: Backup
ASCOLLATION: Latin1_General_CI_AS
ASCONFIGDIR: Config
ASDATADIR: Data
ASLOGDIR: Log
ASPROVIDERMSOLAP: 1
ASSERVERMODE: MULTIDIMENSIONAL
ASSVCACCOUNT: <empty>
ASSVCPASSWORD: <empty>
ASSVCSTARTUPTYPE: Automatic
ASSYSADMINACCOUNTS: <empty>
ASTEMPDIR: Temp
BROWSERSVCSTARTUPTYPE: Disabled
CLTCTLRNAME: <empty>
CLTRESULTDIR: <empty>
CLTSTARTUPTYPE: 0
CLTSVCACCOUNT: <empty>
CLTSVCPASSWORD: <empty>
CLTWORKINGDIR: <empty>
COMMFABRICENCRYPTION: 0
COMMFABRICNETWORKLEVEL: 0
COMMFABRICPORT: 0
CONFIGURATIONFILE:
CTLRSTARTUPTYPE: 0
CTLRSVCACCOUNT: <empty>
CTLRSVCPASSWORD: <empty>
CTLRUSERS: <empty>
ENABLERANU: false
ENU: true
ERRORREPORTING: false
FEATURES:
FILESTREAMLEVEL: 0
FILESTREAMSHARENAME: <empty>
FTSVCACCOUNT: <empty>
FTSVCPASSWORD: <empty>
HELP: false
IACCEPTSQLSERVERLICENSETERMS: false
INDICATEPROGRESS: false
INSTALLSHAREDDIR: C:\Program Files\Microsoft SQL Server\
INSTALLSHAREDWOWDIR: C:\Program Files (x86)\Microsoft SQL Server\
INSTALLSQLDATADIR: <empty>
INSTANCEDIR: C:\Program Files\Microsoft SQL Server\
INSTANCEID: <empty>
INSTANCENAME: <empty>
ISSVCACCOUNT: NT AUTHORITY\Network Service
ISSVCPASSWORD: <empty>
ISSVCSTARTUPTYPE: Automatic
MATRIXCMBRICKCOMMPORT: 0
MATRIXCMSERVERNAME: <empty>
MATRIXNAME: <empty>
NPENABLED: 0
PID: *****
QUIET: false
QUIETSIMPLE: false
ROLE:
RSINSTALLMODE: DefaultNativeMode
RSSHPINSTALLMODE: DefaultSharePointMode
RSSVCACCOUNT: <empty>
RSSVCPASSWORD: <empty>
RSSVCSTARTUPTYPE: Automatic
SAPWD: <empty>
SECURITYMODE: <empty>
SQLBACKUPDIR: <empty>
SQLCOLLATION: SQL_Latin1_General_CP1_CI_AS
SQLSVCACCOUNT: <empty>
SQLSVCPASSWORD: <empty>
SQLSVCSTARTUPTYPE: Automatic
SQLSYSADMINACCOUNTS: <empty>
SQLTEMPDBDIR: <empty>
SQLTEMPDBLOGDIR: <empty>
SQLUSERDBDIR: <empty>
SQLUSERDBLOGDIR: <empty>
SQMREPORTING: false
TCPENABLED: 0
UIMODE: Normal
UpdateEnabled: true
UpdateSource: MU
X86: falseConfiguration file: C:\Program Files\Microsoft SQL Server\110\Setup Bootstrap\Log\20130310_234423\ConfigurationFile.ini
Rules with failures:
Global rules:
Scenario specific rules:
Rules report file: C:\Program Files\Microsoft SQL Server\110\Setup Bootstrap\Log\20130310_234423\SystemConfigurationCheck_Report.htm
Exception summary:
The following is an exception stack listing the exceptions in outermost to innermost order
Inner exceptions are being indentedException type: Microsoft.SqlServer.Chainer.Infrastructure.CancelException
Message:
User has cancelled.
HResult : 0x84b70642
FacilityCode : 1207 (4b7)
ErrorCode : 1602 (0642)
Stack:
at Microsoft.SqlServer.Configuration.UIExtension.Request.Wait()
at Microsoft.SqlServer.Configuration.UIExtension.UserInterfaceProxy.NavigateToWaypoint(String moniker)
at Microsoft.SqlServer.Configuration.UIExtension.WaypointAction.ExecuteAction(String actionId)
at Microsoft.SqlServer.Chainer.Infrastructure.Action.Execute(String actionId, TextWriter errorStream)
at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionInvocation.ExecuteActionHelper(TextWriter statusStream, ISequencedAction actionToRun, ServiceContainer context)- Edited by haggis999 Monday, March 11, 2013 10:11 AM
-
Monday, March 11, 2013 10:03 AM
Hi Ahmed,
Your blog post starts with the statement "In some situation during SQL server setup access to VS media is required, if the media is not there then SQL setup may be blocked, here is workaround for this situation".In my case, cancelling the request for VS 2010 media did not appear to stop the SQL Server installation process. I appear to have all the expected items in the Start menu on my PC and I have already used SSMS 2012 without any problem. My only known problem was the warning that some aspect of the installation relating to VS 2010 had failed (and VS 2010 fails to open a SQL Server 2012 database). That is what I need help to fix.
David
-
Monday, March 11, 2013 10:31 AM
More than one person has mentioned SP1 for VS 2010. My Windows Update log shows that this was installed in November 2011. However, I was prompted to install an update to SP1 some time yesterday evening (I can't now remember if this was before or after my SQL Server 2012 installation).
I am assuming that none of this is really relevant as the 'preflight checks' all showed my machine as being ready for the SQL Server 2012 update.
-
Monday, March 11, 2013 11:55 AMModerator
Can you try repairing Visual studio installed on your machine
Through control panel then select repair option ?
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.
-
Tuesday, March 12, 2013 12:04 AM
Hi Ahmed,
I have just tried running a 'Repair' installation via Control Panel but it asked for the VS 2010 CD. I couldn't find such a CD among my collection, probably because I think I installed VS 2010 Pro via a download. Obviously, it was some time ago so my memories are a little vague. I tried using the VS 2010 Pro disk that came with my MSDN subscription but this was not accepted.Any suggestions for when I try again tomorrow (it's bedtime here in the UK)?
David
-
Tuesday, March 12, 2013 5:07 AMModerator
Can you try the approach in below blogpost
http://blogs.msdn.com/b/ai/archive/2012/04/28/work-around-for-sql-server-2012-setup-deployment-requiring-access-to-visual-studio-media.aspx
to overcome missing VS DVD
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.
-
Tuesday, March 12, 2013 11:10 AM
Ahmed,
Before reading your post this morning I had already realised your blog was now relevant to my current situation. I have now completed a repair installation of VS 2010 using the download option (this took ages because I only have a 6Mbps broadband connection). The result was "Setup Maintenance completed successfully, however there were some warnings were detected" (the grammatical error belongs to MS, not me!). There were 6 obscure warning messages, all similar to "Warning: Missing fwlink entry for cabinet: #GDR.cab".VS 2010 seems to be working normally but I still have no ability to run any Views contained in a SQL Server 2012 database. I just get a message stating that 'This server version is not supported. Only servers up to Microsoft SQL Server 2008 are supported'. Where do I go from here?
David
