Normally, SQL Server 2014 Express is automatically installed with memoQ server. However, this will not be enough for you in two cases:
•You expect a large amount of data. SQL Server Express can handle databases of up to 10 gigabytes. If you need more, you need to purchase and install SQL Server Standard or Enterprise. Or:
•You have a SQL Server, but on a different computer: If your organization has a separate database server for this, SQL Server will be installed on that server. You need to create a database and grant permissions on that server.
Trial or Evaluation editions are not supported: Using such editions is known to cause problems.
You do not need to download and install SQL Server if you do not need a large database (more than 10 gigabytes), and the database can be stored on the same computer where memoQ server runs. In this case, ask the Deployment tool to install the copy of SQL Server 2014 Express that comes with the setup package.
If you need to install a SQL Server instance before you install memoQ server, you can use SQL Server 2008 R2, 2012, 2014, or 2016. The free Express edition is sufficient unless you plan to set up large online projects, regularly exceeding the size of 50,000-100,000 segments.
Download: The recommended setup package of SQL Server 2014 Express is available here (at the time of writing): https://www.microsoft.com/en-US/download/details.aspx?id=42299
Because each version and edition of SQL Server has a more or less different setup program, this page cannot offer a detailed walkthrough. However, it is recommended that you pay attention to the following when installing SQL Server:
(1)Do not make changes to the service accounts that the SQL Server installer offers, unless your corporate infrastructure requires you to do so.
(2)Use Windows-integrated authentication, otherwise memoQ server will be unable to communicate to SQL Server.
(3)Install SQL Server Management Studio along with SQL Server (found in Management Tools). Note that different versions of SQL Server use different versions of SQL Server Management Studio. When you visit the download page, and click Download, you will be able to choose to download SQL Server or the Management Studio. The Management Studio is a separate download.
(4)It is highly recommended that you install a named SQL Server instance called MemoQServer: this is what the memoQ 8.1 server setup program will look for by default. Do not use a Default instance.
Separate SQL Server? Do not forget the permissions.
If you install SQL Server separately, grant specific roles to at least two users.
The user account that represents memoQ server (that is the service user) needs the following:
•Over the SQL Server, the preferred server-level role is sysadmin.
•Over the memoQ server database, the memoQ server service user must be db_owner.
The user who installs and manages memoQ server on the server computer needs the following:
•Over the SQL server, the minimum role is bulkadmin (to make backups of the database), the preferred privilege is sysadmin.
•Over the memoQ server database, the user needs to be db_owner.
To set these up, use the sqlcmd program. To learn more about the commands to set server-level and database-level roles, see the Useful SQL commands topic.