The first time through Chapter 11 on the Dashboard, Aspnetdb was created automatically when using the test webparts application. I created the SQL Server based version as the Chapter explains and deleted the aspnetdb. All was good.

I went back to experiment a little more and removed the connection string to the SQL Server PTOPersonalization database. Now, I receive the following 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.

I created a new solution and UI project, which creates an empty App_Data -- figuring that I may have messed something up without knowing it -- the test web parts app generates the same error message. I have not changed any of the permissions on app_data, which is one of the listed items to check.

Has anyone seen this error and know its solution.
Thanks in advance for any help.

tom

I haven't seen this error before. Just a shot here, check your machine.config for the LocalSqlServer settting and make sure it is configured correctly.

<add name="LocalSqlServer" connectionString="data source=.\SQLEXPRESS;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|aspn etdb.mdf;User Instance=true" providerName="System.Data.SqlClient"/>