При попытке установить 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
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.
Hello friends,
It has been a while since I last wrote a blog post, but I have received several questions regarding a specific error: “Error while enabling Windows feature: NetFx3.” Today, I will address this error and provide you with the solution.
Firstly, let’s understand what this error is and why it appears with different names in different scenarios. The error occurs when installing SQL Server or other applications that require the .NET Framework 3.5. The problem arises because Windows Server 2012 does not include NetFx3 by default. However, it can be installed separately.
Now, let’s move on to resolving the issue. There are two ways to do this:
Using the GUI
- Insert the Windows 2012 CD or attach the ISO file if using a virtual environment like VMware or Hyper-V.
- Check the drive letter assigned to the CD or ISO file (e.g., D:).
- Open Server Manager and go to “Manage” and then “Add roles and features.”
- Select “.NET Framework 3.5 features” and click “Next.”
- Enter the alternate source path, which in our case is “D:\Sources\SxS”. This is where the necessary bits are located.
- Click “OK” and proceed with the installation.
Using the Command Prompt
If you prefer using the command prompt, follow these steps:
- Open the command prompt.
- Type the following command:
dism /online /enable-feature /featurename:netfx3 /all /source:d:\sources\sxs
Once you have completed either of these processes, the error should no longer occur.
If you found this post helpful, please like our Facebook page: https://www.facebook.com/Ashishsharepointblog.
Feel free to rate and provide feedback if you found this post useful.
Hope this helps!
Best regards,
Ashi
Here are the detailed steps do enable it. Open Server Manager for Windows 2012.
…
WORKAROUND/SOLUTION
- Choose Server in the next screen.
- Hit next on “Server Roles” screen. No selection needed.
- On “Features” screen, choose . Net Framework 3.5 Features as shown below. Click on Next option.
How do I enable netfx3 on Windows?
In the Control Panel >> Programs, select Turn Windows features on or off, and the user will see Windows feature window. Enable this feature by click on . NET Framework 3.5 (include . NET 2.0 and 3.0) select it and click OK.
Does SQL Server require .NET framework?
SQL Server 2019 requires the .
NET Framework, but you may have to install it on older Windows Server versions.
How do I enable .NET framework on Windows Server?
On the Select installation type screen, select Role-based or feature-based installation. Select the target server. On the Select features screen, check the box next to . Net Framework 3.5 Features.
Is .NET framework installed by default?
NET Framework is installed by default. The plus sign icon ➕ denotes OS versions on which .
How do I install NetFx3 on Windows 10?
Steps
- Open a command prompt with administrator user rights (Run as Administrator).
- To install .NET Framework 3.5 from installation media located on the D: drive, use the following command: cmd Copy. DISM /Online /Enable-Feature /FeatureName:NetFx3 /All /LimitAccess /Source:d:\sources\sxs.
How do I enable NetFx3 on Windows Server 2019?
Content
- This procedure can also be used to install .
- The recommended method is using the command line as follows:
- Execute the following command as an administrator on your Windows computer:
- DISM /Online /Enable-Feature /FeatureName:NetFx3 /All.
What is the prerequisite of SQL Server installation?
Minimum Requirements to Run SQL Server 2012 Express and SQL Server Management Studio
- Windows 7, Windows Server 2008 R2, Windows Server 2008 Service Pack 2 or Windows Vista (SP2 or later).
- Internet Explorer 7 or higher.
- For 32-bit systems, 1 GHz Intel or compatible processor (2 GHz or higher recommended).
Can SQL Server 2012 run on Windows 7?
Installing SQL Server 2012 is supported only on Windows 7 SP1 or Windows Server 2008 R2 SP1. However, Setup does not block installing SQL Server 2012 on Windows 7 or Windows Server 2008 R2.
How do I tell what version of .NET Framework is installed on Windows Server 2012?
The version of .NET Framework (4.5 and later) installed on a machine is listed in the registry at HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\NET Framework Setup\NDP\v4\Full.
How do I check my .NET framework version on Windows Server 2012?
Run the Registry Editor ( regedit.exe ) and go to registry key HKLM\SOFTWARE\Microsoft\NET Framework Setup\NDP. This reg key contains information about all versions of . NET on the computer.
How do I fix Dot Net Framework error in Windows 10?
If Microsoft .NET Framework 4.5 (or later) is on the list, repair it:
- In the Programs and Features window, select Microsoft . NET Framework 4.5 (or later). Then select Uninstall/Change.
- Select Repair and then select Next.
- Follow the on-screen instructions.
- When the repair finishes, restart your computer.
Why is Net Framework 4.5 not installing?
This issue may occur due to corrupt Windows update files or settings. This may also happen due to corrupt . Net framework components. I would suggest you to run Windows update troubleshooter and check.
How do I fix NET Framework installation error?
Check . NET Framework 4.5 (or later)
- In the Programs and Features window, select Microsoft . NET Framework 4.5 (or later). Then select Uninstall/Change.
- Select Repair and then select Next.
- Follow the on-screen instructions.
- When the repair finishes, restart your computer.
Why NET framework is not installing?
Go to Control Panel > Programs > Turn Windows features on or off, verify if . NET Framework 3.5 checkbox is selected and then proceed with the software installation. If the error persits, we will have to force the installation with the Windows command prompt (CMD).
What are the steps to install SQL Server?
- Click on the file and install the studio.
- Once the installation is completed, search for Microsoft SQL Server Management Studio.
- The SQL Server Management Studio is launched, and you will find a pop up, Connect to Server.
- Enter the password which you had entered before with Login as sa and click on Connect.
How do I start SQL Server 2012?
To open SQL Server 2012 Management Studio Express click on the lower left hand side “Start” windows button then open folder Microsoft SQL Server 2012 then select SQL Server Management Studio. This will open up SQL Server 2012 Management Studio Express.
Can you install SQL Server 2012 on Windows Server 2019?
SQL Server 2012 std is not supported in Windows Server 2019. The official supported last version is Windows Server 2014, and in Windows Server 2016 it was not officially supported but still you would be able to install.
What are the system requirements for SQL Server 2012?
System requirements
- 32-bit systems.
- Computer with Intel or compatible 1GHz or faster processor (2 GHz or faster is recommended.)
- 64-bit systems.
- 1.4 GHz or faster processor.
- Minimum of 512 MB of RAM (2 GB or more is recommended.)
- 2.2 GB of available hard disk space.
How do I know if .NET is installed on Windows Server 2012?
Windows Server 2012/2012 R2
- Browse to C:\Windows\Microsoft.NET\Framework and look for a V4. xxxxx folder (xxxxx = the service release)
- If any V4. 0 folder exists in the directory, . NET 4.0 is installed.
How do I install .NET Framework 4.8 on Windows Server?
Install Microsoft Dot Net (.Net) Framework 4.8
- Double-click the Microsoft .Net framework installer.
- If the operating system requests you to confirm, click Yes.
- Select I agree to the license terms and conditions, and then click Install.
- Wait for the installer to complete, and then click Close.
How do I repair .NET Framework?
Method 1. Repair NET Framework from Control Panel.
- Navigate to Control Panel > Programs and Features.
- Select the .
- At the next screen, choose Repair .
- When the repair is complete, click Finish. .
- Restart your PC and then check if the Net Framework-related problem has been fixed.
Why is .NET Framework not installing?
How do I fix a framework error?
Windows 10, 8.1, and 8
- Close all open programs.
- Open the Windows Start menu.
- Type “Control Panel” into the search and open Control Panel.
- Go to Programs and Features.
- Select Uninstall a Program. Don’t worry, you aren’t uninstalling anything.
- Select Turn Windows features on or off.
- Find . NET Framework on the list.
Why is .NET framework not installing?
To totally unlock this section you need to Log-in
Login
Installing NetFx3 feature on Windows Server 2012
SQL Server 2012 setup might fails with below error when you do not have .Net Framework 3.5 features.
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
——————————
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:
To totally unlock this section you need to Log-in
Login