SQL SERVER encountered unable to find the requested. Net Framework Data Provider. It May is not installed. (System.Data)

Today's installed SQL Server EXPRESS for client programs

When the installation is complete, open the login SQL Server everything OK

When you view the table definition, the view structure, pop up the content

Unable to find the requested. Net Framework Data Provider. It May is not installed. (System.Data)

Preliminary decision is a. NET Framework version issue

Upgrading the. NET Framework 4.0

Prompt the system is already using the current or updated version

Download the. NET Framework 4.5

The problem remains

Online inquiry after found to download MSSQL Compack

So download MSSQL Compack 4.0

After the completion of the chapter, restart SSMs, see the view, the prompt changed, as follows

The ' dbproviderfactories ' section can be only appear once per config file. (System.Configuration)

View the. NET Framework configuration file, discover the. NET Framework 4.0 folder in the Configure folder in the Machine.config file

<DbProviderFactories> tags, after the </DbProviderFactories> end of the <dbproviderfactories>, after removing the duplicate information, restart SSMs, Normal use

SQL SERVER encountered unable to find the requested. Net Framework Data Provider. It May is not installed. (System.Data)