How to Install SQL Express to a Non-System Drive

March 7, 2013

in Lync, Microsoft, Script

By default Lync installs SQL Express and the local databases onto the system drive during a Lync install.  This is typically ok if only one drive exists on the server however, what if you have another drive which is dedicated to applications, a non-system drive.  Lync will automatically move the Lync local databases to a non-system drive but SQL Express itself stays on the system drive.  If there are three or more drives installed there is a way to control even further where the Lync local databases are stored.

Jens has a nice write up on installing the local databases to a separate drive that you can read here.

This still doesn’t solve the problem of installing SQL Express to a non-system drive.  If you try to install SQL Express manually there is no guarantee that the install willpass the pre-requisite checks.  After much trial and error along with a gentle parsing of the log files I was able to extrapolate the following command to install SQL Express to a non-system drive.  Modify the following parameters to fit your build.

Parameters

  • /INSTANCENAME=<RTCLOCAL, LYNCLOCAL or RTC>
  • /INSTANCEDIR=”C:\CSDATA”
  • /INSTALLSHAREDDIR=”C:\Program Files\Microsoft SQL Server”
  • /INSTALLSHAREDWOWDIR=”C:\Program Files (x86)\Microsoft SQL Server”
  • /QUIET (Delete if you want to click through the installation wizard)

Script

SQLEXPR_x64.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 /INSTANCEDIR="C:\CSDATA" /INSTALLSHAREDDIR="C:\Program Files\Microsoft SQL Server" /INSTALLSHAREDWOWDIR="C:\Program Files (x86)\Microsoft SQL Server"

Reference: Installing SQL Express from the command line

1,608 views
1 Star2 Stars3 Stars4 Stars5 Stars (2 votes, average: 5.00 out of 5)
Loading ... Loading ...

{ 2 comments… read them below or add one }

Mike April 20, 2013 at 2:35 pm

now THIS is what I have been looking for! “Security” has been all over me because I can’t get all the data to install anywhere but the System drive. I managed to get most of SQL-E on the D, but CsData folder was killing me. Now if I can only find a way to do the same for the SQL Server 2005 Backward Compatibility install, I’d be able to tell “Security” to leave me alone for a while (SMILE)

THANKS!!!
Mike

Reply

Trapper June 13, 2013 at 4:34 pm

X2 what Mike said! Why is this so hard to find online anywhere else. Thanks a ton.

Reply

Leave a Comment