Processing of ASP. NET Website management tools being unable to connect to the SQL Server database in ASP. net2.0

The error message is as follows:

A problem may occur in the selected data storage zone because the server name or creden are invalid or the permissions are insufficient. It may also be caused by the absence of the role manager function. Click the following button.

To redirect to the page where you can select a new data storage area.

The following message may help you diagnose the problem: You cannot connect to the SQL Server database.

The solution is as follows:
1. Create a database, such as HMX;

2. the ASP. net SQL Server registration tool is used to create an SQL Server for ASP. NET.ProgramThe Microsoft SQL Server database used, or used to add or remove options to an existing database. The aspnet_regsql.exe file is located in the [drive:] \ windows \ microsoft. Net \ framework \ versionnumber folder on the Web server. Run a boot command: Configure SQL server for the Application Service, and select "HMX" for the database ".

3. open IIS in management tools, create a virtual directory logintest, right-click it, and then left-click menu items [properties] and [Asp.. Net tab and edit configuration. In the connection string manager of the General tab, click Edit, change [connection parameters] to the database connection string that can be connected to the database HMX, as shown in figure
"Data Source =.; initialcatalog = HMX; persist Security info = true; user id = sa; Password = sa ".

In this way, you can use the ASP. NET Website management tool to manage users and permission roles.