2.1 Installation Error : Database not found

I am getting error:
•Setup failed: System.Exception: Database does not exist or you don't have permissions to connect to it at Nop.Web.Controllers.InstallController.Index(InstallModel model) in C:\Users\******\Documents\My Web Sites\NopCommerce2.1\Presentation\Nop.Web\Controllers\InstallController.cs:line 344



Database information

--------------------------------------------------------------------------------

Use built-in data storage (SQL Server Compact).

Use an existing SQL Server (or SQL Express) database. [Recommended]
--------------------------------------------------------------------------------
Enter SQL connection values Enter raw connection string (advanced)


SQL Server name: LENOVO-Y560\SQL2005_001
(I have different sql server instances running from 2k 25 and 28)


Database name:  nopcommerce21

Use SQL Server account Use integrated Windows authentication


SQL Username:  sa

SQL Password: ********

I know this works as I use this to log into the database directly from VS for other apps.

Is there a problem with my SQL server name I use.

I also tried using just SQL2005_001 and it cannot find it.

Can someone please tell me what is the problem here?

TIA.

dpchan wrote:
Error is self-descriptive. Ensure that database already exists and you have required permissions to connect to it

Tried your idea and created the nopcommerce21 separate,  but it still does not work.  

I know I have access as when I use the DB parms in VS2010 it connects to the server.

Is there a way to run the install of the database separately for the other part of the install.  Will the nopcommerce still come up if I install the databases separately.  Anyone know how to do this?  Which SQL packages I have to run for nopcommerce 2.1 and also what are the settings to files and reg do I have to make to install this app.  Don't understand when the 1.9 and the 1.8 I installed earlier worked.  Do I have to uninstall the prev versions?

There is an alternative to connect to the system "Enter raw connection string (advanced)"  

Does anyone have an example of the connect string is it similar to "Provider=SQLOLEDB;Data Source=LENOVO-Y560\SQL2005_001;User ID=sa;Password=********;Initial Catalog=nopcommerce21"

This string is not correct and is in error also.



Am I barking up the wrong tree?  Do I have to grant permission to some SQLAGENT or service that nopcommerce 2.1 is using.



TIA

Thanks for the help from anyone.

When I changed the system to use Windows authentication instead of sql authentication, the install worked.  So for 2.1 if anyone has the same problem as me I guess there may be something specific that was not set in using the SQL authentication method.

I've had problems logging into SQL Server at times.  If your VS2010 project has no problem making a connection, look at its properties to see what it is what SQL Server expects you to be giving it to logon.