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:
Enterprise Edition front End
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