При попытке установить RTM версию SQL Server 2012 Standard на свеже-установленную ОС Windows Server 2012 при отсутствии прямого подключения к интернету можно получить ошибку включения зависимой компоненты: NetFx3 -2146498298
При этом процесс установки проходит до конца но не устанавливает основные компоненты SQL Server.
Для решения этой проблемы нам потребуется отдельно установить компоненты .Net Framework 3.5. Так как эти компоненты входят в состав дистрибутива Windows Server 2012, можно вставив установочный диск ОС (в нашем примере буква диска — S:), выполнить команду (с правами Администратора):
Dism /online /enable-feature /featurename:NetFX3 /All /Source:S:\sources\SxS /LimitAccess
Или же мы можем установить эти компоненты через мастер добавления ролей и возможностей Add Roles and Features Wizard в оснастке Server Manager. После того как на шаге Features мы отметим .NET Framework 3.5 Features вызовем окно дополнительной настройки указания места расположения установочных файлов ОС – Specify an alternate source path
Укажем каталог полный пусть к подкаталогу Sources\SxS на нашем DVD-накопителе или сетевой папке, в которую мы предварительно скопировали содержимое установочного диска Windows Server 2012.
Если путь указан верно, то процесс добавления компонент .Net Framework 3.5 пройдёт успешно.
После этого можно заново повторить процедуру установки необходимых компонент SQL Server 2012. Возможно при повторном запуске инсталлятора мы получим ошибку:
System.IO.FileNotFoundException: Could not load file or assembly ‘System, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089’ or one of its dependencies. The system cannot find the file specified.
Появление этой ошибки будет вести к отмене вызова окна программы установки SQL Server. Эта “болячка” известна ещё со времени SQL Server 2008 R2 и для решения этой проблемы необходимо найти указанный в тексте ошибки файл user.config и удалить его.
В нашем примере файл расположен в каталоге
%USERPROFILE%\AppData\Local\Microsoft_Corporation\LandingPage.exe_StrongName_ryspccglaxmt4nhllj5z3thycltsvyyx\11.0.0.0
После этого процесс установки SQL Server 2012 должен завершиться без ошибок.
Источники информации:
- Tom Van Gaever — Installation of SQL Server 2012 on Server 2012 beta: NetFx3.5 is a Feature on Demand
- Microsoft Connect — 640350 — Install VS2008, 2010 and SQL 2008 R2, generates installer error
While creating one of many Lync scenario labs, I chose to install SQL Server 2012 instead of my usual install of SQL 2008 on Windows Server 2012. Going about my happy routine after clicking install, I expected install to complete when I returned a few hours later. Murphy never fails though. And here I am looking at install error instead!
The error read:
TITLE: Microsoft SQL Server 2012 Setup
——————————The following error has occurred:
Error while enabling Windows feature : NetFx3, Error Code : -2146498298 , Please try enabling Windows feature : NetFx3 from Windows management tools and then run setup again. For more information on how to enable Windows features , see http://go.microsoft.com/fwlink/?linkid=227143
For help, click: http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft%20SQL%20Server&EvtSrc=setup.rll&EvtID=50000&ProdVer=11.0.2100.60&EvtType=0x681D636F%25401428%25401
So it wants me to install NetFx3. Should be easy. The requirement basically meant it needed .Net Framework 3.5. All I have to do is run the following from PowerShell:
Add-WindowsFeature NET-Framework-Core
Well, what do I know? It gave me an error too!
Add-WindowsFeature : The request to add or remove features on the specified server failed.
Installation of one or more roles, role services, or features failed.
The source files could not be downloaded.
Having seen this error, I knew what I had to do but let me illustrate. When you run the following at PowerShell prompt, you will notice that not only the “Installed” state is set to “False” indicating it’s not installed but “InstallState” states “Removed”:
Get-WindowsFeature Net-Framework-Core | FT name,install*
Name Installed InstallState
—- ——— ————
NET-Framework-Core False Removed
All it means is that the standard install of Windows Server 2012 does not even install binaries required to enable feature. If you want to install this feature, you will need side-by-side assembly source, usually the installation media. If you are curious about what side-by-side means, check out wiki article here.
The solution here sounds simple. Just run:
Add-WindowsFeature NET-Framework-Core -Source D:\sources\sxs
This assumes D is your CD drive which has Windows Server 2012 installation media. Now I should warn you, this won’t work if you have run Windows Update and applied patches after installing Windows Server 2012 and before trying to install SQL Server 2012! If you want answer to obvious “why?”, you should read my previous post explaining how to resolve Error: 0x800f0906 adding Windows features.
Don’t you love rabbit holes we deal with in IT?
Related
- Share:
3 Comments
Problem:
I was installing SQL Server 2012 on Windows Server 2012, and the installation failed with the following error.
Error while enabling Windows feature: NetFx3, Error Code: -2146498298, Please try enabling Windows feature: NetFx3 from Windows management tools and then run setup again. For more information on how to enable Windows features, see http://go.microsoft.com/fwlink/?linkid=227143
Reason:
Since I didn’t enable .NET Framework 3.5 before installing SQL Server 2012 it failed.
Solution:
Enable .NET Framework 3.5 and then install SQL Server 2012.
Below is the procedure to enable .NET Framework 3.5 in Windows Server 2012
Using GUI
1. Go to Server Manager -> Manage -> Add Roles and Features
2. Click Next
3. Click Next button, the wizard will shows the Installation Type section where we have to select the Role-based or feature-based installation option that it has used to configure this server by adding roles, role services and features.
4. Click Next button, it will show the Server Selection section. Click Select a server from the server pool and over the grid, select the server
5. Click Next
6. Select the .NET Framework 3.5 Feature Checkbox and click Next.
7. Warning message informs us that for one or more installation selections are missing source files on the destination server, so we have to specify an alternative source path. Click the Specify an alternative source patch
8. Provide the required source file path for the .Net Framework 3.5 which is in Windows Server 2012 ISO file. Extract or Mount this. and click OK
9. TheResults section will show the installation status. Installtion will complete.
Once .net framework 3.5 is enabled. We can install SQL Server 2012 on Windows Server 2012.
Using Command Line
dism /online /enable-feature /featurename:NetFx3 /source:d:\sources\sxs
Hope this was helpful !!!
Posted by Siddharth Verma on November 11, 2014
Okay… I am installing SQL Server 2012 on a Windows Server 2012 box, there shouldn’t be any problems. Everything is proceeding normally until I get this message:
Error while enabling Windows feature : NetFx3, Error Code : –2146498298 , Please try enabling Windows Feature : NetFx3 from Windows management tools and then run setup again.
No problem… I know how to install Windows Features; I start the Add roles and Features Wizard and go looking for NetFx3… it’s not there.
Problem.
It turns out that Windows Server 2012 does not include NetFx3 when it is installing. It doesn’t mean that it is gone, but it does have to be installed separately. Here’s what you do:
1) Insert your Windows Server 2012 media. As I was installing SQL Server in a Hyper-V VM I ejected the SQL media and attached my Windows Server 2012 ISO. I then checked to see what drive letter it was (D:).
2) I opened a Command Prompt with administrative credentials. From the Start Screen I typed CMD but instead of clicking on it or pressing ENTER I right-clicked, and at the bottom clicked on Run As Administrator.
3) From the Command Prompt I typed the following command:
dism /online /enable-feature /featurename:netfx3 /all /source:d:\sources\sxs
The Deployment Image Servicing and Management tool is one of the easiest ways to install features in Windows when the GUI fails you.
Note: Unfortunately, if you encounter this error you will have to restart your installation of SQL Server. That doesn’t mean you should cancel it out at this point… what I did was I left the error message on the screen while I resolved the NetFx3 issue, and then let it resume. The SQL Server installation succeeded, with several failures. I then went back and re-installed SQL on top of the old, with the features that I needed. It worked just fine for me, and it should for you.
Installing windows server and .NET Framework has always been a kids stuff till we realized that Server 2012 R2 release onwards, it is not available by default to be added from ‘Add Remove Windows Server Role Features’. Hence like all, I was stumped at installation of SQL server 2012 which requires Netfx3 and so will the problem appear for any application that depends on .Net Framework 3.5
Problem Description
I was installing SQL Server 2012 on a Windows Server 2012 R2 Standard virtual machine, and the installation was already in progress when I received the following error:
Error while enabling Windows feature: NetFx3, Error Code: -2146498298, Please try enabling
Windows feature: NetFx3 from Windows management tools and then run setup again. For more
information on how to enable Windows features, see http://go.microsoft.com/fwlink/?linkid=227143
Since I did not enable .NET Framework 3.5 before installing SQL Server 2012, setup tried to enable it but failed.
I then tried to enable .NET Framework 3.5 on Windows Server 2012 using the “Add Roles and Features Wizard” of Windows Serve 2012 and to my surprise it failed again.
Solution
On the new Server Manager of Windows Server 2012, we made a click on the Manage menu, and selected the option “Add Roles and Features”.
On the first page of Add Roles and Features Wizard, click on the Next button.
On the installation type page, we chose “Role-based or feature-based installation”.
On the Server Selection page of the wizard, we selected the actual server where we were installing SQL Server 2012
On the “Server Roles” page of the wizard, we just clicked on the Next button.
On the “Features” page of the Wizard, we clicked on the checkbox next to “.NET Framework 3.5 Features”, and then clicked on the Next button.
On the confirmation page, we just clicked on the Install button.
The installation using the “Add Roles and Features Wizard” failed with an error
Learn more on Cloud Infrastructure management
It turns out that Windows Server 2012 does not include NetFx3 when it is installed as .Net Framework 4.5 is provided by default. It doesn’t mean that it is gone, but it has to be installed separately.
Hence the fundamental problem here is that you need to tell windows where to find the NetFX installation files –simple.
- Insert the Windows installation media.
- Start the Add Roles and Features Wizard again.
- On the Select features page, select the .Net Framework 3.5 Features check box, and then click Next.
- On the Confirm installation selections page, click the Specify an alternate source path link.
- On the Specify Alternate Source Path page, type the path of the SxS folder as a local path or as a network share path. The screen shot for this step is listed below.
Click OK.
Click Install to finish the wizard
Conclusion
By default, on Windows Server 2012 (R2) the NetFx3 (.Net Framework 3.5) feature is not installed because it has already installed the .Net Framework 4.5; however some applications may require the NetFx3 feature and in this post we have seen how to make server 2012 work backward.