ASP. NET role member Management Database Configuration

In member role management, sqlserver database is used for member qualification management by default. You must configure the database first!

In the new project, we can see that

After clicking this Asp.net configuration, we can see the following:

 

 

Click "security" to go to the next page.

 

In this step, many people cannot see the step-by-step Security Configuration option using security settings. The database cannot be connected.

In this case, some of the reasons are that the database is not properly configured during database installation, resulting in unavailability. You can try to separate a database file, if you can use the separated MDF file. It is not a number

Database Configuration problems. At this time, we can first pass the command in vsto prompt aspnet_regsql.exe to create a new aspnetdb database file, separate it, and add it to the app_data file in the solution.

Under the folder, an error will be found after execution, where the errorCodeIf there is such code: sp_configure 'user instances enabled'

At this time, you can open the database, create a new query, enter: sp_configure 'user instances enabled', 1, and then run reconfigure.

In this way, the above problems can be solved!

 

Role management is no stranger to everyone, so I will not talk about role security management here, just to share with you all possible problems! Hope you can solve the problem!