Configure aspnetsqlmembershipprovider (aspnetsqlprovider) in ASP. NET 2.0)

In vs. NET 2005 beta 2

It is found that the default database in is aspnetaccessprovider. You can select aspnetsqlmembershipprovider in the provider tab, but the test fails. If an error is displayed, the database cannot be connected. You can find the information in msdn and find that the configuration link information is on the machine. set in config. By default, the aspnetaccessprovider database of SQL Server is aspnetdb, but this database is not found in SQL Server 2005, so the database cannot be connected. After you add your own aspnetdb database, goTest in web site administration tool. This time, it passes and links. I'm glad that when I enter the Security tab for setting, an error occurs, prompting that the stored procedure cannot be found.
In the previous versions of CTPThe web site administration tool adds SQL links and databases, but this version does not. Whether or not SQL 2005 Express is not installed when VS 2005 is installed (because SQL 2005 Pro has been installed before.. Net FW and vs2005 ).

Continue to find information in msdn and find the following text:
Ing the SQL Server Provider

If you want to useAspnetsqlproviderTo store application feature data in a SQL Server database, you must first configure SQL Server by creating the appropriate database. ASP. NET nodes des a command-line utility namedAspnet_regsql.exeThat performs this task for you.

The aspnet_regsql.exe executable is located in the c: \ windows \ Microsoft. NET \ framework \VersionnumberFolder on your Web server.Aspnet_regsql.exeCommand is used to both create the SQL Server database and to add or remove options from an existing database.

You can runAspnet_regsql.exeExecutable without any command-line arguments to run a wizard that will walk you through specifying connection information for SQL Server and installing or removing the database elements for all of the supported features. you can also run the aspnet_regsql.exe executable as a command-line utility to configure database elements for individual features.

To runAspnet_regsql.exeWizard, runAspnet_regsql.exeExecutable without any command-line arguments as shown in the following example.

C: \ windows \ Microsoft. NET \ framework \ versionnumber \ aspnet_regsql.exe

To view help for additional options available with the aspnet_regsql.exe utility, use/?Option.

Start aspnet_regsql.exe later

Note: The following table, view, and stored procedure will be automatically added to the database:

Since then,Aspnetsqlprovider configured
Can connect to the database and test normally

I don't know whether it's my dumb or beta version. It's really troublesome to set it up, so write it down to avoid wasting time with friends who encounter similar problems.

In addition, how to configure the aspnetsqlmembershipprovider link of sqlexpress is to configure the MDF database in a directory like access. I have not configured the MDF database successfully. If the configuration is successful, please advise
My link statement is as follows: Data Source =. \ sqlexpress; attachdbfilename = ~ \ App_data \ aspnetdb. MDF; Integrated Security = true

There is no problem connecting to the database, but aspnetsqlmembershipprovider cannot be implemented