Adding connection to SQL Server : Can't select a database name

Question

I can't select or enter a database name in Microsoft Visual Studio 2012:

In the Server Explorer tab, I add a connection
Select Microsoft SQL Server as a data source
I'm able to detect my server name (SQL Server 2008) and the connection test is working (I tested in SQL Server Management Studio, and I can access the database)
I can't select any database in the dropbox. Even if I write up the name, it's not working.

Any ideas?

Unable to find the requested .net framework data provider. it may not be installed. — billybob
– billybob, Commented Jul 29, 2013 at 19:08

billybob · Accepted Answer · 2013-07-30 21:03:31Z

1

In the folder C:\Windows\Microsoft.NET\Framework64\v4.0.30319\Config (should see for other versions as well), open the file machine.config and then see if the tag was duplicated. If it's duplicated then, delete the duplicated tag in all machine.config of all .net versions.

answered Jul 30, 2013 at 21:03

billybob

3,0186 gold badges38 silver badges57 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

IngoB Over a year ago

Which "tag" do you mean?

billybob Over a year ago

If I recall, it was the DbProviderFactories tag

Collectives™ on Stack Overflow

Adding connection to SQL Server : Can't select a database name

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related