ASP Web Site Administration Tool, error :There is a problem with your .......

See more:

ASP.NET

SQL-Server

Hi

I'm trying to fix this issue for two days , I reinstalled the sql2008 R2 express for 5 TIMES !!!!

I dont understand why this ASP tool doesn't work's on my machine ...

the error :

There is a problem with your selected data store. This can be caused by an invalid server name or credentials, or by insufficient permission. It can also be caused by the role manager feature not being enabled. Click the button below to be redirected to a page where you can choose a new data store.
The following message may help in diagnosing the problem: Unable to connect to SQL Server database.

I must say that I can make it works with that web.config :

<connectionStrings>
    <clear/>
    <add name="LocalSqlServer" connectionString="Data Source=MYMACHINENAME; Initial Catalog=aspnetdb;Integrated Security=True"
      providerName="System.Data.SqlClient"  />
</connectionStrings>

Problem is that this connection strings allow me to save the users and roles only at the sql database , I want it to be saved at the App_data Folder inside the project .
I know that i don't need to use connection string for that , I just checked my sql server.

Please help....

thanks

idan