If you already have a licensed version of Microsoft SQL Server in a supported version, follow the installation instructions noting the requirements outlined for installing an express edition below.If you don't have a licensed version of Microsoft SQL Server, you can download a free Express Edition.
Note that the Express Edition has database size limitations that generally make it inappropriate for production deployments. You can also use the Developer Edition, details may differ slightly from instructions in this topic.
During installation, configure Microsoft SQL Server to accept both Windows Authentication and SQL Server Authentication, ("Mixed Mode"), and specify a user name and password for the administrative account.To enable this feature on SQL Server Express, select the Custom installation option and proceed through the wizard accepting defaults until the Database Engine Configuration step.Keep track of the user name and password; LabKey Server uses it to authenticate to SQL Server. It must be provided in plaintext in labkey.xml or in your mssql.properties file later.
After you've installed SQL Server, you'll need to configure it to use TCP/IP. Follow these steps:
By default, SQL Server will choose a random port number each time it starts, but the JDBC driver expects SQL Server to be listening on port 1433.Click OK
You may want to set up a new login (in addition to the "sa" system administrator) for LabKey Server to use to connect to SQL Server: