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

Source: Internet
Author: User
Tags sql server express

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

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.