You can find the PowerShell installer as part of the Windows PowerShell 2.0 and WinRM 2.0 for Windows Server 2008 x64 Edition (KB968930) package at the Microsoft Download Center.
If you don't install PowerShell 2.0 in advance on Windows Server 2008 R1 machines you will be informed by SQL Server 2012 setup that the "Windows PowerShell 2.0 already installed." rule failed. If you click the "details" link, you will get the following message:
The link that is provided in the above message is mostly useless. It just brings you to the Knowledge Base article and doesn't provide any information on how to actually get the update you need. This update requires a reboot of the server so you can go ahead and quit out of the SQL Server 2012 installer.
By the way, if you're doing a fresh installation of SQL Server 2012, go ahead and put it on Windows Server 2008 R2 and save yourself the headache of upgrading the OS in the future.
Did this help you? Please let me know in the comments!
I have download the Windows6.0-KB968930-x86 and install successfully. after that, install sql2012 also fail.
ReplyDeleteException type: Microsoft.SqlServer.Configuration.RulesEngineExtension.RulesEngineRuleFailureException
Message:
Setup did not detect Windows PowerShell 2.0 was installed. To continue with this feature selection, manually install Windows PowerShell 2.0 by following the instructions at http://go.microsoft.com/fwlink/?LinkId=186214, search for Windows PowerShell 2.0 through Windows Update or do not select the features that require Windows PowerShell 2.0.
HResult : 0x84be0260
FacilityCode : 1214 (4be)
ErrorCode : 608 (0260)
I presume that your server is a 32-bit machine since you were able to install the 32-bit version of the WinRM 2.0. If this is the case, double check your installation of PowerShell and make sure it works by getting into the IDE and running some "Get" commands. See PowerShell docs for more info.
DeletePowerShell docs: http://technet.microsoft.com/en-us/library/bb978526.aspx
Is this a fresh installation or are you upgrading from an earlier version of SQL Server? If you're doing a fresh install on a new machine I suggest you go ahead and put Windows Server 2012 on it. Also go with 64-bit if you can so you don't limit yourself on memory.
Thank you.
DeleteEnable the PowerShell feature, this default version is 1.0. After that, did the PowerShell 2.0 update. Then , install SQL14 succeed.
https://support.microsoft.com/en-us/kb/968930
ReplyDeleteThanks for the description of the issue!
ReplyDelete