I am using Visual Studio 2008, MS SQL Server 2008 Express
SQL Server: zeroonea \ SQL2008EXPRESS
I create a web project, made dbtest.mdf in App_Data, made some tables, used aspnet_regsql to create membership tables there, everything works fine.
my connection string in web.config:
<connectionStrings>
<add name="dbtestConnectionString" connectionString="Data Source=zeroonea\SQL2008EXPRESS;Initial Catalog=dbtest;Persist Security Info=True;User ID=***;Password=***"
providerName="System.Data.SqlClient" />
</connectionStrings>
It still works, when I run the web application, the code can connect to sql server
but when I run the website administration tool, go to the "Security" tab, I throw an 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.
Any suggestion?
source
share