title: Web Site Administration Tool: Unable to connect to SQL Server database
body: <p>I'm using Visual Studio 2008, MS SQL server 2008 Express</p>
  
  <p>SQL server: zeroonea\SQL2008EXPRESS</p>
  
  <p>i'm create a webproject, made a dbtest.mdf in App_Data, made some tables, use aspnet_regsql to create membership tables in there, everything work fine.</p>
  
  <p>my connection string in web.config:</p>
  
  <pre><code>  &lt;connectionStrings&gt;
      &lt;add name="dbtestConnectionString" connectionString="Data Source=zeroonea\SQL2008EXPRESS;Initial Catalog=dbtest;Persist Security Info=True;User ID=***;Password=***"
        providerName="System.Data.SqlClient" /&gt;
    &lt;/connectionStrings&gt;
  </code></pre>
  
  <p>It still work when i run web application, the code can connect to sql server</p>
  
  <p>but when i run Web Site Administration Tool, click on Security tab, i throw a error</p>
  
  <pre><code>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.
  </code></pre>
  
  <p>Any suggestion?</p>