Hello,

I installed  dashcommerce 3.0.1 webready. I created a database and ran the install/install.aspx with success.

The database has aspnet and dashcommerce tables. I put the suggested connection string in the connectionString.config file which is now:

<connectionStrings>
  <clear />
  <add name="dashCommerce" connectionString="Server=VIRTUAL1_W2003\SQLEXPRESS;Initial Catalog=dashCommerce3;User Id=dc_admin;Password=password;" providerName="System.Data.SqlClient" />
</connectionStrings>

The connectionString.config file   has read (and execute) permissions for the Internetr guest user.

dc_admin is the owner of the dashCommerce3 database.

When requesting any page of the dashcommerce app. I get the following error:

[No relevant source lines]

[Exception: Please make sure that you setup the Database, and the Connection String in the connectionString.config file.]
   MettleSystems.dashCommerce.Store.SiteSettings.Load() in C:\mettlesystems\code\open source\dashCommerce\Core\SiteSettings.cs:148

Did you create a user dc_admin? You say you use the sa account but you should create an account named dc_admin like you provide in the connectionstring.

Hi, thanx for the response.

Yes I created a user that has a login and is owner of the dashCommerce3 database. The dc_admin user can connect to sql server management studio.  It is also the user I used in the install.aspx script.

Sorry for the confusion but in 2 earlier attempts I used the sa account to create databases (named dashCommerce  and dashCommerce2) and ran the install.apsx script. I then used the suggested connection string and got the same error ...... , both times .

Regards

Geert

Did you make the user dc_admin owner of the database?

 Edit: Didn't read you already did this ;)

 Can you try the connectionstring like this;

 <add name="dashCommerce" connectionString="Server=.\SQLEXPRESS;Initial Catalog=dashCommerce3;User Id=dc_admin;Password=password;" providerName="System.Data.SqlClient" />

I tried the connection string and I got the same error again ...

What I dont understand is that the install.aspx was able to connect to the database, and that the application that uses the same  database, user and password can not connect ......

What is the connection string the install.aspx page uses ? 

Regards

Geert