Built-in SQL Server update on Lync 2013 Frontend Server

29 Jan

When installing Lync 2013 Servers, as a part of the install, SQL Express 2012 RTM is installed.  In fact, there are several instances on Lync 2013 Front End Servers that get installed. The following lists what SQL Express instances get installed on what servers:

Standard Edition Front End Server

  • RTCLocal
  • LyncLocal
  • RTC

Enterprise Edition Front End Server

  • RTCLocal
  • LyncLocal

Now let’s say your Front End Servers are not installed yet.  There’s a great way to pre-install your SQL 2012 Express instances with SP1 instead of letting the Lync 2013 Deployment Wizard install SQL.  If you pre-install these SQL 2012 Express SP1 instances, Lync 2013 deployment wizard will see that the prerequisite of needing SQL 2012 is met, and will forgo the need for installing any SQL 2012 Express instances and will utilize the pre-installed SQL 2012 Express SP1 instances.  For more information on this, please see this TechNet blog post here.

Lync MVP, Pat Richard, has created an excellent script for all sorts of automated tool downloads/installs as well as prerequisite installs.  His script will take care of the SQL 2012 Express SP1 instances for you as well.  His script ishere.

Let’s say you didn’t know about Pat’s script or that you could preinstall SQL 2012 Express SP1 and you have already installed Lync 2013 Front End Servers using the SQL 2012 Express RTM code.  I will show you how to upgrade your SQL 2012 Express RTM instances to SQL 2012 Express SP1.

Installation of SQL 2012 Express SP1 x64

First, you will need to download the SQL 2012 Express SP1 x64 bits from here.

Once these bits are downloaded, open a Command Prompt and navigate to where these bits are downloaded.

On an Enterprise Edition Server, you will want to run the following two commands:

SQLEXPR_x64_ENU.exe /ACTION=Patch /INSTANCENAME=RTCLOCAL /QS /HIDECONSOLE /IAcceptSQLServerLicenseTerms
SQLEXPR_x64_ENU.exe /ACTION=Patch /INSTANCENAME=LYNCLOCAL /QS /HIDECONSOLE /IAcceptSQLServerLicenseTerms

On a Standard Edition Server, you will want to run the following three commands:

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

In my environment, I have initiated the update for the RTCLocal instance.  Below are a few screenshots of the update process in action.

 

Validating SP1 Installation

Once the install is complete, I’m sure you’ll want to validate the instance has been updated to SP1.  Fortunately, an excellent script for this is provided here.  Once downloaded onto your server, you will have to run the following command to allow this unsigned script to be run:

Set-ExecutionPolicy Unrestricted

Go ahead and execute the getInfo-SqlServer.ps1 script.

As expected, we see the RTCLOCAL instance has successfully been updated to SP1.

 

Thanks to Shudnow.net

 

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: