When using WebPart and login control, the database is not on the problem.
The main errors are: 1 ---- This version of SQL Server does not support user instance login flags. This connection will turn off 2 ------ SQL Server Express database existing 3 -------- Unable to connect to the SQL Server database requires us to modify ASP.NET 2.0 default localsqlserver settings
When we use the site management tools on the control, there are four topics in this page (home page, security, application, provider).
We will continue to click the [Security] theme, there will be an error message that cannot be connected to the SQL Server database. In the lower right corner, there is a [Select Data Storage Area] button in the lower right corner, which means that we choose to choose the data store.
We click [Select Data Storage Area] to continue setting, the new page will prompt "The application is currently configured to use the provider: aspnetsqlprovider", there are two link options below, the first is "Select the same for all site management data. Provider ", the second is" Select a different provider (advanced) for each function, and we click on the second link to continue setting. Thereafter, the page displays the "Membership Provider" and the "Role Provider" option for us for us, and there is a [Test] link behind each option. We do test operations for AspNetsqlmembershipProvider and AspNetSqlroleProvider options, in general, tests will not succeed, and we recommend that we run an ASPNET_REGSQL command line utility creation and configure database
1. Create a database as ZYH with SQL Server's Enterprise Manager.
2. Create a database with ASPNET_REGSQL (C: /Windows/Microsoft.net/framework/v2.0.50.50215/ASPNET_REGSQL.exe). In addition to "ASPNETDB" except "ASPNETDB" in the Create Wizard, the remaining steps use the default settings. This creates a complete database with the user table and the storage process in SQL Server 2000.
3. Open IIS in the management tool, find the virtual directory newtest, right-click, then left click on the menu item [Properties], [ASP.NET] tab, [Edit Configuration] button, [Connection] String Manager], click Name [localsqlserver], click [Edit] button, modify the [Connection parameters] to the corresponding database connection string that can connect to database ZYH, such as "Data Source = .; Initial Catalog = aspnetdb; Persist security info = true; user ID = sa; password = 12345, then, it is docked with the [OK] button, and finally goes to the IIS management tool interface.
4. Finally returning the website management tool web page, click on the security topic, and "Use the Security Setting Wizard to configure security in class." Link and other related links.
At this point, the problem is solved.
