The Security tab in WAT cannot connect to the database. solution:

WatYesWeb site administration toolInVs-> Project-> Asp. Net Configuration.

In the section "design forms-based authentication" (P408) in <programming ASP. NET 3.5>, follow the steps to find that the WAT Security tab displays"Unable to connect to SQL Server database".

Solution

1.Vs-> Tools-> connect to database-> Select Server Name and database-> click "advanced"-> copy the connection string below

2. Use notepad to open% WINDOWS % \ windows \ Microsoft. NET \ framework \ v2.0.50727 \ configUnderMachine. config

3. Find the following content and replace it with the copied connection string.ConnectionstringAnd then save.

<Add name = "localsqlserver" connectionstring = ". \ sqlexpress; Integrated Security = sspi; attachdbfilename = | datadirectory | aspnetdb. MDF; user instance = true "providername =" system. data. sqlclient "/>

Then open the Security tab in WAT again and the configuration is successful: