SQL Server 2008 upgrade to SQL Server 2012

SQL Server 2008 upgrade to SQL Server 2012

1.SQL Server current version

Microsoft SQL Server Management Studio (10.0.6000.29) --sql Server

Microsoft analysis Services Client Tools (10.0.6000.29)

Microsoft data Access Components (MDAC) (6.1.7601.17514)

Microsoft MSXML (3.0 6.0)

Microsoft Internet Explorer (8.0.7601.17514)

Microsoft. NET Framework (2.0.50727.5420)

Operating System (6.1.7601)

operating system:Windows Server R2

2, requires operating system upgrade Windows Server R2 Service Pack 1 Patch pack (x86/x64 , windows6.1-kb976932-x64), the upgrade is expected to take up to a minute, and requires a restart of the server, boot and the new load configuration - minutes or so

3. The. NET Framework must be upgraded from the original 3.5 SP1 to more than 4.0 (20 minutes ), need to restart the computer

4, open cn_sql_server_2012_enterprise_edition_x86_x64_dvd_813295 installation Setup.exe, Select "Install Upgrade Advisor" and need to install "Microsoft? SQL Server? Transact-SQL ScriptDom " components (x86/x64)

650) this.width=650; "Src=" Http://s5.51cto.com/wyfs02/M02/8A/FA/wKioL1hAzhGADm7hAADen0zITu4356.jpg-wh_500x0-wm_3 -wmp_4-s_2997235124.jpg "title=" 1.jpg "alt=" Wkiol1hazhgadm7haaden0zitu4356.jpg-wh_50 "/>

5. Select " install "-" from SQL Server 2005, ,R2 " upgrade to

650) this.width=650; "Src=" Http://s1.51cto.com/wyfs02/M02/8A/FA/wKioL1hAzh7CPGu5AACWB9YGIZQ715.jpg-wh_500x0-wm_3 -wmp_4-s_894989739.jpg "title=" 2.jpg "alt=" Wkiol1hazh7cpgu5aacwb9ygizq715.jpg-wh_50 "/>

6 , input SN Secret key , the default key is only the Trial

SQL Server Enterprise Core Edition :fh666-y346v-7xfq3-v69jm-rhw28

650) this.width=650; "Src=" Http://s2.51cto.com/wyfs02/M00/8A/FA/wKioL1hAzlCx2EtpAACUIUI1L7A001.jpg-wh_500x0-wm_3 -wmp_4-s_105528654.jpg "title=" 3.jpg "alt=" Wkiol1hazlcx2etpaacuiui1l7a001.jpg-wh_50 "/>

7, select the instance to upgrade, if there are no multiple instances, usually refers to the default instance

650) this.width=650; "Src=" Http://s4.51cto.com/wyfs02/M00/8A/FE/wKiom1hAzjmTM1jJAACWOBA4zgA190.jpg-wh_500x0-wm_3 -wmp_4-s_2082457798.jpg "title=" 4.jpg "alt=" Wkiom1hazjmtm1jjaacwoba4zga190.jpg-wh_50 "/>

8, full-text upgrade, select "Import"

650) this.width=650; "Src=" Http://s3.51cto.com/wyfs02/M00/8A/FA/wKioL1hAzl2DKsDqAAC1trJdb98301.jpg-wh_500x0-wm_3 -wmp_4-s_3581678069.jpg "title=" 5.jpg "alt=" Wkiol1hazl2dksdqaac1trjdb98301.jpg-wh_50 "/>

9. When installing verification information, 2 failures are indicated:

1),rs_validdatabaseversion: Check whether the version of the report server database is available by Microsoft SQL server Service Pack 1 /c8> is used by the report server. Status: Failed

Process Guidance: The report server database is not in a supported compatibility level or a connection cannot be established. Use Reporting Services Configuration Manager to verify the report server configuration, and use SQL Server Administration Tools to verify the compatibility level.

2),rs_validdsn Check whether the report server has a valid DSN. Status: Failed

Process guidelines: The report server configuration is incomplete or invalid. Use Reporting Services Configuration Manager to verify your report server configuration.

cause: Due to the installation SQL , there is no option to install the native Reporting database

Workaround:

  # Check that Reporting Services is turned on: View the SQL Server Reporting Services service;

  # If it is turned on, open Reporting Services Reporting Services Configuration Manager, connect and click Database to view the SQL Server name in the current report server database. Try to connect to the database specified by the database name by this name. If not, you can create a new reporting database.

650) this.width=650; "Src=" Http://s5.51cto.com/wyfs02/M02/8A/FE/wKiom1hAzmuAAo_MAACrQ5QUt2I758.png-wh_500x0-wm_3 -wmp_4-s_3714342569.png "title=" 6.png "alt=" Wkiom1hazmuaao_maacrq5qut2i758.png-wh_50 "/>

after re-run the installation verification pass, start the upgrade ( time about 1 hours )

Microsoft SQL Server Management Studio 11.0.2100.60

Microsoft analysis Services Client Tools 11.0.2100.60

Microsoft data Access Components (MDAC) 6.1.7601.17514

Microsoft MSXML 3.0 6.0

Microsoft Internet Explorer 8.0.7601.17514

Microsoft. NET Framework 4.0.30319.237

Operating System 6.1.7601

Attention:

1,SQL2008Upgrade toSQL2012 SP1, who knows -The Enterprise Edition also hasLicensedlimit, byCALregistered (that is, the type of verification code that we search online), there will beCPULimit number of threads, cannot exceed +(Details here). But our official server is4*12=48a logicalCPU, Beyond the8That would lead to a previous cross-NUMAproblem.

2. Determine if there is a trial version

SELECT @ @version

Microsoft SQL Server 2012-11.0.2100.60 (X64)

Feb 10 2012 19:39:15

Copyright (c) Microsoft Corporation

Enterprise edition:core-based Licensing (64-bit) on Windows NT 6.1 <X64> (Build 7601:service Pack 1) (Hypervisor)

Note: core-based Licensing (64-bit) Core Edition

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

SQL Server 2008 upgrade to SQL Server 2012