Solution for the website Configuration tool to establish a connection to the database

Recently usedSqlserver2005developerWhen the database was involved in website development, it suddenly found that the website configuration management tool was unavailable.Sql2005expressVersion. Then we collected data online and finally solved the problem.

The solution is as follows:

1. Open VS Command Prompt, enter Aspnet_regsql Use the default database (Aspnetdb) .

2. Open VS , In sequence: Tools --> Option --> Database tools --> Data Connection --> SQL Server Instance name ( Empty by default ) , Change to your server name.

3. Or VS , Tools --> Connect to database --> Server Name ( Select the server ) , You can select as required Windows Or SQL Server Authentication, and then the database selects Aspnetdb . Test OK Then, copy the statement in advanced Data Source = server; initial catalog = aspnetdb;

4. In DoS Window input Inetmgr Command to open Iis5.1 . Note: IIS Be sure Visual studio2008 Install it before installation. Otherwise, it cannot be used.

5.OpenIISDefault website -- Properties-----Asp.net -----Edit global configuration

6.Under the General tabLocal ServerEdit the configuration.Data Source =./sqlexpress.Change to your computer name.

7.Enable role management on the Authentication Mode tab. Select. Authentication Mode SelectionWindows.