SQL

This 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 www.sqlite.org.

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 is designed to be used on a server with Lingo. To download and install the latest version of SQL Server Express, go to http://www.microsoft.com/downloads/.

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.

If you are using Windows Vista or later versions, you do not automatically have administrative privileges when installing SQL Server 2012 Express. However, you can manually add yourself as an SQL Server administrator by using the following steps.

how to add yourself as an sql server administrator

1. Select Start>All Programs>Microsoft SQL Server 2012>SQL Server Surface Area Configuration.
2. Click Add New Administrator.
3. Highlight the server and click the button with the double arrows pointing to the right.
4. Click OK.