Windows Server R2 Install SQL Server 2012

Windows Server - R2 Installing SQL SERVER

First, Environment Preparation

1. Server Preparation

server name IP:192.168.2.218/24, operating system : Span style= "font-family: ' The song body '; font-size:14px;" >windows server  2008

server name ip: 192.168.2.65/24, operating system (X64) : windows server  2008  r2 , memory at least 4g above

Note: Test the environment, turn off all firewalls and Windows Automatic Updates, download cn_sql_server_2012_enterprise_edition_x86 _x64_dvd_813295 Enterprise Edition, key : SQL Server corporate Core Edition : Fh666-y346v-7xfq3-v69jm-rhw28

2. Install the necessary plugins

   w65 server Installation sql SERVER The operating system needs to be installed server R2 SP1 patch (Windows Server R2 Service Pack 1 patch suggested download, note x64/x86, This example uses installation time is about 30 minutes, the server needs to be restarted :

Patch

W65 Server Installation Framew 3.5 SP1 components,Windows Server R2 Feature Pack directly installed

Second, Start Installation Deployment

1. run SQL SERVER installation package setup.exe, select "Install"-"New SQL Server Standalone installation or add features to an existing installation, click OK

2. Check the dependent components, notice if there is an error, and exclude dependencies according to the error

3. Enter the corresponding version of the key and click "Next"

4. SQL SERVER Network automatically update the relevant patches, click "Next"

5. Set roles, feature installation, test convenience here, select all, default storage share path, next

6. Configuration instance, default instance / storage path

7. Specify the service account and collation, where the default settings are selected. If you need to customize the configuration after the installation is complete, click "Next"

8. on The Database Engine configuration page, specify the server configuration authentication as the default "Mixed authentication Mode", "Add current User" as the administrator of SQL Server , and set the password to 12345678 . You can also specify the default database file storage path for that instance in the Data Catalog tab. Click "Next".

9. Similar configurations are made on the analysisServices Configuration page and in the Database Engine configuration page. Click "Next".

10. on theReporting Services Configuration page, select the default settings and click Next.

11. "Add current User" as the administrator of the distributed replay controller. Click "Next".

12. specify the appropriate controller and database directory for the distributed replay client. Here, with the default configuration, the controller name is not filled in. Click "Next".

13. The other is the default next, and finally click Install, installation time is about five minutes, need to restart the server!

This article is from the "10,000-hour Law" blog, be sure to keep this source http://daisywei.blog.51cto.com/7837970/1878988

Windows Server R2 Install SQL Server 2012