Preinstalling SQL Express 2012 SP1 for Lync Server 2013

Continuing the previous blog post (http://blogs.technet.com/b/lyncativity/archive/2012/06/14/preinstalling-sql-express-2008-r2-for-lync-server-2010-rtclocal-instance.aspx), the same method can also be applied for Lync Server 2013.

Lync Server 2013 RTM installation package comes with SQL Express 2012 RTM, thus preinstalling SQL Express 2012 SP1 will become a handy solution to avoid the need to patch the server after Lync Server 2013 installation.

The change with Lync Server 2013 however is that the Front End server now consists of two SQL Express 2012 instances, RTCLOCAL and LYNCLOCAL.

RTCLOCAL instance contains the rtc, rtcdyn, and xds databases, whilst LYNCLOCAL instance contains the lyss database.

 

The SQL Express 2012 SP1 x64 version can be downloaded from:

http://download.microsoft.com/download/5/2/9/529FEF7B-2EFB-439E-A2D1-A1533227CD69/SQLEXPR_x64_ENU.exe

 

And the following one liner can be used to preinstall SQL Express 2012 SP1 RTCLOCAL instance:

SQLEXPR_x64_ENU.EXE /QUIET /IACCEPTSQLSERVERLICENSETERMS /HIDECONSOLE /ACTION=Install
/FEATURES=SQLEngine,Tools /INSTANCENAME=RTCLOCAL /TCPENABLED=1 /SQLSVCACCOUNT="NT AUTHORITY\NetworkService"
/SQLSYSADMINACCOUNTS="Builtin\Administrators" /BROWSERSVCSTARTUPTYPE="Automatic"
/AGTSVCACCOUNT="NT AUTHORITY\NetworkService" /SQLSVCSTARTUPTYPE="Automatic"

 

The following one liner can be used to preinstall SQL Express 2012 SP1 LYNCLOCAL instance:

SQLEXPR_x64_ENU.EXE /QUIET /IACCEPTSQLSERVERLICENSETERMS /HIDECONSOLE /ACTION=Install
/FEATURES=SQLEngine,Tools /INSTANCENAME=LYNCLOCAL /TCPENABLED=1 /SQLSVCACCOUNT="NT AUTHORITY\NetworkService"
/SQLSYSADMINACCOUNTS="Builtin\Administrators" /BROWSERSVCSTARTUPTYPE="Automatic"
/AGTSVCACCOUNT="NT AUTHORITY\NetworkService" /SQLSVCSTARTUPTYPE="Automatic"

NOTE: If you happen to choose to install SQL Express 2012 SP1 using the GUI instead, please note that TCP/IP is not enabled by default and will cause Lync database installation to fail. This can be corrected easily by enabling TCP/IP on both RTCLOCAL and LYNCLOCAL instances using SQL Server Configuration Manager.