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

Source: Internet
Author: User

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.

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.