An unhandled exception (‘Unhandled Error in Silverlight Application Code:4004

The above error could be caused by one of the follow reasons.

 

The database does not support user instance. For example, you are using Domain Service Class.

 

An unhandled exception (‘Unhandled Error in Silverlight Application Code:4004

The video shows the original connection string is like:

 

<addname=“AdventureWorks_DataEntities“connectionString=“metadata=res://*/AdventureWorks.csdl|res://*/AdventureWorks.ssdl|res://*/AdventureWorks.msl;provider=System.Data.SqlClient;provider connection string=&quot;Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\AdventureWorks_Data.mdf;Integrated Security=True;User Instance=True;MultipleActiveResultSets=True&quot;“providerName=“System.Data.EntityClient“ />

 

and the changed to:

 

<addname=“AdventureWorks_DataEntities“connectionString=“metadata=res://*/AdventureWorks.csdl|res://*/AdventureWorks.ssdl|res://*/AdventureWorks.msl;provider=System.Data.SqlClient;provider connection string=&quot;Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\AdventureWorks_Data.mdf;Integrated Security=True;MultipleActiveResultSets=True&quot;“providerName=“System.Data.EntityClient“ />

 

which without the User Instance=True.

 

Resources:

Connecting to SQL Server Express User Instances

Failed to generate a user instance of SQL Server due to a failure in starting the process for the user instance

 

 

About these ads