Microsoft SQL Server Connection Parameters

By default, Microsoft SQL Server LocalDB is used to store ABBYY FineReader Server databases. However, LocalDB allows incoming connections only from a computer that has the Server Manager component installed, which means that LocalDB cannot be used with clusters.

Microsoft SQL Server 2014 (or later) can be used instead of LocalDB.

Connection to the database can be set up using a connection string and the DatabaseConnection tag in the %PROGRAMDATA%\ABBYY FineReader Server 14\Configuration.xml configuration file.

Connection parameters for Microsoft SQL Server LocalDB:

Parameter Value Description
DatabaseConnectionClass LocalDB.ConnectionClass
LocalDbVersion 12.0 Recommended LocalDB version number. If it is not detected, the latest detected version will be used instead.
LocalDbInstance FineReaderServer The name of the LocalDB server instance.
DatabasePath %PROGRAMDATA%\ ABBYY FineReader Server 14\Database Path to the database files.

Connection parameters for other versions of Microsoft SQL Server:

Parameter Value Description
DatabaseConnectionClass SqlServer.ConnectionClass
Datasource Server address. For example: 127.0.0.1, localhost\SQLDEV or DATASERVER\CompanySQL.
Database SQL Server database name.
Username SQL Server user's username. If left unspecified, Windows authentication will be used instead.
Password SQL Server user's password.

When using a connection string, specify the parameters in the <parameter>=<value> format, separating them by a semicolon (”;”).

Below is an example connection string for connecting to Microsoft SQL Server:

<DatabaseConnection>Datasource=DEVSERVER\SQLDEV;DatabaseConnectionClass=SqlServer.ConnectionClass;Database=FineReaderServer;Username=frsuser;Password=password</DatabaseConnection>

A database should be set up prior to connecting to Microsoft SQL Server, using a computer accessible to either:

  • the user specified in the connection string during the SQL Server authorization

or

  • the user whose Windows account was used to launch the Server Manager.

LocalDB cannot be used with clusters. A connection to Microsoft SQL Server is required instead.

3/26/2024 1:49:48 PM

Please leave your feedback about this article

Usage of Cookies. In order to optimize the website functionality and improve your online experience ABBYY uses cookies. You agree to the usage of cookies when you continue using this site. Further details can be found in our Privacy Notice.