WIN2008+SQL2005 Construction Record

First, Preface

1 , about win2008 Introduction and Installation Precautions

①windows server R2 corresponds to the server version of Windows 7, with only 64 bits.

② before installing WIN2008, you need to format the C drive quickly, otherwise the system installation is unsuccessful

③ESD files are installed with the WinNTSetup3.6.1 version and must be installed in WinPE

④ If you are using a USB stick to boot into the WinPE installation *.esd file, after installation, select restart, reboot must unplug the USB drive (if the computer USB port and removable hard drive, please unplug it), or there will be a disk character confusion (CD PE ignore this)

2 , about SQL2005 Introduction and Installation Precautions

①win2008 installs all versions of SQL2005 and installs the Enterprise version in the first installation

② because WIN2008R2 only 64 bits, so this time must install 64-bit SQL2005

③ Installing IIS and asp.net2.0 prior to installing SQL2005

④ installation SQL2005 must select mixed authentication

⑤ After you install SQL2005, you must set the Allow remote connection to install SQL2005SP4

⑥ when all installations are complete, log on to the SQL2005 client for the first time and select the local server in the network server

Second, Pre-Setup Tools

1, u disk PE

2, Win2008 Mirror--"WINDOWS_SERVER_2008_R2_DATACENTER_2014.08.ESD" http://songyongzhi.blog.163.com/blog/static/ 195492371201472114619197/

3, image installation software--"WinNTSetup3.6.1 official version"

4, Sql2005 Enterprise Edition--"SQL2005 64-bit (X64) Enterprise Edition CD2", "SQL2005 64-bit (X64) Enterprise Edition CD2" http://beibei-168-cool.blog.163.com/blog/static/ 33816611201262052549635/

5, SQL2005SP4 Patch--"Sqlserver2005sp4-kb2463332-x64-chs.exe" http://download.microsoft.com/download/7/3/3/73326217- B926-4222-9863-9add5856e2ef/sqlserver2005sp4-kb2463332-x64-chs.exe

6, Virtual CD-ROM-"Virtualdrivemaster", the Rubik's Cube comes with

Third, win2008 Detailed installation Steps

Step 1, insert a USB drive with PE, restart the computer, enter the PE (according to the different models of the computer, self-set USB drive boot)

Step 2, copy win2008 image, mirror install software, SQL2005 Enterprise Edition, SQL2005SP4 patch, virtual optical drive to D drive

Step 3, format the C disk, method: Right-click "Local Disk C" select "Format (A)", in the pop-up format window select "Quick Format (Q)" and then click "Start", the pop-up Warning window, directly click "OK", then the C drive is formatted, the format will pop up "format complete" , click "OK" to complete the format of the C drive.

Step 4, open the image to install the software "WinNTSetup3.6.1 official version"

Step 5, click "Install", pop up a selection box, specific options such as:

Step 6, click "OK", pop up a confirmation box, select "OK", wait for the system to restart, after the system shuts down before restarting, unplug the USB flash drive,

Step 7, wait for the system to install, you can

The above steps complete the installation of WINDOWS2008R2

Four, SQL2005 Detailed installation Steps

1. Installing IIS and asp.net2.0

Step 1, click the menu in the lower left corner of the screen, select Administrative tools → Server Manager,

Step 2, in the popup "Server Manager" window select: Role → add role service;

Step 3, select some content in the red box after selecting: Next → install; Close Server Manager after installation is complete

2, the installation of SQL2005

Step 1, open the virtual optical drive Software "Virtualdrivemaster.exe" → load image →sql_2005_x64 Simplified Chinese Enterprise version CD1, turn off the virtual optical drive software, you can see the CD driver in your computer,

Step 2, double-click the cd driver → Double-click splash.hta→ Point "Server components, tools, Books Online, and examples (C)"

Step 3, if the compatibility query pops up, click "Run Program", pop up the license agreement, select accept the agreement, and click Next,

Step 4, install the prerequisites, select Install, select Next after installation is complete

Step 5, go to the SQL Installation Wizard interface, select Next, wait for system configuration check, if there is no error and warning, then select Next, if there is an error, cancel the installation, see if IIS configuration Error

Step 6, registration information to write, here by default, select Next

Step 7, select the components to install, here we select the first and last item, click "Advanced" to enter the Advanced configuration

Step 8, the entire functionality of the database services and instances installed on the local hard disk, you can choose the installation path, the default installation path, click Next

Step 9, instance, it is best not to choose the default instance, I choose named instance, the name can write their own, do not have spaces and Chinese; click Next

Step 10, select "Built-in System account" → Local system, start service SQL severs and SQL browser after installation

Step 11, here must choose Mixed Mode, or install SP4 patch will be error, select Enter password

Step 12, next two next

Step 13, choose the installation, wait for the installation end, if the compatibility of the query, then choose to run the program

Step 14, select Next after installation, then select Done. then CD2 also installed according to the above method

Step 15, the remote connection must be configured here, otherwise the subsequent SP4 cannot be installed successfully. In the Start menu, select SQL Sever surface Area configuration.

Step 16, select the "Perimeter configurator for services and connections"

Step 17, select "Remote Connection" → "Local Area Connection and remote connection" → "Use TCP, IP, and named pipes at the same time"

Step 18, Pop-up connection settings change the alert, select OK, and then stop the server at startup, the remote connection that you just set up takes effect.

Step 19, install SP4 patch, double-click SP4 Patch Installer

Step 20, click Next, select Accept agreement, then select Next

Step 21, select all the functions, choose Next, and then select two consecutive next

Step 22, you can see the process needs to be closed, then we go to the "service" to close the corresponding process, note that the installation program do not close!

Select Start menu → administrative tools → services → Select SQL severs→ Right-click to stop, and other processes to stop similar methods.

Step 23, the process needs to shut down, click Refresh, if the show process Name list is empty, select Next, and then select Install

Step 24, Next, two next

Step 25, automatically pop up the following settings box, select the left user, click the arrow to pull to the right, and then determine

WIN2008+SQL2005 Construction Record