Hi there,

my name is Dennis and I'm very new to DashCommerce and also a bit new to ASP.NET.

I downloaded the DashCommerce 3.0 file and installed it (converted erverything to the newest version, Visual Studio 08 pro).

When I want to launch the Application I get the following error-message:  

"Fehler bei der Anmeldung für den Benutzer 'IUSER'. Der Benutzer ist keiner vertrauenswürdigen SQL Server-Verbindung zugeordnet." 

Translated into English: "Error at the login for the user 'IUSER'. The user ist not assigned to a trustable SQL-Connection" (Sorry for my bad English :-) )

 Could anyone tell me, what I have to do to fix this? Cause I really don't know where the fault is.

 Thank you in advance!

Dennis

Ps: Let me attach the complete error message:

Line 96:       Validator.ValidateStringArgumentIsNotNullOrEmptyString(configurationSectionName, CONFIGURATION_SECTION_NAME);
Line 97: 
Line 98:       ConfigurationDatumCollection configurationDatumCollection = new ConfigurationDatumCollection().
Line 99:         Where(ConfigurationDatum.Columns.Name, configurationSectionName).
Line 100:        Load();

[SqlException (0x80131904): Fehler bei der Anmeldung für den Benutzer 'IUSER'. Der Benutzer ist keiner vertrauenswürdigen SQL Server-Verbindung zugeordnet.]
   System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) +435
   System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +82
   System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +105
   System.Data.SqlClient.SqlConnection.Open() +111
   SubSonic.SqlDataProvider.CreateConnection(String newConnectionString) +34
   SubSonic.SqlDataProvider.CreateConnection() +22
   SubSonic.AutomaticConnectionScope..ctor(DataProvider provider) +56
   SubSonic.SqlDataProvider.GetReader(QueryCommand qry) +40
   SubSonic.AbstractList`2.Load() +404
   MettleSystems.dashCommerce.Core.ConfigurationDatumController.FetchConfigurationByName(String configurationSectionName) in C:\Users\Dennis\Desktop\dashCommerce\Core\Controllers\ConfigurationDatumController.cs:98
   MettleSystems.dashCommerce.Core.Configuration.DatabaseConfigurationProvider.FetchConfigurationByName(String configurationSectionName) in C:\Users\Dennis\Desktop\dashCommerce\Core\Configuration\DatabaseConfigurationProvider.cs:121
   MettleSystems.dashCommerce.Store.SiteSettings.Load() in C:\Users\Dennis\Desktop\dashCommerce\Core\SiteSettings.cs:136
   MettleSystems.dashCommerce.Store.Web.SiteMasterPage.get_SiteSettings() in C:\Users\Dennis\Desktop\dashCommerce\Store\Web\SiteMasterPage.cs:96
   MettleSystems.dashCommerce.Web._default.OnInit(EventArgs e) in C:\Users\Dennis\Desktop\dashCommerce\Web\default.aspx.cs:103
   System.Web.UI.Control.InitRecursive(Control namingContainer) +321
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +834

From the install
Before proceeding, please copy and paste the connection string below into the connectionString.config file. Simply replace the line that has:

<add name="dashCommerce" connectionString="SOMETEXT" providerName="System.Data.SqlClient" />

with the following:
<add name="dashCommerce" connectionString="Your Connection String" providerName="System.Data.SqlClient" />

Hi, 

I'm currently suffering the same problem. The bottom two links did not solve the problem completely... but they were helpful in correcting some assumption I made went installing SQLEXPRESS Advance.

 Now the problem are: was the database installed? And do I need to configure a login and password for IUSER?

Setting the login is up to you, You just have to make sure that you have the right connection string

Check this for SQLServer 2005 connection string 

yitzcock is correct. I have just got Dash working (having got the same error) by replacing the uncommented connectioning string in web\connectionString.config file with the settings given in the installation. There are 4 connection strings, the first 3 are commented out so you must replace the 4th one with the connection string shown. Load web\connectionString.config file
into notepad and cut and paste.

 Hi all,

Hope that you all be fine.

I'have done these steps to successfully run the dashcommerce in VS2008.

->Installed all the prereq.

->run .sln file

->build it but stii not findind the database for the dash commerce. Does it come with the dash commerce or with the MS SQL  Server 2005 with advance servises. 

I am  having this error

Line 96:       Validator.ValidateStringArgumentIsNotNullOrEmptyString(configurationSectionName, CONFIGURATION_SECTION_NAME);
Line 97: 
Line 98:       ConfigurationDatumCollection configurationDatumCollection = new ConfigurationDatumCollection().
Line 99:         Where(ConfigurationDatum.Columns.Name, configurationSectionName).
Line 100:        Load();

Where do i llokm for it to set the connection string. I am facing this error from one month.

Thanks. 

Hey there,

Having been through this I thought I'd jump in... re: your question

"Does it come with the dash commerce or with the MS SQL  Server 2005 with advance servises. "

Personally I had to;
1. install SQL Server 2005 (with adv. services) and mixed authentication.
2. Then create the database you want to use (making sure you check the full text index checkbox)
3. Set the start page to the ~/install/default.aspx page
4. Run the solution in VS 2005
5. Follow the steps
6. Ensure that the app.config files in the other sub-projects ALSO are edited to the proper connection strings
7. Enjoy!!!

Hope this helps,

bibber