Server Configuration

Install Microsoft SQL Server:

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.

Configure During Installation:

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.

Configure TCP/IP:

After you've installed SQL Server, you'll need to configure it to use TCP/IP. Follow these steps:

  1. Launch the SQL Server Configuration Manager.
  2. Under the SQL Server Network Configuration node, select Protocols for (servername).
  3. In the right pane, right-click on TCP/IP and choose Enable.
  4. Right-click on TCP/IP and choose Properties.
  5. Switch to the IP Addresses tab.
  6. Scroll down to the IPAll section, clear the value next to TCP Dynamic Ports and set the value for TCP Port to 1433 and click OK.
  7. 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

  8. Restart the service by selecting the SQL Server Services node in the left pane, selecting SQL Server (edition name) in the right pane, and choosing Restart from the Action menu (or use the Restart button on the toolbar).

Set Up a Login

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:

  1. Run SQL Server Management Studio.
  2. Connect to the database.
  3. Under Security > Logins, add a new login, using SQL Server authentication.
  4. Enter the user name and password.
  5. Use this password to configure the data source below.

Was this article helpful?

Yes No

Thanks so much for your feedback!

Have more questions? Submit a request

Standing by to help you succeed.

The point of sale and platform built with your business’ success in mind