Upgrade SQL Server 2012Express SP1 for Lync 2013 front-end

When you deploy Lync 2013, the Setup program installs SQL Server Express RTM on the front-end server and creates several local instances.

I also found it when I upgraded Skype for business Server 2015. It was a mistake that was reported.

650) this.width=650; "Width=" 382 "height=" 403 "title=" QQ20150608002205 "style=" border-top-width:0px; border-right-width:0px;border-bottom-width:0px, "alt=" QQ20150608002205 "src=" http://s3.51cto.com/wyfs02/M00/6E/ 23/wkiom1v0efnxxnc9aafkltb-yn4421.jpg "border=" 0 "/>

Most of the workarounds are to install the entire SQL Server 2012 SP1, or use Windows Update to search for and install updates. So the problem comes, the entire installation of the 2012 sp1,3.6g, using Windows Update Search update, 1.1G SP2. While downloading a SQL Server Express with SP1 installation package is also 130M, its time cost is not proportional.

650) this.width=650; "Width=" 517 "height=" 245 "title=" QQ20150608003330 "style=" border-top-width:0px; border-right-width:0px;border-bottom-width:0px, "alt=" QQ20150608003330 "src=" http://s3.51cto.com/wyfs02/M01/6E/ 1f/wkiol1v0efvtl6ygaade08tzujg539.jpg "border=" 0 "/>

The first step is to identify which instances of the Lync2013 front end are installed when you install SQL Server Express.

Standard Edition front end:

• Rtclocal

• Lynclocal

• Rtc

Enterprise Edition front End

• Rtclocal

• Lynclocal

Next, download the installation package for SQL Sserver Express with SP1: https://www.microsoft.com/en-us/download/details.aspx?id=35579, note here that Even if you install the Chinese version of Lync 2013, you also want to download the English version of the installation package, because it comes with the English version ... No, there will be a diagram verification.

Then administrator mode opens the command line,

Knock Command

Sqlexpr_x64_enu.exe/action=path/instancename=rtclocal/iacceptsqlserverlicenseterms

Start the decompression after the carriage return and prepare to install.

650) this.width=650; "width=" 656 "height=" 532 "title=" QQ20150608004155 "style=" border-top-width:0px; border-right-width:0px;border-bottom-width:0px, "alt=" QQ20150608004155 "src=" http://s3.51cto.com/wyfs02/M01/6E/ 23/wkiom1v0efqg7dqmaaf73l7zycs939.jpg "border=" 0 "/>

Note the position of the red box in the figure, the language that represents this instance is English,

650) this.width=650; "Width=" 632 "height=" 519 "title=" QQ20150608004347 "style=" border-top-width:0px; border-right-width:0px;border-bottom-width:0px, "alt=" QQ20150608004347 "src=" http://s3.51cto.com/wyfs02/M02/6E/ 1f/wkiol1v0efziydjyaahkmj3xc9u189.jpg "border=" 0 "/>

If you download a Chinese version and try to upgrade, it will prompt you not to find the product you need to upgrade.

650) this.width=650; "Width=" 607 "height=" 458 "title=" QQ20150608004621 "style=" border-top-width:0px; border-right-width:0px;border-bottom-width:0px, "alt=" QQ20150608004621 "src=" http://s3.51cto.com/wyfs02/M02/6E/ 23/wkiom1v0efrjrppbaag6offxdre228.jpg "border=" 0 "/>

, Setup will incrementally upgrade 2 instances.

650) this.width=650; "width=" 612 "height=" 488 "title=" QQ20150608004726 "style=" border-top-width:0px; border-right-width:0px;border-bottom-width:0px, "alt=" QQ20150608004726 "src=" http://s3.51cto.com/wyfs02/M00/6E/ 1f/wkiol1v0efzjwc5daafa6dfr7y4395.jpg "border=" 0 "/>

650) this.width=650; "Width=" 664 "height=" 547 "title=" QQ20150608004745 "style=" border-top-width:0px; border-right-width:0px;border-bottom-width:0px, "alt=" QQ20150608004745 "src=" http://s3.51cto.com/wyfs02/M00/6E/ 23/wkiom1v0efusbe1oaagu8glyn7s741.jpg "border=" 0 "/>

After the upgrade is complete, we use a script to verify the results of the upgrade, where the script comes from, which can get information about all of the currently installed SQL instances.

Not before the upgrade

650) this.width=650; "Width=" 646 "height=" 326 "title=" QQ20150608005248 "style=" border-top-width:0px; border-right-width:0px;border-bottom-width:0px, "alt=" QQ20150608005248 "src=" http://s3.51cto.com/wyfs02/M01/6E/ 1f/wkiol1v0ef3awn4saage0ffmkoe581.jpg "border=" 0 "/>

After the upgrade is complete

650) this.width=650; "Width=" 645 "height=" 377 "title=" QQ20150608005310 "style=" border-top-width:0px; border-right-width:0px;border-bottom-width:0px, "alt=" QQ20150608005310 "src=" http://s3.51cto.com/wyfs02/M01/6E/ 23/wkiom1v0efvbi2vlaagaitrqgwg144.jpg "border=" 0 "/>

Of course, the upgrade process can also be simplified to one per instance upgrade, the command is as follows

Sqlexpr_x64_enu.exe/action=patch/instancename=rtclocal/qs/hideconsole/iacceptsqlserverlicenseterms

Sqlexpr_x64_enu.exe/action=patch/instancename=lynclocal/qs/hideconsole/iacceptsqlserverlicenseterms

If it is the standard version: the following command

Sqlexpr_x64_enu.exe/action=patch/instancename=rtclocal/qs/hideconsole/iacceptsqlserverlicenseterms

Sqlexpr_x64_enu.exe/action=patch/instancename=lynclocal/qs/hideconsole/iacceptsqlserverlicenseterms

Sqlexpr_x64_enu.exe/action=patch/instancename=rtc/qs/hideconsole/iacceptsqlserverlicenseterms

Using the above command is equivalent to a silent upgrade, but it is possible that you upgraded the first instance and the second instance upgrade does not take effect. You might want to restart it and then execute the second one.

This article is from the "Castamere Rainy season" blog, be sure to keep this source http://sodaxu.blog.51cto.com/8850288/1659521

Upgrade SQL Server 2012Express SP1 for Lync 2013 front-end