"The underlying provider failed on Open" Error during nopCommerce Installation

Hello

I am trying to install nopCommerce_3.10 in visual studio ultimate 2012. As a back end SQL Server Compact was used. When i tried to install it, i got error like "Setup failed: The underlying provider failed on Open".

What is the solution?

I faced a similar issue during the installation of 3.20. Fixed it by choosing the SQL credentials option rather than the Windows authentication option on the installation page, and using the sa as my user of choice. Not saying that Windows authentication does not work, but this is just a clue that most probably it is a permission issue. Check your IIS Application identity, and make sure it has the sufficient privileges on the database level.

I just had this problem when running a new install using the source code version of 3.30 and VS 2012 running in Debug mode. The exception was thrown from line 39 of source file CreateTablesIfNotExists.cs for SQL user 'sa' which has sufficient rights :). When I set then next statement to run as line 39 again (causing it to re-run the query) it succeeded and created the database with sample data as expected. A bit strange, smells like a timing issue, but it worked for me...

If it helps:
Windows 8.1
VS 2012
SQL Server 2012 Dev Edition.

Here is link to resolve this issue.