MS SQL


How to connect MSSQL via NOP 1.90?
Use the following type of connection string in your nopcommerce config file -
<connectionStrings>
<add name="NopSqlConnection" connectionString="Data Source=sql2k802.discountasp.net;Initial Catalog=DBNAME;User ID=DBUSERID;Password=DBUSERPW;Integrated Security=FALSE;Persist Security Info=False;Connect Timeout=120" />
</connectionStrings>

You would specify the db name, db username and password when creating them through the control panel.