Need some help with "The underlying provider failed on Open"
Can anybody help me on this issue?
I set the ASP.NET Web application as start project and used the default setting for database connection. When trying to browse the product, I get the following error "The underlying provider failed on Open." at the highlighted line below:
I am running this project using VS 2010 Professional on Windows Vista.
Steven Cai, Mar 12, 2011
Thanks to the author..Best article...Here is my discussion on MSSQL underlying provider fialed error! Please visit!
Venkat J, Jun 11, 2016
Here is a discussion on the same error: http://stackoverflow.com/questions/2475008/the-underlying-provider-failed-on-open
From reading this article I suspect it is related to a MSDTC setting on your machine.
I hope this gets you going.
Dan McMillan, Mar 12, 2011