The following BKM (Best Known Method) is what I use for my local development environments:
1. Create a local database without requiring SQL Server.
Documentation for the utility SqlLocalDB Utility is available here:
http://msdn.microsoft.com/en-us/library/hh212961.aspx Open a command prompt using Administrator privileges.
Microsoft Windows [Version 6.1.7601]
Copyright (c) 2009 Microsoft Corporation. All rights reserved.
C:\Windows\system32>cd C:\workspace\nopCommerce_2.70_Source
C:\workspace\nopCommerce_2.70_Source>"C:\Program Files\Microsoft SQL Server\110\Tools\Binn\SqlLocalDB.exe" create LocalDBnopCommercev1
LocalDB instance "LocalDBnopCommercev1" created with version 11.0.
C:\workspace\nopCommerce_2.70_Source>"C:\Program Files\Microsoft SQL Server\110\Tools\Binn\SqlLocalDB.exe" start LocalDBnopCommercev1
LocalDB instance "LocalDBnopCommercev1" started.
C:\workspace\nopCommerce_2.70_Source>"C:\Program Files\Microsoft SQL Server\110\Tools\Binn\SqlLocalDB.exe" info LocalDBnopCommercev1
Name: LocalDBnopCommercev1
Version: 11.0.2100.60
Shared name:
Owner: xyz\Mark
Auto-create: No
State: Running
Last start time: 11/30/2012 2:37:50 PM
Instance pipe name: np:\\.\pipe\LOCALDB#329ED08A\tsql\query
C:\workspace\nopCommerce_2.70_Source>
2. Once the database exists, launch nopCommerce.sln from Visual Studio 2012.
First time use, be sure to "Rebuild Solution" to workaround a stale binary issue.
3. Installation wizard BKM settings for a local development environment:
.-----------------------------------------------
Store Information
Admin user email: <email address>
Admin user password: **********
Confirm the password: **********
Database information
.-----------------------------------------------
o Use built-in data storage (SQL Server Compact)
x Use SQL Server (or SQL Express) data base [Recommended]
.-----------------------------------------------
Create database if it doesn’t exist x
x Enter SQL connection value: o Enter raw connection string (advanced)
Sql Server name: (localdb)\v11.0
Database name: (localdb)\LocalDBnopCommerce
O Use SQL Server account x Use integrated Windows authentication
Specify custom SQL Server collation: O
Hope this helps first time nopCommerce developers setup their local development environment.