Asp.net configuration management tool cannot connect to SQL Server database solution

In Visual Studio 2005, the following error occurs in website> Asp.net configuration> Security: "unable to connect to SQL Server database"

Solution:

Modify the machine. config file in C:/Windows/Microsoft. NET/framework/v2.0.50727/config, and modify the following lines in the file.

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

</Connectionstrings>

To:

<Add name = "localsqlserver" connectionstring = "Server = yourservername; database = aspnetdb; user id = sa; Password = your password; trusted_connection = false"/>

</Connectionstrings>

Here, the aspnetdb database comes with the system and can be changed to its own database name.

Some websites are described as follows and are not verified:

First, vs2005 saves the site information to the aspnetdb database of SQL express by default. If you use SQL Server official edition for storage, You need to configure it yourself. If the database has not been generated, use the command line tool aspnet_regsql.exe provided by Microsoft to generate the required database. The tool is located in the following path: C:/Windows/microsoft.net/framework/v/