Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
OldGrantonian
Starting Member
1 Post |
 Posted - 2012-03-18 : 04:42:35
|
| I have MS SQL Server 2005. I'm not a techie. I'm trying an MS tutorial in MS Visual Web Developer Express.When I try to build the solution, I get the error:"Failed to generate a user instance of SQL Server due to a failure in starting the process for the user instance. The connection will be closed."My database is in my local machine, in a folder with the rest of the solution files, exactly as downloaded.Here are my connection strings:<connectionStrings> <add name="ApplicationServices" connectionString="data source=.\SQLEXPRESS;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|aspnetdb.mdf;User Instance=true" providerName="System.Data.SqlClient" /> <add name="ContactEntities" connectionString="metadata=res://*/Models.ContactModel.csdl|res://*/Models.ContactModel.ssdl|res://*/Models.ContactModel.msl;provider=System.Data.SqlClient;provider connection string="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\Contact.mdf;Integrated Security=True;User Instance=True;MultipleActiveResultSets=True"" providerName="System.Data.EntityClient" /> </connectionStrings>I would be grateful for any assistance. |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2012-03-19 : 02:48:39
|
| Could you publish the relevant stack trace?Jack Vamvas--------------------http://www.sqlserver-dba.com |
 |
|
|
|
|
|
Failed to generate user instance due to failure