Failed to generate a user instance of SQL Server

Question

Hi. I been trying to get my Visual Studio 2008 to run my Web Application on IIS7 on my Windows 7 machine but I just can't get it to work. I'm using the SQLEXPRESS I been following this Tutorial, but I get the following error message.

"Failed to generate a user instance of SQL Server due to failure in retrieving the user's local application data path. Please make sure the user has a local user profile on the computer. The connection will be closed."

my connectionString seem to be ok

<add name="testConnectionString" connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|test.mdf;Integrated Security=True;User Instance=True" providerName="System.Data.SqlClient" />

The site run with out database connection.

Any ideas and thoughts about this?

Thanks guys

Answer 1

Make sure the instance name is called "SQLEXPRESS" exactly.

Make sure the "test.mdf" file exists in the "App_Data" folder.

When you are adding the DB using Server Explorer, use "Test Connection" first.