SQL Server Build Site instance

Environment: SQLSERVER2008R2 One, Web server one
Software support: IIS, Dynamic Web site source code
Topology:

Steps:
Database section:
1. Start-click SQL Server Management Studio

2. Enter the SQL Server name or IP address, login name, password-click the linked database

3. Create a new database

4. Enter the new database name-OK

Web Server section:
1. First copy the downloaded source code to a disk

2. Install the Web service. Click Server Manager-roles-add roles in the lower left corner

3. Click the server Role Web server (IIS)

4, seduce the application development and sub-options-and then start the installation

5. Click Function-Add function

6. Tick the. net-and select Add Required Features-then start installing. Net.

7. Click Start-Management tool-iis

8. Expand node-site-Right click to select Add Site

9. Enter Site name-click Select Physical Path-select upload-Click OK

10. Right click on hishop website-Manage website-start

11. Click Application Pool-Right click hishop-Basic Settings

12. Change the "integration" of the managed piping mode here to "classic" mode

13. Edit Permissions

14. Choose Security-Add everyone-and give Full Control permission

15, return to hishop-Click to browse the webpage

16, browse the page can see Hishop interface

17. Configure Background information

18. Click Finish to access the website

19. Website interface

20. Back up the database

21. Delete Database

22, delete the time tick off the existing connection

23. Restore the Database

24. Locate the backup file-and then determine the recovery

SQL Server Build Site instance