In some deployment of Lync servers, we are required to install the Lync components on Non-system drives, different from the C: drive.
Part of those components is the local SQL Express being installed as the local replica of the XDS database in Lync deployment.
Unfortunately, during the installation of Lync, there is no easy way of changing the SQL installation to be installed on a separate drive and that requires manual installation prior to the Lync setup.
as mention in the following blog article, In order to so, we can add different parameters to the SQL Express setup:
/INSTANCENAME=<RTCLOCAL, LYNCLOCAL or RTC>
/INSTALLSHAREDDIR=”D:Program FilesMicrosoft SQL Server”
/INSTALLSHAREDWOWDIR=”D:Program Files (x86)Microsoft SQL Server”
/QUIET (Delete if you want to click through the installation wizard)
Eventually, the command line to install should look like the following:
SQLEXPR_x64.exe /QUIET /IACCEPTSQLSERVERLICENSETERMS /HIDECONSOLE
/ACTION=Install /FEATURES=SQLEngine,Tools /INSTANCENAME=RTCLOCAL
/TCPENABLED=1 /SQLSVCACCOUNT=”NT AUTHORITYNetworkService” /SQLSYSADMINACCOUNTS=”BuiltinAdministrators”
/BROWSERSVCSTARTUPTYPE=”Automatic” /AGTSVCACCOUNT=”NT AUTHORITYNetworkService” /SQLSVCSTARTUPTYPE=Automatic
/INSTANCEDIR=”D:CSDATA” /INSTALLSHAREDDIR=”D:Program FilesMicrosoft SQL Server” /INSTALLSHAREDWOWDIR=”D:Program Files (x86)Microsoft SQL Server”
An easier alternative is by using the following script by Pat Richard which contains an outstanding list of Prerequisites and Tools for Microsoft Lync Server 2013.
Running the script with the following command line will allow installing the SQL on a non-system drive:
Set-Cs2013Features.ps1 -sqlpath <span class="str">"d:sqlexpress"</span>