The error you get "Failed to generate a user instance..." doesn't look like a Sitefinity error. It may be caused because a previous install of SQL
Express has left files. Or the problem might be with your SQL
configuration. Please take a look at these links:
Also, do you have other web applications, which are using SQL Express and are working fine? Please, check the name of your SQLExpress instance (by default it is SQLEXPRESS)? If the instance is different, you need to modify the connection string:
1. Create the database.
| <add name="Sitefinity" connectionString="Data Source=.\SQLExpress;Integrated Security=True;User Instance=True;AttachDBFilename=|DataDirectory|Sitefinity.mdf" providerName="System.Data.SqlClient"/>
If the information above does not help, I would suggest you install Microsoft SQL Server Management Studio Express and do the following:
2. Set the account that runs the ASPNET working process (this is the NETWORK SERVICES account in IIS6.x) to your database as db_owner.
3. At the "Set Database" wizard step (when creating the project),