You ever get the error: The ‘DbProviderFactories’ section can only appear once per file.
When trying to do something like create a new table with SQL Server Management Studio ?
I don’t know why, but one (or more) of the many maching.config files on your computer does, indeed, have TWO DbProviderFactories sections in it. TWO of my machine.config files were like that, but the one causing this error was the one located here:
I recommend doing a system wide search for all machine.config files that have <DbProviderFactories/> in them. Open each one to see if it additionally has another DbProviderFactories section and delete the blank one. Deleting it from the file mentioned above solved this problem for me.
NOTE! You’ll have to open your text editor as Administrator or you’ll be forbidden from saving changes to the file(s)!