Click here to Skip to main content
15,747,911 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:

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 :
    <add name="LocalSqlServer" connectionString="Data Source=MYMACHINENAME; Initial Catalog=aspnetdb;Integrated Security=True"
      providerName="System.Data.SqlClient"  />

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....


Updated 10-May-11 7:44am

Thanks for the attempt thatraj , I tried this solutions and it didnt helped me ....

My Solution :

What I did finally is uninstalling SQLSERVER R2 Express and VS2010 IDE (unfortunately :( , it took me a while to even consider to uninstall the VS2010)
Reboot the machine ....

1) I installed VS2010 Ultimate (with the sql express come with it) .

2) Checked if the Admin tool at ASP web project works , and it worked !!! : )

3) upgrading the sqlexpress to SQL server 2008 r2 express

4)Afterwards installing SQL server 2008 r2 express , during the installation I kept using the same instace (SQLEXPRESS ) and not creating new one , (I figure that was the problem ) .

5) checked again the admin tool , FINALLY ..... WORKS , and in one instance , SQLEXPRESS ---> checked at my services of the machine !
Share this answer

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900