Share via

Preinstalling SQL Express 2012 SP1 for Lync Server 2013

  • Article

Continuing the previous blog post (https://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:

https://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.

Comments

  • Anonymous
    January 01, 2003
    The comment has been removed

  • Anonymous
    January 01, 2003
    For a Standard Server you also need to run the command a third time to install the /INSTANCENAME=RTC.

  • Anonymous
    December 06, 2012
    Is it just me, or are both of those install commands the same? And missing some double quotes?

  • Anonymous
    December 06, 2012
    Ah - if you copy and paste, it's there. Just not visible on this page due to formatting.

  • Anonymous
    April 09, 2014
    The comment has been removed

  • Anonymous
    July 05, 2014
    thanks very much

  • Anonymous
    July 09, 2014
    SQL Express 2012 SP2 is out now, and can be downloaded from http://www.microsoft.com/en-us/download/details.aspx?id=43351. I'll have it added to my prereq script athttp://www.ehloworld.com/1697 soon.

  • Anonymous
    March 31, 2015
    Bo, that worked for me, thanks!!!!!

  • Anonymous
    May 05, 2015
    I think reinstall is not necessary. Have a look at the SQL management studio and the SQL's data directory.You will possibly not see the xds DB in the management stufio, but find a xds.mdf there that can be re-attached.

    Re-attach the DB and retry the setup step.