dashCommerce

i have a problem in STEP 3 of installation process... after i pasted the connection strng in the configuration file. the error is as follows... A critical error has occurred: An error occurred while attempting to initialize a System.Data.SqlClient.SqlConnection object. The value that was provided for the connection string may be wrong, or it may contain an invalid syntax. Parameter name: connectionString my connection string file is...

generally speaking that error means what it says i.e there is somethig wrong in your connection string in connectionstring.config Maybe copy and paste it to us so we can have a look, make you didn't leave a ; off the end. Thanks, Matthew

this is my file...

<connectionStrings>
  <clear/>
  <add name="dashCommerce" connectionString="Server=2003-test;Initial Catalog=dash3;User Id=sa;Password=xxxxxxx;" providerName="System.Data.SqlClient" />
</connectionStrings>

You need to get rid of Server=

example

<add name="dashCommerce" connectionString="Data Source=MATTHEW\SQLEXPRESS;Initial Catalog=dashtest6;Persist Security Info=True;User ID=test;Password=test" providerName="System.Data.SqlClient"/>

That is still not working... my connection now string is....

 <add name="dashCommerce" connectionString="Data Source=2003-test;Initial Catalog=dash4;Persist Security Info=True;User ID=sa;Password=xxxxxxxx;" providerName="System.Data.SqlClient" />

Is the machine local or remote?  Can you connet to database using those credentials?  Is the error message still the same?

You should probably also remove Persist Security Info="true" - but that won't fix your issue.

 <add name="dashCommerce" connectionString="Data Source=2003-test;Initial Catalog=dash4;User ID=sa;Password=xxxxxxxx;" providerName="System.Data.SqlClient" />

Thanks,
Matthew

 

 

This is local machine, but i have same error whe in connect from remote computer. If i use the Sql Express console i can connect to the server with theese credentials. I have ever the same error also without "Persist Security Info=true"