Installing SQL

You must have SQL installed to take advantage of server translation memory (TM) TM and termbases in Lingo. SQLite and SQL Express are the types of SQL supported.

[Menu Proxy — Headings — Online — Depth3 ]

SQL Lite (Local)

SQLite is a self-contained relational database system that is in the public domain. In Lingo, SQLite is intended for local TM databases and termbases, not those that reside on an external server. SQLite is easier and faster, just not quite as robust as SQL Express.

SQLite is automatically installed during the process of installing Lingo. For more information about this database system, see

By default, the location for SQLite databases is in “Documents\Lingo Translation Memories” on your computer. However, you can choose a different location if you like.

SQL Server Express (Server)

SQL Server Express is designed to be used on a server with Lingo. To download and install the latest version of SQL Server Express, go to

When installing SQL Server Express, it is recommended that you accept the default settings as you move through the installation wizard. If you want to explore any of the alternative options, please refer to the documentation provided with Microsoft SQL Server Express.

What’s Noteworthy?

Note If you are having difficulty connecting to a remote Lingo database, it may be due to the security setting of SQL. To view a remote server, you must have administrator rights on that server. You can add users to a local machine as administrators or add users in SQL Management Studio. To do this in Management Studio: (1) open SQL Server Management Studio (see for more information); (2) expand the server and then expand Security; you’ll probably have a login called "BUILTIN\Administrators," which will have "sysadmin" rights; in that case, any admin of your machine will have sysadmin rights because they’re part of that group; and (3) add anyone to this who will need to access your server.

Note If your database is not displaying when you are setting up TM, your SQL browser service may not be enabled. To enable this service: (1) open SQL Server Management Studio (see for more information), (2) open the SQL Server Configuration Manager, (3) open the SQL Server Browser and go to the Service tab, (4) change the Start Mode to Automatic, and (5) click Apply, and (6) start your SQL Server Browser.

Note If you are using Microsoft Server 2012 Standard, you cannot specify a folder to install TM into from a remote machine. Therefore, all TM databases are initially installed into the default SQL location.