.NET Framework 3.5 Error in SQL Server Installation

How Enable .NET Framework 3.5 Error on Window 7

If we try to install SQL Server in Window 7 we will receive the following error:

Note: The same steps work for Windows 8 and Windows 10.

1. Click Start -> Control Panel
   
2. Click Programs
   
3. Click Turn Windows features on or off
   
4. Click the checkbox next to Microsoft .NET Framework 3.5.1
   
5. You will see the checkbox become filled
   
6. Click OK
   
7. Wait for Complete the operation. If it asks you to connect to Windows Update to download required files, click Yes.

.NET Framework 3.5 Error in SQL Server Installation on Window Server 2008R2, and Window Server 2012R2:

The .net Framework 3.5 SP1 is a prerequisite for SQL Server 2008R2. If it is not already installed on Server, we get error message:

Solution: There are two method to solve this problem let’s discuss one by one:

Method 1: Using Server Manager Interface

1.       Go to Server manager

2.       Click Add role and Features

3.       Select Features Interface, expand .NET Framework 3.5 Features

4.       Select and hit next

Method 2: Using PowerShell

1.       Click the Start button

2.       Go to All Programs and Select Accessories

3.       Expand windows PowerShell and right click Windows PowerShell and select Run as Administrator.

4.       At the power shell command prompt, type the following commands, and then press Enter after each command:

·         Import-Module ServerManager

·         Add-WindowsFeature as-net-framework

 

Unable to attach sql database (Microsoft SQL Server, Error: 5120)

Error Message: While attaching the mdf & ldf file in sql it is showing error

Unable to open the physical file "C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\C.mdf". Operating system error 5: "5(Access is denied.)". (Microsoft SQL Server, Error: 5120)

Solution: This problem may be occurred due to few reasons Which showing here.

Reason 1: You didn’t open your SSMS through Administrator right

Log off your Computer\Close SQL Management studio.

And Run your SQL Management studio with Administrator 

And try to Attach or Restore it. 

It should work!!

Reason 2: You are not using Window Authentication account

Run SQL Server Management as Administrator

Login SQL Server with Windows Authenticate

Attach your DB Files

Reason 3: Don’t have the permission on folder

GO to the folder where you have stored mdf file.

Select file-> Right click ->click on.

Give full permissions to file for logged in user Security.